Search code examples
jdbcorientdborientdb-etl

OrientDB - Import from an RDBMS (sql server)

How I would go about loading data from and SQL database where the table name is the node class, columns are the attributes of the node class and the rows in the table are individual instances of that node class?

I have had a look on the OrientDB website for help and the relevant page wasn't not very helpful

Thanks,

Bikrum

Solution

  • The easiest way is use OrientDB Teleporter.

    Teleporter is an automatic tool that connects to the JDBC source (the relational database), analyzes the db schema, creates a corresponding graph schema (eg. vertex classes for tables, edge classes for forieign keys or join tables ) and then copies all the data to OrientDB.

    There is a visual tool that lets you fine tune all the details of the migration, that is included in OrientDB Studio, so it's in the bundle.

    Since v 2.2.25 it's available in the Community Edition

    From Studio login page just click on the RDBMS button (top right of the login form) and follow the guided steps.

    Here is a reference to the docs: http://orientdb.com/docs/2.2.x/Studio-Teleporter.html