# ETL-Tool

**URL:** https://community.neo4j.com/c/neo4j-graph-platform/etl/74.md

[Latest](https://community.neo4j.com/latest.md) · [Categories](https://community.neo4j.com/categories.md) · [Tags](https://community.neo4j.com/tags.md)

---

## [About the ETL-Tool category](https://community.neo4j.com/t/about-the-etl-tool-category/85)

<div class="topic-metadata">

**Author:** [@michael.hunger](https://community.neo4j.com/u/michael.hunger)\
**Replies:** 0\
**Last updated:** [June 13, 2018, 4:13pm UTC](https://community.neo4j.com/t/about-the-etl-tool-category/85 "2018-06-13T16:13:34Z")

</div>

Questions around ETL with Neo4j. For bugs please raise a GH issue ETL from RDBMS If you need a activation for Neo4j ETL Desktop ask someone from the Neo4j Staff ETL tool: Documenation | GitHub Introduction Article Yo…

---

## [I want to discuss regarding ETL, I have data from postgre to neo4j but taking lot of time, I have used databricks spark dataframe please suggest me which approach is more suitable?](https://community.neo4j.com/t/i-want-to-discuss-regarding-etl-i-have-data-from-postgre-to-neo4j-but-taking-lot-of-time-i-have-used-databricks-spark-dataframe-please-suggest-me-which-approach-is-more-suitable/76216)

<div class="topic-metadata">

**Author:** [@ronakpanchal](https://community.neo4j.com/u/ronakpanchal)\
**Replies:** 1\
**Last updated:** [January 7, 2026, 10:38am UTC](https://community.neo4j.com/t/i-want-to-discuss-regarding-etl-i-have-data-from-postgre-to-neo4j-but-taking-lot-of-time-i-have-used-databricks-spark-dataframe-please-suggest-me-which-approach-is-more-suitable/76216 "2026-01-07T10:38:36Z")

</div>

I want to discuss regarding ETL, I have data from postgre to neo4j but taking lot of time, I have used databricks spark dataframe please suggest me which approach is more suitable?

---

## [Failed to import records from mysql to neo4j desktop by ETL](https://community.neo4j.com/t/failed-to-import-records-from-mysql-to-neo4j-desktop-by-etl/69457)

<div class="topic-metadata">

**Author:** [@Liu](https://community.neo4j.com/u/Liu)\
**Replies:** 0\
**Last updated:** [August 29, 2024, 2:41am UTC](https://community.neo4j.com/t/failed-to-import-records-from-mysql-to-neo4j-desktop-by-etl/69457 "2024-08-29T02:41:47Z")

</div>

Hi everyone, I wanted to import records from mysql into my neo4j using neo4j-import tool for initial offline bulk load. An error occurred while importing： "- Creating Neo4j store from CSV... Trying to retrieve JDK 11…

---

## [NEO4J ETL \_Change Relationship Direction](https://community.neo4j.com/t/neo4j-etl-change-relationship-direction/67017)

<div class="topic-metadata">

**Author:** [@salma.almuhtaseb](https://community.neo4j.com/u/salma.almuhtaseb)\
**Replies:** 0\
**Last updated:** [March 25, 2024, 11:53am UTC](https://community.neo4j.com/t/neo4j-etl-change-relationship-direction/67017 "2024-03-25T11:53:00Z")

</div>

How can I change the direction of the relationship in the NEO4J ETL tool? In the Explore and Change your METADATA page?

---

## [ETL-Tool Mapping Error from Oracle DB](https://community.neo4j.com/t/etl-tool-mapping-error-from-oracle-db/62244)

<div class="topic-metadata">

**Author:** [@ozanbicer](https://community.neo4j.com/u/ozanbicer)\
**Replies:** 1\
**Last updated:** [December 26, 2023, 11:49am UTC](https://community.neo4j.com/t/etl-tool-mapping-error-from-oracle-db/62244 "2023-12-26T11:49:04Z")

</div>

I'm trying to import data from RDBMS to Neo4j using ETL-Tool. I've added the database connection. But can't start mapping. Error log says I should add orai18n.jar to my classpath. I've added the path of orai18n.jar file …

---

## [Streaming and Batching Results of a Query](https://community.neo4j.com/t/streaming-and-batching-results-of-a-query/65247)

<div class="topic-metadata">

**Author:** [@Hatem](https://community.neo4j.com/u/Hatem)\
**Replies:** 0\
**Last updated:** [December 5, 2023, 5:17pm UTC](https://community.neo4j.com/t/streaming-and-batching-results-of-a-query/65247 "2023-12-05T17:17:00Z")

</div>

Hello, I'm using the latest version of Neo4j container, I send queries to the database server using the Python connector. I have been googling and reading how to implement two use cases, but I didn't find any clear answ…

---

## [How do i modify the creation of data graph model while using the Neo4j ETL Tool](https://community.neo4j.com/t/how-do-i-modify-the-creation-of-data-graph-model-while-using-the-neo4j-etl-tool/63759)

<div class="topic-metadata">

**Author:** [@sr602008](https://community.neo4j.com/u/sr602008)\
**Replies:** 2\
**Last updated:** [November 30, 2023, 1:22pm UTC](https://community.neo4j.com/t/how-do-i-modify-the-creation-of-data-graph-model-while-using-the-neo4j-etl-tool/63759 "2023-11-30T13:22:31Z")

</div>

I am importing data from My SQL to neo4j graph database using the ETL Tool present in the Neo4j Desktop.While doing so...4 of the tables that are present in my relational database have been converted to nodes.While the o…

---

## [Neo4j-ETL import error from MySql 'Invalid constraint syntax'](https://community.neo4j.com/t/neo4j-etl-import-error-from-mysql-invalid-constraint-syntax/63167)

<div class="topic-metadata">

**Author:** [@uczcedx](https://community.neo4j.com/u/uczcedx)\
**Replies:** 3\
**Last updated:** [July 31, 2023, 9:52pm UTC](https://community.neo4j.com/t/neo4j-etl-import-error-from-mysql-invalid-constraint-syntax/63167 "2023-07-31T21:52:13Z")

</div>

Hi everyone, I have tried to import database from Mysql to Neo4j, but there are some error report by logs. Some keys has properties in MySql as unique, and these properties seems cant be import with syntax error. But I…

---

## [Neo4j-etl admin database import problems](https://community.neo4j.com/t/neo4j-etl-admin-database-import-problems/62874)

<div class="topic-metadata">

**Author:** [@ozanbicer](https://community.neo4j.com/u/ozanbicer)\
**Replies:** 4\
**Last updated:** [June 14, 2023, 11:04am UTC](https://community.neo4j.com/t/neo4j-etl-admin-database-import-problems/62874 "2023-06-14T11:04:56Z")

</div>

Hi everyone, I've been trying to import bulk data into Neo4j 5.8.0 DB with neo4j-admin database import command. But there is something I want to ask. With 'neo4j-admin database import full' command, I'm able to import …

---

## [ETL Tool Importing Massive Size Data & Constraint Error](https://community.neo4j.com/t/etl-tool-importing-massive-size-data-constraint-error/62761)

<div class="topic-metadata">

**Author:** [@ozanbicer](https://community.neo4j.com/u/ozanbicer)\
**Replies:** 2\
**Last updated:** [June 2, 2023, 12:13pm UTC](https://community.neo4j.com/t/etl-tool-importing-massive-size-data-constraint-error/62761 "2023-06-02T12:13:01Z")

</div>

Hey everyone, I'm working on importing a database from Oracle to Neo4j Desktop with ETL Tool Graph App. I've got 2 issues with that. First one is when I import the data, I get this error even though import is complete…

---

## [Cypher queries using multiple CPU cores](https://community.neo4j.com/t/cypher-queries-using-multiple-cpu-cores/62282)

<div class="topic-metadata">

**Author:** [@tnnandi](https://community.neo4j.com/u/tnnandi)\
**Replies:** 0\
**Last updated:** [April 28, 2023, 5:46pm UTC](https://community.neo4j.com/t/cypher-queries-using-multiple-cpu-cores/62282 "2023-04-28T17:46:28Z")

</div>

Hi, I am new to neo4j and interested to carry out cypher queries for large knowledge graphs in a parallel manner on HPC clusters. Can someone please let me know if the free community version of neo4j graph data platform…

---

## [Neo4j ETL tool (data import error)](https://community.neo4j.com/t/neo4j-etl-tool-data-import-error/61381)

<div class="topic-metadata">

**Author:** [@marudevansh77](https://community.neo4j.com/u/marudevansh77)\
**Replies:** 2\
**Last updated:** [March 15, 2023, 11:18am UTC](https://community.neo4j.com/t/neo4j-etl-tool-data-import-error/61381 "2023-03-15T11:18:55Z")

</div>

when i tried to import data from RDBMS to graph database with the help of ETL tool at the end,i get this type of error java -cp "C:\\Users\\ADMIN.Neo4jDesktop\\graphApps\_global\\neo4j-etl-ui/dist/neo4j-etl.jar" org.neo4j.et…

---

## [NullPointerException and IOException for some files using neo4j-ETL-tool](https://community.neo4j.com/t/nullpointerexception-and-ioexception-for-some-files-using-neo4j-etl-tool/54079)

<div class="topic-metadata">

**Author:** [@flippzz](https://community.neo4j.com/u/flippzz)\
**Replies:** 0\
**Last updated:** [March 29, 2022, 10:17am UTC](https://community.neo4j.com/t/nullpointerexception-and-ioexception-for-some-files-using-neo4j-etl-tool/54079 "2022-03-29T10:17:13Z")

</div>

Hi, I am trying to import an mysql-database using the neo4j-ETL-tool. The logs shows that the CVS etc are created, also several nodes and relationships are creatd, but I get a lot of these messages at the end: - Data i…

---

## [Import records from multiple db's at once](https://community.neo4j.com/t/import-records-from-multiple-dbs-at-once/47849)

<div class="topic-metadata">

**Author:** [@alexpappasc](https://community.neo4j.com/u/alexpappasc)\
**Replies:** 3\
**Last updated:** [November 22, 2021, 10:52pm UTC](https://community.neo4j.com/t/import-records-from-multiple-dbs-at-once/47849 "2021-11-22T22:52:46Z")

</div>

Hi everyone, I wanted to ask if there is any possible way to import records from multiple rdb's into my neo4j using neo4j-import tool for initial offline bulk load. I know there are other options available to import dat…

---

## [How to get neo4j configured with Pentaho Data Integration (PDI)](https://community.neo4j.com/t/how-to-get-neo4j-configured-with-pentaho-data-integration-pdi/46405)

<div class="topic-metadata">

**Author:** [@pdrangeid](https://community.neo4j.com/u/pdrangeid)\
**Replies:** 0\
**Last updated:** [October 25, 2021, 2:23pm UTC](https://community.neo4j.com/t/how-to-get-neo4j-configured-with-pentaho-data-integration-pdi/46405 "2021-10-25T14:23:44Z")

</div>

First there's a Very quick how to: Configuring Pentaho Data Integration (PDI) on Windows Then the N4j specific: Configure Neo4j 4.x database connection in PDI Appreciate any feedback... Nothing very in-depth, but mostl…

---

## [Import from POSTGRESQL fails with unhelpful error message](https://community.neo4j.com/t/import-from-postgresql-fails-with-unhelpful-error-message/30696)

<div class="topic-metadata">

**Author:** [@kevin3](https://community.neo4j.com/u/kevin3)\
**Replies:** 5\
**Last updated:** [October 19, 2021, 1:16pm UTC](https://community.neo4j.com/t/import-from-postgresql-fails-with-unhelpful-error-message/30696 "2021-10-19T13:16:02Z")

</div>

I was able to create a connection to my existing POSTGRESQL database and map the desired tables, but the IMPORT DATA step fails, and the log only shows: COMMAND: java -cp "XXXX/Library/Application Support/Neo4j Desktop/…

---

## [NEO4J-ETL Import error with null pointer exception](https://community.neo4j.com/t/neo4j-etl-import-error-with-null-pointer-exception/39587)

<div class="topic-metadata">

**Author:** [@EllieMwangi](https://community.neo4j.com/u/EllieMwangi)\
**Replies:** 2\
**Last updated:** [October 19, 2021, 1:14pm UTC](https://community.neo4j.com/t/neo4j-etl-import-error-with-null-pointer-exception/39587 "2021-10-19T13:14:27Z")

</div>

Hi everyone, I'm trying to import data from a MySQL local database version 8.0.21 to Neo4j using the neo4j etl tool version 1.5.1 on the neo4j desktop version 4.2.5. I get this error when I try to import data using dire…

---

## [Add relationship by hand with Neo4j ETL](https://community.neo4j.com/t/add-relationship-by-hand-with-neo4j-etl/3634)

<div class="topic-metadata">

**Author:** [@m-kiuchi](https://community.neo4j.com/u/m-kiuchi)\
**Replies:** 7\
**Last updated:** [October 10, 2021, 2:39am UTC](https://community.neo4j.com/t/add-relationship-by-hand-with-neo4j-etl/3634 "2021-10-10T02:39:18Z")

</div>

Hi all, I'm started to try Neo4j ETL from Neo4j Desktop. I've successfully imported source tables from MariaDB, but no relationship is generated. I looked around Neo4j Desktop UI(drag, right-click, and so on...), but c…

---

## [ETL Tool on Mac - Where do I install additional JDBC drivers?](https://community.neo4j.com/t/etl-tool-on-mac-where-do-i-install-additional-jdbc-drivers/44985)

<div class="topic-metadata">

**Author:** [@stevenwolfe](https://community.neo4j.com/u/stevenwolfe)\
**Replies:** 1\
**Last updated:** [September 27, 2021, 3:29pm UTC](https://community.neo4j.com/t/etl-tool-on-mac-where-do-i-install-additional-jdbc-drivers/44985 "2021-09-27T15:29:30Z")

</div>

I'm trying out the Neo4j Desktop ETL Tool and need to connect to a MS SQL Server database. When I setup a new connection in the tool and try to connect it errors with: Connection failed. No suitable driver for the con…

---

## [ETL MSSQL Connection Error](https://community.neo4j.com/t/etl-mssql-connection-error/40786)

<div class="topic-metadata">

**Author:** [@Tim71](https://community.neo4j.com/u/Tim71)\
**Replies:** 2\
**Last updated:** [July 7, 2021, 9:13am UTC](https://community.neo4j.com/t/etl-mssql-connection-error/40786 "2021-07-07T09:13:51Z")

</div>

Hi I am getting the following error when attempting to connect to a local MSSQL 2016 database through the Neo4j ETL Tool: Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/bind/DatatypeConverter at …

---

## [I'am having a blank screen when using ETL Tool of Neo4j](https://community.neo4j.com/t/iam-having-a-blank-screen-when-using-etl-tool-of-neo4j/25454)

<div class="topic-metadata">

**Author:** [@dorra.mahfoudhi](https://community.neo4j.com/u/dorra.mahfoudhi)\
**Replies:** 1\
**Last updated:** [March 24, 2021, 4:53pm UTC](https://community.neo4j.com/t/iam-having-a-blank-screen-when-using-etl-tool-of-neo4j/25454 "2021-03-24T16:53:27Z")

</div>

I'm having and issue with ETL Tool : I'm trying to import an sql server database into the ETL Tool. The connection is successfully established. I started the mapping but when I click on the button "Save Mapping" I'm gett…

---

## [ETL stucks at Mapping - No error](https://community.neo4j.com/t/etl-stucks-at-mapping-no-error/34115)

<div class="topic-metadata">

**Author:** [@michalis](https://community.neo4j.com/u/michalis)\
**Replies:** 12\
**Last updated:** [March 5, 2021, 8:22am UTC](https://community.neo4j.com/t/etl-stucks-at-mapping-no-error/34115 "2021-03-05T08:22:04Z")

</div>

Hi all, I am using Neo4j Desktop and I want to create a mapping between a remote DB (Postgres) and my local Neo4j Graph DB. For that, I am using the ETL Tool. Three days ago, everything worked fine and I was able to i…

---

## [Neo4j and Snowflake Cloud Database](https://community.neo4j.com/t/neo4j-and-snowflake-cloud-database/8525)

<div class="topic-metadata">

**Author:** [@lpfrnk](https://community.neo4j.com/u/lpfrnk)\
**Replies:** 3\
**Last updated:** [February 10, 2021, 12:24pm UTC](https://community.neo4j.com/t/neo4j-and-snowflake-cloud-database/8525 "2021-02-10T12:24:53Z")

</div>

Trying to get Neo4j ETL to function with Snowflake. Is the source code available? or can the connection be evaluated? The system is unable to read the tables. It is able to identify the available schemas. 90.9% - 00:0…

---

## [Neo4j ETL tool not able to import data of Online PostgreSQL database. Data imported with errors.NullPointerException](https://community.neo4j.com/t/neo4j-etl-tool-not-able-to-import-data-of-online-postgresql-database-data-imported-with-errors-nullpointerexception/33148)

<div class="topic-metadata">

**Author:** [@priyankeshraj](https://community.neo4j.com/u/priyankeshraj)\
**Replies:** 3\
**Last updated:** [February 4, 2021, 4:22pm UTC](https://community.neo4j.com/t/neo4j-etl-tool-not-able-to-import-data-of-online-postgresql-database-data-imported-with-errors-nullpointerexception/33148 "2021-02-04T16:22:01Z")

</div>

I am importing my online postgreSQL database into my Neo4j database using the Neo-4j ETL Tool. I am using PgAdmin 4.30 for postgreSQL 13 and Neo4j 1.4.1. The ETL Tool says Connection myconn saved. Connection successf…

---

## [Expected time to complete mapping](https://community.neo4j.com/t/expected-time-to-complete-mapping/5003)

<div class="topic-metadata">

**Author:** [@alcampopiano](https://community.neo4j.com/u/alcampopiano)\
**Replies:** 8\
**Last updated:** [December 31, 2020, 9:52am UTC](https://community.neo4j.com/t/expected-time-to-complete-mapping/5003 "2020-12-31T09:52:14Z")

</div>

Hi all, I'm using the ETL tool to map my organization's relational database. Their database has decades of data across roughly 7000 tables. I am currently doing the mapping step (not the importing) and it has been runn…

---

## [Migration from Neo4j to Relational DB?](https://community.neo4j.com/t/migration-from-neo4j-to-relational-db/3110)

<div class="topic-metadata">

**Author:** [@Powers-RC](https://community.neo4j.com/u/Powers-RC)\
**Replies:** 3\
**Last updated:** [December 9, 2020, 8:35pm UTC](https://community.neo4j.com/t/migration-from-neo4j-to-relational-db/3110 "2020-12-09T20:35:05Z")

</div>

I am curious if there are tools to migrate/populate a relational database from Neo4j? I have seen numerous articles on migrating from a RDBMS to Neo4j, but not the other way around. Looking to use the relational database…

---

## [Importing Data using ETL tool](https://community.neo4j.com/t/importing-data-using-etl-tool/27972)

<div class="topic-metadata">

**Author:** [@akaur](https://community.neo4j.com/u/akaur)\
**Replies:** 4\
**Last updated:** [November 29, 2020, 2:01am UTC](https://community.neo4j.com/t/importing-data-using-etl-tool/27972 "2020-11-29T02:01:00Z")

</div>

Hi, I am trying to export data from MS SQL. And I am getting an error while establishing the connection- Error: Could not find or load main class org.neo4j.etl.rdbms.Support I am not sure what the error refers to?

---

## [Datetime issue - Import data from SQL Server](https://community.neo4j.com/t/datetime-issue-import-data-from-sql-server/1400)

<div class="topic-metadata">

**Author:** [@harvey\_nguyen](https://community.neo4j.com/u/harvey_nguyen)\
**Replies:** 8\
**Last updated:** [November 4, 2020, 1:09pm UTC](https://community.neo4j.com/t/datetime-issue-import-data-from-sql-server/1400 "2020-11-04T13:09:59Z")

</div>

I am using neo4j-admin import tool to import data from large csv files. These files are exported from SQL Server. The problem that I am facing is different format between SQL and Neo4j: In SQL Server, datetime field is…

---

## [ETL mysql Connection failed. SQL state 08001. How to find my JDBC driver?](https://community.neo4j.com/t/etl-mysql-connection-failed-sql-state-08001-how-to-find-my-jdbc-driver/19087)

<div class="topic-metadata">

**Author:** [@david.strayhorn4](https://community.neo4j.com/u/david.strayhorn4)\
**Replies:** 2\
**Last updated:** [October 28, 2020, 2:41pm UTC](https://community.neo4j.com/t/etl-mysql-connection-failed-sql-state-08001-how-to-find-my-jdbc-driver/19087 "2020-10-28T14:41:04Z")

</div>

Hello everyone, I am having trouble using the ETL Tool to connect from my laptop at home to the MySQL database on my remote hosted linux server. When I get to the point of adding the connection, I get the error: "Conne…

---

## [Can I load from rdbms (oracle) views (not tables)?](https://community.neo4j.com/t/can-i-load-from-rdbms-oracle-views-not-tables/26141)

<div class="topic-metadata">

**Author:** [@jdickson007](https://community.neo4j.com/u/jdickson007)\
**Replies:** 1\
**Last updated:** [October 1, 2020, 3:20am UTC](https://community.neo4j.com/t/can-i-load-from-rdbms-oracle-views-not-tables/26141 "2020-10-01T03:20:59Z")

</div>

Desktop 1.3.8 I have successfully loaded from Oracle tables Oracle schema is snowflake : fact \> dim\_account -\> dim\_customer I want to pre-join account and customer on oracle side (in a view) then load that into neo4j …

[Next page](https://community.neo4j.com/c/neo4j-graph-platform/etl/74.md?page=1)
