Migrate from OrientDB to AWS Neptune

Question

I need to migrate a database from OrientDB to Neptune. I have an exported JSON file from Orient that contains the schema (classes) and the records - I now need to import this into Neptune. However, it seems that to import data into Neptune there must be a csv file containing all the vertex's and another file containing all the edges.

Are there any existing tools to help with this migration and converting to the required files/format?

Are you able to export anything other than JSON? If you can export GraphML there is an open source tool that can turn that into the appropriate CSV files. — Kelvin Lawrence, Aug 17 '21 at 12:22
@KelvinLawrence I've just seen that it might be possible using Gremlin to export GraphML (XML). Do you have a link to that tool? — Mark, Aug 17 '21 at 14:07

Kelvin Lawrence · Answer 1 · 2021-08-17T15:16:16.497

1

If you are able to export the data as GraphML then you can use the GraphML2CSV tool. It will create a CSV file for the nodes and another for the edges with the appropriate header rows.

Keep in mind that GraphML is a lossy format (it cannot describe complex Java types the way GraphSON can) but you would not be able to import those into Neptune either.

edited Aug 17 '21 at 15:16

answered Aug 17 '21 at 15:06

Kelvin Lawrence

14,674
2
16
38

Migrate from OrientDB to AWS Neptune

1 Answers1