Search code examples
jdbcneo4jpentahokettle

Database connection to Neo4j with Pentaho Spoon

I want to connect to Neo4j with Pentaho Kettle Spoon. I downloaded jdbc driver of neo4j with this and I tried to use this guide to connect to neo4j with Pentaho Kettle Spoon.
I have two main problems:

  1. downloaded JDBC Driver is zip file.
    I changed Driver extension to jar for solving this problem.
  2. when I changed extension to jar and copy it in lib folder and follow this guide I faced missing driver error:

org.neo4j.jdbc.Driver could not be found

How can I solve these problems?

Solution

  • You can not rename the .zip file you downloaded from Github and add to lib folder. You need to compile the source code and add the .jar file to it. Or you can download the already compiled file from here and add to the data-integration\lib folder and restart the spoon.


    In Table Input step select

    • Connection type as Generic database
    • Custom connection URL as jdbc:neo4j://localhost:7474
    • Custom driver class name as org.neo4j.jdbc.Driver