Take the 2-minute tour ×
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. It's 100% free, no registration required.

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? wiki.pentaho.com/display/EAI/Getting+Started Also check out the blogs diethardsteiner.blogspot.com and also Slawo: type-exit.org/adventures-with-open-source-bi –  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

1 Answer 1

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

Your Answer

 
discard

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.