Neo4j ETL now ready for the cloud
I’m happy to announce that the latest release (1.4.1) of the Neo4j-ETL tool (graph-app) now also works fine with remote databases.
Now you can import your relational data into any self-hosted or provisioned remote database in a few simple steps.
-
Add your remote database to Neo4j Desktop
-
Add the ETL-Tool to Neo4j Desktop and then your project. Best via the graph app gallery
-
Make sure the database is activated i.e. Desktop connected to a running database
-
Start the ETL tool
-
Add a JDBC connection to your RDBMS
-
Start the mapping process
-
Edit the relational to graph mapping as needed
-
Import the relational data via "Mode Batch" (you can leave the settings unchanged)
-
Done
We had to adapt two things to make this possible. Thanks a lot to our partners at Larus BA, Italy for working on these features.
In the past, the ETL-Tool used LOAD CSV
of a local file-url, which doesn’t work anymore if your database is remote and can’t access your local CSV files.
So we added a mode that reads the CSV locally and sends batches of rows as parameters to the remote Neo4j Database, where they are inserted using UNWIND
and MERGE
.
Secondly as Desktop doesn’t provide a local directory for remote databases to store mapping information, config and the CSV dump in, we use the temporary directory on your machine.
We also enabled support for the bolt+routing
scheme to connect to a causal cluster of Neo4j instances.

Please try out the ETL and let us know how it works for you for different relational databases and Neo4j deployments. If you encounter issues please raise them on GitHub.
Happy importing,
Michael
-
Last Modified: 2019-10-17 14:01:44 PDT by Michael Hunger.
-
Relevant for Neo4j Versions: {neo4j-versions}.
-
Relevant keywords aura, cloud, etl.
Comments
0 comments
Please sign in to leave a comment.