Market solutions
There are two market solutions to make an ODBC-JDBC bridge :
-
Easysoft with their ODBC-JDBC Gateway
-
Openlink with thier Single/Multi Tier ODBC-JDBC bridge
In this documentation, we will only talk about easysoft.
Easysoft
Easysoft is a solution that make an ODBC-JDBC bridge on your computer. So you have to install it on each machine.

It costs 375 GBD / year, but prices depend on the number of machines where we install software.
Installation
-
Go to download trial version : http://www.easysoft.com/cgi-bin/productdownload.cgi?p=26 (you must create an account)
-
Download the windows version
-
Run the executable and follow the wizard. For more information, read the installation guide of easysoft
JVM Configuration
-
Go to Programs > Easysoft >ODBC-JDBC Gateway > Configure Java Interface
-
Configure where is your JDK
-
Click on Test and Save if OK
NEO4J JDBC Configuration
-
Go to the Control Panel
-
Then in Administrative Tools
-
Click on Data Sources (ODBC)
-
Check if Easysoft driver is really installed

-
Download the neo4j jdbc driver (with all its dependencies) here : https://m2.neo4j.org/content/groups/public/org/neo4j/neo4j-jdbc/2.1.4/
-
Create a new ODBC connection, and select Easysoft ODBC-JDBC Gateway

-
Configure the connection where :
-
DSN : The name of your new database, for example NEO4J
-
Description : you can put here the description of your connection
-
User name : The login of the neo4j user
-
Password : the password of the neo4j user
-
Driver Class : org.neo4j.jdbc.Driver
-
Class Path : Click on the Add button, and select the jar you have download at step 5
-
URL : The JDBC connection URL for neo4j : jdbc:neo4j://localhost:7474 (if you server is on your local machine)
-

-
When you have fullfil this form, you can click on the
Test
, to check that is everyting is good (your neo4j server must running of course).
Well done, you have your ODBC-JDBC Bridge installed for neo4j !
Annexe
How to enabled log for ODBC
This feature can be (very) usefull for debugging purpose, but it (really) slowing the ODBC connection.
-
Go to the
Control Panel
-
Then in
Administrative Tools
-
Click on
Data Sources (ODBC)
-
Click on the
Tracing
tab -
Click on
Start Tracing Now
. You can also configure where the log file is generated with theLog File Path
.

Some usefull links
-
http://stackoverflow.com/questions/5352956/odbc-jdbc-bridge-that-maps-its-own-calls-to-jdbc-driver : Stackoverflow threadabout ODBC/JDBC bridge
-
http://www.4d.com/4d_docstatic/4D%20ODBC%20Pro/12/ODBC-Results.201-371921.en.html : Explain each ODBC operation
-
http://www.gpoulose.com/ : To download a Query Tool that use ODBC
-
http://neo4j.com/docs/stable/server-configuration.html#_http_logging_configuration : How to enable neo4j HTTP log file (usefull to debug REST query)