Connecting Neo4j Desktop to SQl server

[saurabhpaul35]

Need help to connect Neo4j desktop to local sql Server

1. Have already installed the desktop version 1.4.3.exe
2. Have MSQL Management Studio v18.4

Need help to create a database on sql server and connect to neo4j desktop

[abk]

Hello @saurabhpaul35 ,

Could you describe a bit more about what you'd like to set up? For example, something like an ETL flow between Neo4j and SQL Server?

Best,
ABK

[saurabhpaul35]

I have SSMS setup on my system , on the other side ne04j desktop , how do i connect to ssms from neo4j , i tried creating localhost DB on ssms I'm not able to do it. I have attached my sql server window and neo4j desktop window please help.
localhostdb|496x119

[abk]

The best approach may be to use the Neo4j ETL tool. You can find information abou that here:

Neo4j Graph Database Platform

How-To: Neo4j ETL Tool - Developer Guides

Through this guide, you will learn how to take your data from a relational database or table format and import to Neo4j.

Best,
ABK

[saurabhpaul35]

Thank you The ETL tool actually has options to connect to the SQL server but my server is a production one handled by client where i cannot connect directly instead I am trying to create a localhost access with widows authentication but I'm unable to do it.

[ameyasoft]

You need to download the appropriate jdbc driver corresponding your SQL version from MS site. For version 6.2 the driver: mssql-jdbc-6.2.2.jre8.jar.

After downloading, copy the jar file to Neo4j 'plugins' folder and run this script:
call apoc.load.driver("com.microsoft.sqlserver.jdbc.SQLServerDriver")

For windows authentication, you need to copy the sqljdbc_auth.dll into the C:\Windows\SysWOW64 directory.

Finally, run the call apoc.load.jdbc() script.

[saurabhpaul35]

I have admin access restrictions hence not able to download the drivers mentioned.

[ameyasoft]

Other choice is to export the data as a csv file and import into Neo4j database using LOAD CSV

[saurabhpaul35]

What I am trying here is I have SQL server where in the DB's are production ones which i cannot do experiment , instead I want to create a localhost DB which has graph tables folder and that i wanted to connect to neo4j desktop. Have attached screenshot.

[ameyasoft]

Try Kettle ETL tool:
https://etl-tools.info/en/pentaho/kettle-etl.htm

[saurabhpaul35]

Thank you apart from this tool is there any way I can do this because my manager has asked me to give demo today to create graph database in local instance and connect through neo 4j.