This document describes how to install an
ODBC-JDBC bridge on a Windows machine. The bridge serves as a data link between ATSD and Windows applications that do not support JDBC driver technology.
- Windows 7, 8, 10 operating system, 64-bit edition.
- Java 7.
- ODBC-JDBC bridge.
- Download and install Java 7. Note that Java 8 is not fully supported by the ODBC-JDBC bridge vendor.
- Register an account with the bridge vendor. The account is required for trial license activation.
- Download the trial version of the ODBC-JDBC bridge.
- Download ATSD JDBC driver with dependencies.
Install and activate the bridge:
Run the installer under an Administrator account
Skip the welcome page
Accept the license agreement
Choose an installation path
Confirm the installation
Check the License Manager box and finish
A license manager window appears after exiting from the installation wizard. If the window fails to appear go to Start and search for License Manager. Fill out the form fields as entered in the registered account and click Request License
Choose Trial, click Next
Choose ODBC JDBC Gateway, click Next
Click Online request
If the activation succeeds, a pop-up window appears
Also a window with the new license is displayed in the License Manager
Configure ODBC Data Source
Go to Start, type
ODBCand launch ODBC Data Source Manager under an Administrator account.
Open System DSN tab, click Add....
Choose the ODBC-JDBC Gateway, click Finish.
Enter the following settings in the DSN Setup window:
DSN : ATSD User name : <atsd username> Password : <atsd password> Driver class: com.axibase.tsd.driver.jdbc.AtsdDriver Class Path : <path to ATSD driver, for example C:\drivers\atsd-jdbc-1.3.2-DEPS.jar> URL : jdbc:atsd://atsd_hostname:8443
Refer to ATSD JDBC documentation for additional details about the URL format and the driver properties.
Check (enable) Strip Quote option to remove the quotes from table and column names.
Check (enable) Strip Escape option to remove ODBC escape sequences.
Click Test to verify the settings. If result is correct, save the settings.
In case of
Unable to create JVMerror, run a Repair task in Windows Program for the bridge program. The error occurs if the bridge is installed prior to Java installation.
The System DSN tab now displays the new data source.