elektropay/neo4j-etl

Data import from relational databases to Neo4j.

Neo4j ETL

Neo4j ETL allows importing data from relational databases into Neo4j.

Features

• Neo4j-ETL UI in Neo4j Desktop

• Manage multiple RDBMS connections

• automatically extract database metadata from relational database

• derive graph model

• visually edit labels, relationship-types, property-names and types

• visualize current model as a graph

• persist mapping as json

• retrieve relevant CSV data from relational databases

• run import via neo4j-import, bolt-connector, cypher-shell, neo4j-shell

• bundles MySQL, PostgreSQL, allows custom JDBC driver with Neo4j Enterprise

License

This tool is licensed under the NEO4J PRE-RELEASE LICENSE AGREEMENT.

Issues & Feedback & Contributions

• You can raise GitHub issues or send feedback to [email protected]

• Please also join our Community Site ask in the appropriate category

Download & Run Command Line Tool

Download & unzip the latest neo4j-etl.zip.

Examples of command usage:

Minimal command line

./bin/neo4j-etl export \
 --rdbms:url <url> --rdbms:user <user> --rdbms:password <password> \
 --destination $NEO4J_HOME/data/databases/graph.db/ --import-tool $NEO4J_HOME/bin \
 --csv-directory $NEO4J_HOME/import

Full set of command line options

./bin/neo4j-etl export \
 --rdbms:url <url> --rdbms:user <user> --rdbms:password <password> --rdbms:schema <schema> \
 --using { bulk:neo4j-import | cypher:neo4j-shell | cypher:shell | cypher:direct } \
 --neo4j:url <neo4j url> --neo4j:user <neo4j user> --neo4j:password <neo4j password> \
 --destination $NEO4J_HOME/data/databases/graph.db/ --import-tool $NEO4J_HOME/bin \
 --csv-directory $NEO4J_HOME/import --options-file import-tool-options.json --force --debug

For detailed usage see also the: tool documentation.

Neo4j-Desktop

Install in Neo4j Desktop

Use the Application URL https://r.neo4j.com/neo4j-etl-app in the "Graph Apps" tab of Neo4j Desktop.

Then the next time you start Neo4j Desktop you’ll see Neo4j ETL as a UI to be used interactively.

Configure Driver	Load Mapping	Edit Mapping	Import Data

We put detailed usage instructions for the Neo4j ETL Tool in the Neo4j Developer Pages.

JDBC Drivers

The drivers for MySQL and PostgreSQL are bundled with the Neo4j-ETL tool.

To use other JDBC drivers use these download links and JDBC URLs. Provide the JDBC driver jar-file to the command line tool or Neo4j-ETL application. And use the JDBC-URL with the --rdbms:url parameter or in the JDBC-URL input field.

Database	JDBC-URL	Driver Source
Oracle	jdbc:oracle:thin:<user>/<pass>@<host>:<port>/<service_name>	Oracle JDBC Driver
MS SQLServer	jdbc:sqlserver://;servername=<servername>;databaseName=<database>;user=<user>;password=<pass>	SQLServer Driver
IBM DB2	jdbc:db2://<host>:<port/5021>/<database>:user=<user>;password=<pass>;	DB2 Driver
Derby	jdbc:derby:derbyDB	Included since JDK6
Cassandra	jdbc:cassandra://<host>:<port/9042>/<database>	Cassandra JDBC Wrapper
SAP Hana	jdbc:sap://<host>:<port/39015>/?user=<user>&password=<pass>	SAP Hana ngdbc Driver
MySQL	jdbc:mysql://<hostname>:<port/3306>/<database>?user=<user>&password=<pass>	MySQL Driver
PostgreSQL	jdbc:postgresql://<hostname>/<database>?user=<user>&password=<pass>	PostgreSQL JDBC Driver

For more information and help, see our developer guide on the Neo4j website.