JDBC Driver for CData Connect
Overview
The JDBC Driver for CData Connect offers the most natural way to connect to CData Connect data from Java-based applications and developer technologies. The driver wraps the complexity of accessing CData Connect data in an easy-to-integrate, 100%-Java JDBC driver. Applications can then access CData Connect as a traditional database. The driver hides the complexity of accessing data and provides additional powerful security features, batching, socket management, and more.
Key Features
- Write SQL to retrieve and update CData Connect data.
- Compliant with JDBC 3.0 and JDBC 4.0.
- Codeless integration with popular BI, reporting, and ETL tools.
Getting Started
See Getting Started for A-Z guides on authenticating and connecting to CData Connect data. See the CData Connect integration guides for information on connecting from other applications.
Using the JDBC Driver/Using from Tools
See Using JDBC for examples of using standard JDBC classes like DataSource, Connection, Statement, ResultSet, and others, to work with CData Connect data.
Using from Tools walks through the steps of integration with JDBC tools, using several popular database tools as examples.
Schema Discovery
See Schema Discovery to access schema information through the standard JDBC interfaces. Query the System Tables to access additional metadata, such as data source capabilities.
Advanced Features
Advanced Features details additional features supported by the driver, such as , ssl configuration, firewall/proxy settings, and advanced logging.SQL Compliance
See SQL Compliance for a syntax reference and code examples outlining the supported SQL.
Data Model
See Data Model for information on the available entities and how to query them.
Connection String Options
The Connection properties describe the various options that can be used to establish a connection.