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?
206 Views Asked by Demtron At
1
There are 1 best solutions below
Related Questions in ORIENTDB
- OrientDB - SQL command to pass array value as parameter in OrientDB function
- Error while creating database on OrientDB
- Create a vertex with Label in Gremlin
- OrientDB Execute a Script from a Text (.osql) File
- How to retrieve data from orientdb database to a list from two clusters that are linked with a edge?
- How to access results within batch statements in oriento
- OrientDB graph operations via REST API
- Get all used fieldnames of schema-hybrid Class in Orientdb
- How to do sharding and replication of Orient DB database
- select properties of the vertice that has out with specified @rid
- which data type in orient db for @rid?
- Understand orient-db logic
- Embedded Set,Link Set in OType in OrientDb
- NodeJS: How to improve error handling when writing a model class for OrientDB
- $parent and $ current in orientDB query
Related Questions in ORIENTDB-ETL
- OrientDB Community Edition Synchronization
- Identifying if 2 Vertices are connected with edge using Orientdb 3 and tinkerpop 3
- Persist database after ETL OrientDB
- Stopping OrientDB service fails, ETL import not possible
- How to import Edges from CSV with ETL into OrientDB graph?
- Orientdb 3.0.26 OETL JDBC oracle Driver not found
- OrientDB import edges only using ETL tool
- Using OrientDB ETL to load file of Edges
- OrientDB ETL: how to skip a duplicate vertex but create the edge
- OrientDB 2.2.7 ETL for CSV not loading DateTime field?
- Performance tuning for loading Gigabytes of data in OrientDB
- What _targetVertexFields_ parameter of edge transformer in Orientdb do?
- OrientDB data write from CSV files
- Importing SQL Server SQL_VARIANT data type to OrientDB vertex - which property type should I use?
- OrientDB ETL - postgres - "canceling statement due to conflict with recovery"
Related Questions in SQL-VARIANT
- Get the non empty data from a sql_varient column
- PyMsSQL reading bad data for sql_variant columns
- How can I set column type when using SqlBulkCopy to insert into a sql_variant column
- Entity Framework sql_variant as primary key
- linq with Any and sql_variants
- How to query a table that contains sql_variant in sqlalchemy
- Convert byte array represented for sql_variant typed column value to long/int64
- Non-dynamic way to change sql_variant collation and keep type and size
- Filtering data on date but showing all values except one in query if date doesn't match [SQL & C#]
- Is there a way in Django to always CAST a specific Field to VARCHAR?
- How to create a subset from a variant column in snowflake?
- SQL 2005 - Variant Parameter Question
- sql_variant and real and float in combination with WHERE smaller statements
- i need use sql_variant in entity framework code first
- What is the cost in bytes for the overhead of a sql_variant column in SQL Server?
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 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