2

I have a mature 50+ tables web application based on mySQL. In order to do some advanced data mining I want to use Neo4j and the goodnes of cypher. However I'm having a hard time migrating my data from RDBMS to Neo4j. I don't wan't to do it by hand, because this is generally unmaintainable.

I use pentaho which supports the Neo4j JDBC, however I'm having a hard time wrapping my head around loading the extracted data to Neo4j since the GUI is clearly designed for RDBMS and there are no sources about how to do it. Had anyone run into a similar problem and found a solution?

JohnnyM
  • 121
  • 4

2 Answers2

2

JDBC Driver that Neo4J provides are for Cypher queries ( which are select only). There are no inserts , updates or delete. You will have to adopt some other means like .. exporting rdbms stuff to csv and importing csv to Neo4J.

user31343
  • 21
  • 2
1

maybe it's too late but I faced to this problem and I could solve it.
At first you need to add Table Input tool for getting records from MySQL then you can add execute SQL script from Scripting tool. create your transformation from Table input to Execute SQL Script. then Get fields and check mark :

  • Execute for each row?
  • Execute as a single Statement

then you can add your Cypher Query Like that:

CREATE(NodeName:NodeLabel{field1:?,field2:?,field3:?,...})
Tom V
  • 15,752
  • 7
  • 66
  • 87
user78028
  • 11
  • 1