In order to connect to your data from an ODBC compliant tool you need to use an ODBC – JDBC bridge such as the EasySoft ODBC – JDBC Gateway .
NB : Please ensure you have downloaded and unzipped the deltaDNA JDBC driver before installing the ODBC–JDBC Gateway
- Download and install the Easysoft ODBC – JDBC Gateway.
- License the ODBC-JDBC gateway
You will need to use the account details you provided when you registered and downloaded the bridge in step 1. You will find detailed instructions on the Easysoft licensing page. You will be able to choose between a Trial or Purchased License
- Validate your installation.
The version number and installation details can be verified by running the ODBC Data Source Administrator.On Windows 8.1 this can be found in Control Panel >> Administrative Tools >> ODBC Data (64 bit) you may have separate 32 bit & 64 bit entries, be sure to select the correct one.
Select the drivers tab and check that the “Easysoft ODBC-JDBC Gateway” is listed - Define which JVM to use.
The Easysoft ODBC-JDBC gateway uses a JVM to load the target JDBC driver. To check or alter the JVM being used run
Programs >> Easysoft >> ODBC-JDBC Gateway >> Configure Java Interface, you may have seperate 32bit & 64bit versions, be sure to select the one that matches your Java installation.
- Setup an ODBC data source.
Open the ODBC Data Source Administrator from Control Panel >> Administrative Tools >> Data Sources (ODBC) and select either the “User DSN” or “Sytem DSN” tab depending on whether you wish this connection to available to all user or just your own account. Then Add a new DSN and select the “Easysoft ODBJ-JDBC Gateway” as the driver and click “Finish”.
- The DSN set-up panel will be displayed, it should be populated with the following details.
Username: The username you use to login to the deltaDNA portal.
Password: The password you use to login to the deltaDNA portal.
Driver Class: com.deltadna.jdbc.client.Driver
Class Path: This is the deltaDNA JDBC Driver JAR file, browse to the location where you saved the file and select it.
URL: jdbc:deltadna://data.deltadna.net/<Account Name>/<Game>
Please note, the account name and game should be copied from the address bar of the deltaDNA portal as shown below.
- Click the “Test” button to check that you can connect to your Data.
- Finally, select the “OK” button on the DSN Setup Panel to save your DSN.
More detailed information on installing, configuring and using the Easysoft ODBC-JDBC Gateway can be found on the Easysoft website and in the “Gateway User Guide.pdf” file that was installed on with the Easysoft ODBC-JDBC Gateway.
