cancel
Showing results for 
Search instead for 
Did you mean: 

Head's Up! These forums are read-only. All users and content have migrated. Please join us at community.neo4j.com.

Sinister Penguin - Modernising 20 million CMDB CI's

Hi - I work for an IT Managed Hosting company, I'd like to use neo4j to modernise & fully leverage our 20 million CI CMDB.

Its central to our organisation & I'm sure i can use neo4j to enrich the data & add value.

So I'm particularly interested in importing data into neo4j from SQL Server & from XML files as well as synchronising with external data sources.

3 REPLIES 3

This sounds like a challenge but also fun if you get it solved.
Let me know if the procedures in APOC for loading from relational databases and XML are helpful for you.

There are a bunch of talks that I linked in other places on this topic, that might be interesting to you:

Can the below query works if I have 33 million data which output using multiple join queries...
CALL apoc.load.jdbc('jdbc:derby:derbyDB','SELECT * FROM PERSON WHERE AGE > 18')

Sure, you just want to wrap the apoc.load.jdbc thing into an apoc.periodic.iterate with he 2nd statement doing the updating. Best ask in #neo4j-graph-platform:procedures-apoc

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

All the sessions of the conference are now available online