= Neo4j ETL :img: docs/img
Neo4j ETL allows importing data from relational databases into Neo4j.
== Features
== License
This tool is licensed under the link:LICENSE.txt[NEO4J PRE-RELEASE LICENSE AGREEMENT].
== Issues & Feedback & Contributions
== Download & Run Command Line Tool
Download & unzip the latest https://github.com/neo4j-contrib/neo4j-etl/releases/latest[neo4j-etl.zip^].
== Examples of command usage:
cypher:batch
and cypher:fromSQL
import modes:For detailed usage see also the: http://neo4j-contrib.github.io/neo4j-etl#neo4j-etl-cli[tool documentation].
== Neo4j-Desktop
Use the Application URL https://r.neo4j.com/neo4j-etl-app
in the "Graph Apps" tab of Neo4j Desktop.
image:{img}/neo4j-etl-install.jpg[width=400] image:{img}/graph-app-icon.jpg[width=400]
Then the next time you start Neo4j Desktop you'll see Neo4j ETL as a UI to be used interactively.
[cols="4*^.^",opts=header] |=== | Configure Driver | Load Mapping | Edit Mapping | Import Data | image:{img}/driver.jpg[width=200] | image:{img}/load-mapping.jpg[width=200] | image:{img}/edit-mapping.jpg[width=200] | image:{img}/import-data.jpg[width=200] |===
//// .Location of $DESKTOP |=== | macOS | ~/Library/Application Support/Neo4j Desktop | | Windows | %APPDATA%/Neo4j Desktop | | Linux | ~/.config/Neo4j Desktop | |=== ////
We put https://neo4j.com/developer/neo4j-etl[detailed usage instructions for the Neo4j ETL Tool] in the Neo4j Developer Pages.
//// If you want to test changes to the Neo4j Desktop UI, you can try:
== 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.
[options="header",cols="a,3m,a"] |=== |Database | JDBC-URL | Driver Source
|Oracle |jdbc:oracle:thin:/@:/<service_name> |http://www.oracle.com/technetwork/database/features/jdbc/index.html[Oracle JDBC Driver^]
|MS SQLServer |jdbc:sqlserver://;servername=;databaseName=;user=;password= |https://www.microsoft.com/en-us/download/details.aspx?id=11774[SQLServer Driver^]
|IBM DB2 |jdbc:db2://:<port/5021>/:user=;password=; |http://www-01.ibm.com/support/docview.wss?uid=swg21363866[DB2 Driver^]
|Derby |jdbc:derby:derbyDB |Included since JDK6
|Cassandra |jdbc:cassandra://:<port/9042>/ |link:https://github.com/adejanovski/cassandra-jdbc-wrapper#installing[Cassandra JDBC Wrapper^]
|SAP Hana |jdbc:sap://:<port/39015>/?user=&password= |https://www.sap.com/developer/tutorials/hxe-connect-hxe-using-jdbc.html[SAP Hana ngdbc Driver^]
|MySQL |jdbc:mysql://:<port/3306>/?user=&password= |http://dev.mysql.com/downloads/connector/j/[MySQL Driver^]
|PostgreSQL |jdbc:postgresql:///?user=&password= |https://jdbc.postgresql.org/download.html[PostgreSQL JDBC Driver^]
|===