ETL Tool vs APOC vs some other tools?

I think it makes more sense to use a script with APOC or a client side script if you need fine grained control and custom import.

The ETL tool is more suited for an initial import, although you can use the command line version also repeatedly with a once generated mapping file.
And if you edit the mapping file you could even change the generated SQL statements to check an update-timestamp or a to-sync flag.

The command-line ETL tool also has a mode of using "cypher-shell" to execute a script to load the data, you could pick up that script which is saved into the import directory of your database.

1 Like