cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic SQL to Cypher Query Tool

Hi all,

For my final year undergraduate capstone project, I am attempting to build an ETL tool that is able to automatically transform an SQL database to a Neo4j Cypher query language. Admittedly, I am still new here, and am still getting my hands dirty with Neo4j.
Any pointers to the feasibility of the idea would be helpful--has something like this been done already? Perhaps a certain niche to focus on that could solve an issue, or an area to pivot off on, or if it's unnecessary or 'impossible'.

Thank you very much!

2 REPLIES 2

glilienfield
Ninja
Ninja

That is an ambitious project.  Each table could be mapped to nodes, where the table name could be used as the node labels. The node relationships would be defined by the foreign key relationships between the tables. You would associate the nodes using the primary and foreign keys saved with each node. 

Haha, yes it is 😅. While I'm really stoked about it, I'm trying to be as practical as possible since I don't have much industry experience.

But I really appreciate your input. I'd look more into how that can be done.

Nodes 2022
Nodes
NODES 2022, Neo4j Online Education Summit

On November 16 and 17 for 24 hours across all timezones, you’ll learn about best practices for beginners and experts alike.