How to connect Microsoft SQL Server directly with Neo4j using ODBC Connection

[shivangi gupta]

Hi All,

I have been working with a project which requires Table of a Microsoft Sql server to be connected to Neo4j directly. 
So rather than loading data from CSV I want a dynamic update from SQL Server to Neo4j.

I have looked for it and found a way out from JDBC but not ODBC.

Looking for suggestions how to proceed as I am unable to find resources online.

Thanks

[Michael Hunger]

Yes, just use JDBC. There are several ways, the Neo4j ETL tool, dedicated ETL like Pentaho Kettle or Talend or the apoc.load.jdbc procedure.

Michael

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.
To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[shivangi gupta]

Hi Michael,

Thanks for the support. I tried making a connection using Neo4j ETL tool but unable to resole this error.  I have also copied .jar files in plugin folder.If you could help me resolving this error.

On Thursday, 14 June 2018 02:03:50 UTC-4, Michael Hunger wrote:

Yes, just use JDBC. There are several ways, the Neo4j ETL tool, dedicated ETL like Pentaho Kettle or Talend or the apoc.load.jdbc procedure.

Michael

On Wed, Jun 13, 2018 at 9:23 PM, shivangi gupta <shivang...@gmail.com> wrote:

Hi All,

I have been working with a project which requires Table of a Microsoft Sql server to be connected to Neo4j directly. 
So rather than loading data from CSV I want a dynamic update from SQL Server to Neo4j.

I have looked for it and found a way out from JDBC but not ODBC.

Looking for suggestions how to proceed as I am unable to find resources online.

Thanks

--
You received this message because you are subscribed to the Google Groups "Neo4j" group.

To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+un...@googlegroups.com.

[Michael Hunger]

Perhaps you can try what was suggested here (although it is a bit odd):

https://stackoverflow.com/questions/11707056/no-sqljdbc-auth-in-java-library-path

To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscribe@googlegroups.com.

[shivangi gupta]

Finally I am able to connect my Database. But I wan to import data and create graph based on only one table not all tables. In the demo its shown that the schema contains of many tables and all tables have relationships and thus data is imported. But how to create a graph database only from importing a single table from that schema?

[Michael Hunger]

That's much easier, you can just use apoc.load.jdbc for that purpose.

For neo4j-etl there is also a command line version which allows you to include/exclude single tables.

You see the commands called in the log window.

Michael

To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscribe@googlegroups.com.

[shivangi gupta]

Could you please verify the statement below for apoc.load

call apoc.load.jdbc('jdbc:sqlserver://;servername=<ip>;databaseName=<db>;user=<user>;password=<pass>','<databasename.schemaname.tablename>') yield row

[Michael Hunger]

if the JDBC URL is correct.

you have to put the JDBC driver into your plugins directory.

To unsubscribe from this group and stop receiving emails from it, send an email to neo4j+unsubscribe@googlegroups.com.

[alberto....@larus-ba.it]

Hi Shivangi,

according to the error reported by the ETL tool it seems that the driver you're using is old, you should use 6.x version of the driver.

Is there a particular reason for using 4.2?

Thanks