Best way to interact between Access & Neo4j

Neo4j Graph Platform Import / Export
,
1

Hi!

I have a Microsoft Access database which I need to transfer to a Neo4j Community database. I'm not able to perform av simple export as I have to create a lot of relations based on the content of the Access db. I'm thinking of sending Cypher queries (MERGE ON CREATE/ON MATCH...) in JSON according to the samples given in the Neo4j HTTP ReST documentation. I'm leaning towards the Neo4j HTTP ReST API but given the rather arcane MSXML2 API I thought I'd ask here before embarking on that road. Does anybody have experience doing something similar? If you have an alternative to the MSXML2 API I'm all ears as well :slight_smile:

Many thanks in advance!

2

Sorry, I don't have experience with either option, but I thought I would make aware so you could determine their applicability.

  1. Neo4j ETL tool. It is included as one of the Neo4j Desktop Graph Apps. How-To: Neo4j ETL Tool - Developer Guides

  2. Use APOC's apoc.load.jdbc procedure to query MS access database in your cypher queries: apoc.load - APOC Extended Documentation

3

Hi Gary!

Thanks for your reply! I'll look into the ETL tool and see if it fits.

Cheers