[Neo4j] Importing data from oracle to neo4j

Rick Otten rotten at manta.com
Wed Oct 12 22:37:07 CEST 2011


Another approach might be to adapt SymmetricDS -- http://symmetricds.codehaus.org/ -- to feed data from your Oracle (or other JDBC accessible Relational database) into Neo4j - live, as the data changes.

I've been wanting a SymmetricDS interface to Neo4j for a while.  Let me know if you get one working!


-----Original Message-----
From: user-bounces at lists.neo4j.org [mailto:user-bounces at lists.neo4j.org] On Behalf Of Peter Neubauer
Sent: Tuesday, October 11, 2011 6:47 AM
To: Neo4j user discussions
Subject: Re: [Neo4j] Importing data from oracle to neo4j

Hi there,
yes, the utility is converting m:n into relationships, see https://github.com/peterneubauer/sql-import and https://github.com/peterneubauer/sql-import/blob/master/src/test/java/com/neo4j/sqlimport/InsertTest.java
fro an eample.

Let me know if that helps!

Cheers,

/peter neubauer

GTalk:      neubauer.peter
Skype       peter.neubauer
Phone       +46 704 106975
LinkedIn   http://www.linkedin.com/in/neubauer
Twitter      http://twitter.com/peterneubauer

http://www.neo4j.org               - Your high performance graph database.
http://startupbootcamp.org/    - Öresund - Innovation happens HERE.
http://www.thoughtmade.com - Scandinavia's coolest Bring-a-Thing party.



On Sat, Oct 8, 2011 at 11:14 PM, Michael Hunger <michael.hunger at neotechnology.com> wrote:
> What is your use-case for importing the DWH data?
>
> How are you going to model the data of the DWH in neo4j. How does the domain-model look like?
>
> BI data is normally denormalized. So for creating a good graph structure it would be sensible to normalize it during the import.
>
> 10k rows is not that much. You can import them using the normal neo4j transactional facilities in a few seconds.
> For building up your graph model you probably want to index your data or create category nodes to access certain parts of your domain model.
>
> Peter wrote a tool to import relational data into neo4j but that was normalized data where each table was represented by a certain type of node in the graph and foreign key relationships were converted to graph relationships. I don't know if that also handled m:n connection tables efficiently by converting them to relationships too.
>
> HTH
>
> Michael
>
> Am 08.10.2011 um 23:05 schrieb jiteshks:
>
>> I am very new to neo4j.So I don't know all of its features.I am 
>> reading its documentation to understand how it works.
>>
>> My project's requirement is to import the data from a data warehouse( 
>> which is an oracle db) once every month.We are thinking of 
>> implementing neo4j in our project which means we will have to read 
>> the data from oracle db and put it into neo4j.
>> There will be around 1 lakh rows(10^5) to be fetched from oracle 
>> db.What is the fast/efficient way of doing it?
>>
>> Thanks!
>>
>> --
>> View this message in context: 
>> http://neo4j-community-discussions.438527.n3.nabble.com/Importing-dat
>> a-from-oracle-to-neo4j-tp3406024p3406024.html
>> Sent from the Neo4j Community Discussions mailing list archive at Nabble.com.
>> _______________________________________________
>> Neo4j mailing list
>> User at lists.neo4j.org
>> https://lists.neo4j.org/mailman/listinfo/user
>
> _______________________________________________
> Neo4j mailing list
> User at lists.neo4j.org
> https://lists.neo4j.org/mailman/listinfo/user
>
_______________________________________________
Neo4j mailing list
User at lists.neo4j.org
https://lists.neo4j.org/mailman/listinfo/user


More information about the User mailing list