A little new to Neo4J here. Hope someone here can give me a hand.
How can I do an automated ETL data pipeline from MS SQL server 2017 to Neo4J? I am creating the Neo4J database for analytics and the MS SQL is for transactions but both should store the same data (just one in graph and the other in tables of course). I want the transactions in MS SQL to be automatically reflected and updated in Neo4J each time it receives transactions. It seems like the Neo4J ETL tool is only for a one time import. @DMF194
To keep things simple, you could try using the apoc packages to stream results from SQL to Neo4j using the jdbc connections as shown in the link below
Note that it is not automated and one would need to run the cypher query based on batches and there is no option of setting when the data streaming starts.
Another option is to use the talend open studio to link schedule certain etl jobs, however it is only available in enterprise as shown in link below
