# \#etl **URL:** https://community.neo4j.com/tag/etl/52.md [Latest](https://community.neo4j.com/latest.md) · [Categories](https://community.neo4j.com/categories.md) · [Tags](https://community.neo4j.com/tags.md) --- ## [Joomla to Neo4j](https://community.neo4j.com/t/joomla-to-neo4j/65534)
**Author:** [@guille\_rr](https://community.neo4j.com/u/guille_rr)\ **Replies:** 0\ **Last updated:** [December 28, 2023, 10:52am UTC](https://community.neo4j.com/t/joomla-to-neo4j/65534 "2023-12-28T10:52:47Z")
Hi all, Is there any way to save data from a Joomla form in Neo4j directly? Thanks --- ## [Use current BATCH iterative number (integer) WITHIN an apoc.periodic.iterate action](https://community.neo4j.com/t/use-current-batch-iterative-number-integer-within-an-apoc-periodic-iterate-action/63419)
**Author:** [@pdrangeid](https://community.neo4j.com/u/pdrangeid)\ **Replies:** 2\ **Last updated:** [July 31, 2023, 2:36pm UTC](https://community.neo4j.com/t/use-current-batch-iterative-number-integer-within-an-apoc-periodic-iterate-action/63419 "2023-07-31T14:36:02Z")
Within the action portion of an apoc.period.iterate I am performing an apoc.export.json.query. I want the resulting filename to iterate along with the periodic.iterate batches. The method I've used so far is making the… --- ## [Neo4j-etl admin database import problems](https://community.neo4j.com/t/neo4j-etl-admin-database-import-problems/62874)
**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")
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 … --- ## [MS SQL to Neo4J ETL automated pipeline](https://community.neo4j.com/t/ms-sql-to-neo4j-etl-automated-pipeline/61574)
**Author:** [@marcusleongwh](https://community.neo4j.com/u/marcusleongwh)\ **Replies:** 1\ **Last updated:** [April 11, 2023, 8:18am UTC](https://community.neo4j.com/t/ms-sql-to-neo4j-etl-automated-pipeline/61574 "2023-04-11T08:18:11Z")
Hi all! A little new to Neo4J here. Hope someone here can give me a hand. How can I do an automated ETL data pipeline from MS SQL server 2017 to Neo4J? I am creating the Neo4J database for analytics and the MS SQL is f… --- ## [Graph Design for ETL + Service Metadata](https://community.neo4j.com/t/graph-design-for-etl-service-metadata/61597)
**Author:** [@mdausmann.cmri](https://community.neo4j.com/u/mdausmann.cmri)\ **Replies:** 1\ **Last updated:** [April 5, 2023, 12:03am UTC](https://community.neo4j.com/t/graph-design-for-etl-service-metadata/61597 "2023-04-05T00:03:03Z")
I want to build a database that can be created via an ETL process from an existing spreadsheet based system which is the source of truth for the data... Spreadsheets ----ETL----\> Graph Database ... but I additionally w… --- ## [How To Do Neo4j Desktop ETL Tool JDBC Connection for MSSQL?](https://community.neo4j.com/t/how-to-do-neo4j-desktop-etl-tool-jdbc-connection-for-mssql/60928)
**Author:** [@knuser](https://community.neo4j.com/u/knuser)\ **Replies:** 7\ **Last updated:** [March 2, 2023, 7:59pm UTC](https://community.neo4j.com/t/how-to-do-neo4j-desktop-etl-tool-jdbc-connection-for-mssql/60928 "2023-03-02T19:59:05Z")
Greetings, If this information is available elsewhere please point me in that direction. I have come here because I have not been able to find explicit answers for my particular scenario. None of these resources seem t… --- ## [Trubles using ETL CLI tool](https://community.neo4j.com/t/trubles-using-etl-cli-tool/52174)
**Author:** [@Xhensila](https://community.neo4j.com/u/Xhensila)\ **Replies:** 0\ **Last updated:** [February 18, 2022, 3:37pm UTC](https://community.neo4j.com/t/trubles-using-etl-cli-tool/52174 "2022-02-18T15:37:54Z")
Hello, I want to use the ETL tool to import my relational database to Neo4j. I have already installed Neo4j desktop and Neo4j ETL Tool, but in my case, I don't want to import all the tables from the relational database … --- ## [First pentaho/kettle job ingest paginated REST API data into neo4j](https://community.neo4j.com/t/first-pentaho-kettle-job-ingest-paginated-rest-api-data-into-neo4j/13751)
**Author:** [@pdrangeid](https://community.neo4j.com/u/pdrangeid)\ **Replies:** 3\ **Last updated:** [February 17, 2022, 4:19pm UTC](https://community.neo4j.com/t/first-pentaho-kettle-job-ingest-paginated-rest-api-data-into-neo4j/13751 "2022-02-17T16:19:33Z")
I will draft a detailed tutorial in the future, but I've got some initial success! I'm querying Auvik (a network & infrastructure discovery/monitoring platform) via their REST API which returns JSON results (limited to … --- ## [Coercion of list to boolean is deprecated error when run as ETL job with JDBC neo4j driver](https://community.neo4j.com/t/coercion-of-list-to-boolean-is-deprecated-error-when-run-as-etl-job-with-jdbc-neo4j-driver/49769)
**Author:** [@pdrangeid](https://community.neo4j.com/u/pdrangeid)\ **Replies:** 3\ **Last updated:** [January 3, 2022, 5:29pm UTC](https://community.neo4j.com/t/coercion-of-list-to-boolean-is-deprecated-error-when-run-as-etl-job-with-jdbc-neo4j-driver/49769 "2022-01-03T17:29:24Z")
OS: Windows Server 2019 Datacenter Java 1.8.0\_292 neo4j-jdbc-driver-4.0.4 Pentaho Data Integration 9.2 OLD version: community 4.2.13 (problem/error DOES NOT arise) (attempt) New Version: community 4.4.2 I also test… --- ## [Import records from multiple db's at once](https://community.neo4j.com/t/import-records-from-multiple-dbs-at-once/47849)
**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")
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 do you schedule and manage data integration with Neo4j?](https://community.neo4j.com/t/how-do-you-schedule-and-manage-data-integration-with-neo4j/13209)
**Author:** [@pdrangeid](https://community.neo4j.com/u/pdrangeid)\ **Replies:** 11\ **Last updated:** [April 5, 2021, 6:08am UTC](https://community.neo4j.com/t/how-do-you-schedule-and-manage-data-integration-with-neo4j/13209 "2021-04-05T06:08:49Z")
I'd love to hear how others are doing this. I've got several cql scripts that I use regularly, and I've build some of my own tools to handle things like injecting credentials/tokens to keep them secure. I'm largely j… --- ## [I am not able to connect to database using Pentaho kettle - Neo4j output](https://community.neo4j.com/t/i-am-not-able-to-connect-to-database-using-pentaho-kettle-neo4j-output/30064)
**Author:** [@janardhan.narode](https://community.neo4j.com/u/janardhan.narode)\ **Replies:** 1\ **Last updated:** [December 4, 2020, 8:33pm UTC](https://community.neo4j.com/t/i-am-not-able-to-connect-to-database-using-pentaho-kettle-neo4j-output/30064 "2020-12-04T20:33:32Z")
I am not able to connect to database using Pentaho kettle - Neo4j output --- ## [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)
**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")
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… --- ## [One ETL Tool bug, one feature request](https://community.neo4j.com/t/one-etl-tool-bug-one-feature-request/19109)
**Author:** [@david.strayhorn4](https://community.neo4j.com/u/david.strayhorn4)\ **Replies:** 0\ **Last updated:** [May 23, 2020, 10:16pm UTC](https://community.neo4j.com/t/one-etl-tool-bug-one-feature-request/19109 "2020-05-23T22:16:24Z")
I'm going through the ETL Tool and there are two issues I am encountering at the "Explore and change your metadata" step. First: If I search by entity name so that only a subset of entities is shown, the Action button p… --- ## [DB2 to Neo4j using ETL tool error, Exception in thread "main" java.lang.AbstractMethodError: com.ibm.db2.jcc.t4.b.getSchema()Ljava/lang/String](https://community.neo4j.com/t/db2-to-neo4j-using-etl-tool-error-exception-in-thread-main-java-lang-abstractmethoderror-com-ibm-db2-jcc-t4-b-getschema-ljava-lang-string/15972)
**Author:** [@siddhartalahiri](https://community.neo4j.com/u/siddhartalahiri)\ **Replies:** 0\ **Last updated:** [March 18, 2020, 9:54am UTC](https://community.neo4j.com/t/db2-to-neo4j-using-etl-tool-error-exception-in-thread-main-java-lang-abstractmethoderror-com-ibm-db2-jcc-t4-b-getschema-ljava-lang-string/15972 "2020-03-18T09:54:17Z")
Neo4j Desktop 4.0.8 Neo4j ETL 1.4.2 DB2 v10.1 I'm trying to connect and import a DB2 table present in Mainframe platform using jdbc drivers. I have used the appropriate JDBC driver jar files and the license authentic… --- ## [Postgresql to Neo4j ETL on Docker](https://community.neo4j.com/t/postgresql-to-neo4j-etl-on-docker/11380)
**Author:** [@korayparlar](https://community.neo4j.com/u/korayparlar)\ **Replies:** 0\ **Last updated:** [October 28, 2019, 8:53am UTC](https://community.neo4j.com/t/postgresql-to-neo4j-etl-on-docker/11380 "2019-10-28T08:53:25Z")
Hello Community, I have created a project to migrate data from postgresql to neo4j database and this will run on docker. Please take a look on this link. Hope you find it useful. Each feedback is appreciated. Thanks… --- ## [How can I use integrated security with ETL and Microsoft SQL Server](https://community.neo4j.com/t/how-can-i-use-integrated-security-with-etl-and-microsoft-sql-server/6688)
**Author:** [@leogodin217](https://community.neo4j.com/u/leogodin217)\ **Replies:** 3\ **Last updated:** [May 6, 2019, 8:37pm UTC](https://community.neo4j.com/t/how-can-i-use-integrated-security-with-etl-and-microsoft-sql-server/6688 "2019-05-06T20:37:09Z")
I am using Neo4J desktop on Windows 10 and trying to connect to an SQL server using integrated security. I downloaded the MS ODBC driver and copied sqljdbc\_auth.dll into %USERPROFILE%..Neo4jDesktop\\distributions\\java\\zul… --- ## [Import postgres data from VM](https://community.neo4j.com/t/import-postgres-data-from-vm/5495)
**Author:** [@yu.li](https://community.neo4j.com/u/yu.li)\ **Replies:** 8\ **Last updated:** [March 13, 2019, 6:22pm UTC](https://community.neo4j.com/t/import-postgres-data-from-vm/5495 "2019-03-13T18:22:58Z")
Hi everyone, I'm trying to import a Postgres database from a VM, and use Neo4j to visualize the graph. For a sample of such a database, I am able to load the data using ETL tools and run it on my local Windows machine u… --- ## [Tip: Avoiding Slow & Messy Conditionals (or: splitting input) in Cypher for bulk import LOAD CSV?](https://community.neo4j.com/t/tip-avoiding-slow-messy-conditionals-or-splitting-input-in-cypher-for-bulk-import-load-csv/3157)
**Author:** [@alec.muffett](https://community.neo4j.com/u/alec.muffett)\ **Replies:** 3\ **Last updated:** [November 23, 2018, 12:33am UTC](https://community.neo4j.com/t/tip-avoiding-slow-messy-conditionals-or-splitting-input-in-cypher-for-bulk-import-load-csv/3157 "2018-11-23T00:33:34Z")
We all probably know that conditional tests in Cypher break the "lightning-fast" CSV loader, and if you've probably read about the: CASE WHEN \ THEN \[1\] ELSE \[\] AS foo FOREACH (x IN foo | SET \) ...… --- ## [Neo4j Choice Values Design Decision](https://community.neo4j.com/t/neo4j-choice-values-design-decision/2773)
**Author:** [@ande8440](https://community.neo4j.com/u/ande8440)\ **Replies:** 1\ **Last updated:** [November 4, 2018, 6:27pm UTC](https://community.neo4j.com/t/neo4j-choice-values-design-decision/2773 "2018-11-04T18:27:17Z")
TLDR: single and multi-select choice fields: for a generic ETL tool should I model them as nodes connected with relationships or direct labels on the parent/starting node. I realize the optimal modeling decision depends … --- ## [Adding etl App to Neo4j-desktop](https://community.neo4j.com/t/adding-etl-app-to-neo4j-desktop/1104)
**Author:** [@mojtaba\_tmj](https://community.neo4j.com/u/mojtaba_tmj)\ **Replies:** 2\ **Last updated:** [September 5, 2018, 5:34pm UTC](https://community.neo4j.com/t/adding-etl-app-to-neo4j-desktop/1104 "2018-09-05T17:34:53Z")
How can I add ETL App to my Neo4j-desktop? I don't have ETL app in my Applications list. --- ## [About the Databases & ETL category](https://community.neo4j.com/t/about-the-databases-etl-category/31)
**Author:** [@michael.hunger](https://community.neo4j.com/u/michael.hunger)\ **Replies:** 0\ **Last updated:** [June 11, 2018, 3:53pm UTC](https://community.neo4j.com/t/about-the-databases-etl-category/31 "2018-06-11T15:53:08Z")
Neo4j can integrate with a number of relational and non-relational databases. Either with dedicated integrations and #neo4j-graph-platform:etl tools or via procedure libraries like #neo4j-graph-platform:procedures-apoc I…