CData Software

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

JDBC Drivers

Data connectivity for Java-based apps

Hundreds of sources, read & write

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.

Seamlessly connect from BI, ETL, and apps

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.

Familiar SQL to any source

A robust SQL-engine simplifies data movement & processing from Cloud Apps, NoSQL, Files, & more. JOIN, Aggregate, SQL Functions, and many Stored Procedures are supported.

Embedded by industry leaders

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.

Case Study

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

Randstad

2 easy steps to connect your data from your data client

01 Download and locate JDBC .jar Install modal

02 Connect from data client tool Connections settings

Seamless connection from your tool Connections window

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:

ETL & Data Warehouse

  • Informatica PowerCenter
  • Apache NiFi
  • Oracle Data Integrator
  • Oracle WareHouse Builder
  • IBM WebSphere
  • CloverDX
  • Airbyte
  • AWS Glue
  • Google Cloud Data Fusion
  • Pentaho
  • AWS Lambda
  • embulk

BI, Reporting & Data Virtualization

  • IBM Cognos
  • Tibco Spotfire
  • Denodo
  • Oracle WareHouse Builder
  • Dremio
  • Starburst
  • Airbyte
  • DBeaver
  • DbVisualizer
  • SAP Crystal Reports
  • ColdFusion
  • Sisense
  • SAP Business Objects

Custom Java Applications

  • Eclipese
  • InteliJ
  • NetBeans
  • Jetty
  • JBoss
  • Filemaker

Ready to get started? Try CData for free today

Read the original on cdata.com ↗