Neo4j ETL is now ready for the cloud
Since release (1.4.1) of the Neo4j-ETL tool (graph-app) also works fine with remote databases like AuraDB Instances.
Add your remote AuraDB Instance to Neo4j Desktop
Make sure the AuraDB Instance is activated i.e. Desktop connected to a running AuraDB Instance.
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)
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 AuraDB Instance, where they are inserted using
Secondly, as Desktop doesn’t provide a local directory for remote AuraDB Instances to store mapping information, config and the CSV dump in, we use the temporary directory on your machine.
We have also enabled support for the
neo4j URI 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.