JDBC Drivers
Easy-to-use JDBC drivers with powerful enterprise-level features
- Hundreds of data sources
- 100+ integrations with BI, ETL, and Reporting Tools
- Familiar JDBC / SQL access
- Embedded by 100+ industry leading ISVs
Data connectivity for Java-based apps
Connect to hundreds of data sources including databases, SaaS, NoSQL, files, and web services. Creates optimized table layers with full metadata discovery, enabling familiar SQL data access.
Any Java-based tool or application can use CData JDBC Drivers. No need to spend time on custom connector building or script writing to access your business data.
A robust SQL-engine simplifies data movement & processing from Cloud Apps, NoSQL, Files, & more. JOIN, Aggregate, SQL Functions, and many Stored Procedures are supported.
CData JDBC Drivers are used by thousands of enterprises and also embedded in various solutions by industry leaders, such as Salesforce, Google, and SAP.
Available JDBC Drivers
JDBC Drivers with bi-directional access from Java Apps.
(API Driver)
Randstad Leverages CData to Enable Easy Salesforce Migration and ERP Integration
As the HR service organization migrated their CRM, they leaned on CData to easily integrate and access client information within their existing ERP.
Read case study
2 easy steps to connect your data from your data client
The most advanced JDBC components anywhere
Certified Compatibility*
Our drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like SAP Crystal Reports, Pentaho, Business Objects, Crystal Reports and many more.
Metadata Discovery
Full support for JDBC DatabaseMetaData provides extensive schema discovery capabilities. Explore tables, columns, keys, and other data constructs based on user identity.
Developer Friendly
Design-time support for all major Java IDEs, including Eclipse, IntelliJ, and NetBeans.
JDBC Remoting
Our exclusive remoting feature allows hosting the JDBC connection on a server to enable connections from various clients on any platform (Java, .NET, C++, PHP, Python), using any standards-based technology (ODBC, JDBC, etc.). JDBC Remoting is enabled using the popular MySQL wire protocol server.
Replication and Caching
Our replication and caching commands make it easy to copy data to local and cloud data stores such as Oracle, SQL Server, Google Cloud SQL, etc. The replication commands include many features that allow for intelligent incremental updates to cached data.
String, Date, Numeric SQL Functions
The driver includes a library of over 50 functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
Collaborative Query Processing
Our drivers enhance the data source's capabilities by additional client-side processing, when needed, to enable analytic summaries of data such as SUM, AVG, MAX, MIN, etc.
Easily Customizable and Configurable
The data model exposed by our JDBC Drivers can easily be customized to add or remove tables/columns, change data types, etc. without requiring a new build. These customizations are supported at runtime using human-readable schema files that are easy to edit.
Enterprise-class Secure Connectivity
Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.
Certified connectivity from many BI, ETL, and reporting tools
JDBC is one of the most widely supported interfaces for connecting applications with data. Our drivers offer seamless and certified connectivity from popular tools, including:
- Informatica PowerCenter
- Apache NiFi
- Oracle Data Integrator
- Oracle WareHouse Builder
- IBM WebSphere
- CloverDX
- Airbyte
- AWS Glue
- Google Cloud Data Fusion
- Pentaho
- AWS Lambda
- embulk
- IBM Cognos
- Tibco Spotfire
- Denodo
- Oracle WareHouse Builder
- Dremio
- Starburst
- Airbyte
- DBeaver
- DbVisualizer
- SAP Crystal Reports
- ColdFusion
- Sisense
- SAP Business Objects
- Eclipese
- InteliJ
- NetBeans
- Jetty
- JBoss
- Filemaker