Importing Data from a Relational Database When you have a good understanding of your graph data model and feel that it accurately represents the data as it exists today, you are ready to transfer the data from the relational structure… Read more →

Importing Data from a Relational Database

When you have a good understanding of your graph data model and feel that it accurately represents the data as it exists today, you are ready to transfer the data from the relational structure to a graph!

There are 3 main approaches to moving relational data to a graph. We will briefly cover how each operates here, but a more detailed walkthrough is in the linked pages.

1) LOAD CSV: possibly the simplest way to import data from your relational database. Requires a dump of individual entity-tables and join-tables formatted as CSV files.

2) APOC: Awesome Procedures on Cypher. Created as an extension library to provide common procedures and functions to developers. Useful procedures include apoc.load.jdbc, apoc.load.csv, apoc.load.json, and others.

3) ETL Tool: internally-built UI tool that translates relational to graph from a JDBC connection. Allows bulk data import for large data sets with a fast performance and simple user experience.