CData JDBC-ODBC Bridge

Overview

The CData JDBC-ODBC Bridge allows you to access ODBC data sources from Java applications. Developers can build Java applications with connectivity to ODBC data sources using the familiar JDBC interfaces.

The Getting Started section explains installing and deploying the driver, typical connection properties, and any additional dependencies.

The Using JDBC section shows some common programming idioms that will give you a quick preview of the JDBC API.

Getting Started

Connecting to ODBC data sources

Establishing a Connection shows how to authenticate to ODBC data sources and configure any necessary connection properties in a JDBC URL. You can also configure driver capabilities through the available Connection properties, from data modeling to firewall traversal. The Advanced Settings section shows how to set up more advanced configurations and troubleshoot connection errors.

Connecting to JDBC Data Sources

The CData JDBC-ODBC Bridge provides full support for integration into Java applications, including Eclipse, NetBeans, IntelliJ IDEA, and many other Integrated Development Environments, as well as J2EE applications running on a Java server such as Tomcat.

Java Version Support

To deploy the driver JAR file, you must have Java Development Kit (JDK) 1.8 or higher installed on your system.

ODBC data sources Version Support

Create Connection Objects See Connecting from Code to create JDBC Connection objects.
Query Data from Code See Executing Statements and Using Prepared Statements to execute SQL statements to ODBC data sources tables.
Connect from Java-Based Tools See Using from Tools shows how to connect to ODBC data sources and query data from several popular database tools.

For full documentation, please see the CData documentation.