Liking cljdoc? Tell your friends :D
Pentaho
Step 1: Create database connections:
Right click on Database connections and click on New
Insert the connection parameters for source database the press Test button to check the connection:
As before, select a new Database connections and insert neo4j connection parameters, set:
-
Connection Type: Generic database
-
Custom Connection URL: "jdbc:neo4j:bolt://localhost:7687"
-
Custom Driver Class Name: "org.neo4j.jdbc.Driver"
-
Login and password:
Then press to Test button to check the connection:
Step 2: Create Steps and Hops:
-
From Design select input and click on table input top insert the source table:
-
From Scripting click on Execute SQL script:
-
Double click on table input. Select the source database Connection and write query to extract data the press Preview button to check query:
-
Double click on Hops, select as From step the table input and as to step the Execute SQL Script:
-
Now your Hop is complete!
-
Double click on Execute SQL script. Click on Get Fields to retrive the column from source database. Write the cypher to create nodes and relationship:
Step 3: Run the job
-
Click on run this transformation or job and wait until finished:
-
If all ok, you should have like this:
Can you improve this documentation?Edit on GitHub
cljdoc is a website building & hosting documentation for Clojure/Script libraries
× close