I am evaluating OrientDB as a replacement for MS SQL Server. One of the SQL Server tables I need to import into OrientDB contains time-series data with the value column using a SQL_VARIANT data type. I'm struggling to identify the best data type to use for the equivalent property in a new OrientDB vertex. I'm hesitant to convert it a STRING, but I don't see an equivalent variant type. Any recommendations?
Importing SQL Server SQL_VARIANT data type to OrientDB vertex - which property type should I use?
208 Views Asked by Demtron At
1
There are 1 best solutions below
Related Questions in ORIENTDB
- "CREATE SECURITY POLICY" unrecognized in OrientDB 3.2.27
- Orient DB OStorageRemotePushThread.subscribe threads locked
- How to get OrientDB Server Side OGlobalConfiguration on orientdb client?
- How to find all nodes which linked by edge with exact property in OrientDB?
- OrientDB connections not getting closed on close API
- Select all vertices connected via an edge and order by edge attribute
- Light Gremlin Server - GraphDB / Access via Node.Js Gremlin Lib
- OrientDB v3.2.21 - No more resources available in pool (max = 50)
- OrientDB v3 set auto transaction to false with tinkerpop 3.0
- OrientDB traverse from variable
- Convert a Spark Dataset column from a UDT to Array<String>
- Mutual nodes order by occurrence orientdb
- Basic orient select / traverse
- Mixed Graph and relational environment
- How to rewrite OrientDB query to Gremlin (TinkerPop)?
Related Questions in ORIENTDB-ETL
- orientdb oetl error / I want to have pokec data
- OrientDB ETL - postgres - "canceling statement due to conflict with recovery"
- Orientdb 3.0.26 OETL JDBC oracle Driver not found
- Identifying if 2 Vertices are connected with edge using Orientdb 3 and tinkerpop 3
- Importing SQL Server SQL_VARIANT data type to OrientDB vertex - which property type should I use?
- OrientDB data write from CSV files
- Persist database after ETL OrientDB
- What _targetVertexFields_ parameter of edge transformer in Orientdb do?
- How to load a huge CSV file in orient db
- Traverse through vertices using SELECT query, just like MATCH. Is it possible?
- OStorageException occurs while creating a vertex using the etl process in Orientdb
- OrientDB Community Edition Synchronization
- OrientDB ETL, create edge between two vertices which are already in Graph
- OrientDB - Import from an RDBMS (sql server)
- How to import Edges from CSV with ETL into OrientDB graph?
Related Questions in SQL-VARIANT
- How to convert sql_variant so it can be considered deterministic
- sql_variant and real and float in combination with WHERE smaller statements
- Entity Framework sql_variant as primary key
- Non-dynamic way to change sql_variant collation and keep type and size
- I want to use SQL_VARIANT datatype in external table Azure SQL and I get the "Index was out of range error."
- How to create a subset from a variant column in snowflake?
- SQL_VARIANT and DATETIME2
- Is there a way in Django to always CAST a specific Field to VARCHAR?
- How to Handle sql_Variant sql datatype using Powershell
- Importing SQL Server SQL_VARIANT data type to OrientDB vertex - which property type should I use?
- PostgreSQL Function that updates a specific column of a row
- How do you properly handle SQL_VARIANT in Entity Framework Core?
- Problems passing variables into a stored procedure as sql_variant type
- How to query a table that contains sql_variant in sqlalchemy
- Mismatch on SQL_variant and DT_WSTR in BIDS Manager
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
OrientDB Teleporter is a tool that synchronizes a RDBMS to OrientDB database. You can use Teleporter to:
NOTE: This feature is available both for the OrientDB Enterprise Edition and the OrientDB Community Edition. But beware: in community edition you can migrate your source relational database but you cannot enjoy the synchronize feature, only available in the enterprise edition.
How Teleporter works
Teleporter looks for the specific DBMS meta-data in order to perform a logical inference of the source DB schema for the building of a corresponding graph model. Eventually the data importing phase is performed.
Teleporter has a pluggable importing strategy. Two strategies are provided out of the box:
For more information: http://orientdb.com/docs/3.0.x/teleporter/Teleporter-Home.html
Hope it helps
Regards