Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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?

share|improve this question
Have you read the guides? Also check out the blogs and also Slawo: – Codek May 13 '13 at 5:55
@Codek I did and they either don't apply or I'm not getting something. It would be much easier to get something from Neo4j and put it to RDBMS but I can't find an easy way to do it the other way around. – JohnnyM May 14 '13 at 18:03

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.

share|improve this answer

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:

share|improve this answer
@user78028 Thanks for sharing the information. If I am not mistaken, you were able to update Neo4J with the changed data set from MySQL using Pentaho Kettle, right? – Tong Wang Apr 29 at 15:17

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.