Driver Technologies

Industry-Leading Connectivity with Analytics, Reporting, ETL Tools, and Custom Apps.


Enable users to easily read, write, and update application, database, and WebAPI data through familiar database interfaces such as ODBC, JDBC, ADO.NET, Excel, BizTalk, and SSIS. Simply install the CData Drivers and access data through standard tables, views, and stored procedures - just like a traditional relational database.


CRM & Marketing Automation

Accounting Systems

Collaboration & ERP

NoSQL & Big Data

REST Services

Document & File Formats

Social Networking

Networking & Auth

Financial & E-Commerce

Uncategorized Sources





Other Applications, Databases, & Web APIs

  Learn More >>  

The CData API Drivers provide a framework for building custom drivers for other databases, applications, and Web APIs. The API Drivers come packaged with several full-source, pre-built profiles for data access.





Driver Technology Features



  • Standards-Compliant ODBC: ODBC 3.8 compliant native protocol based drivers.
  • Unicode, 32-bit and 64-bit support: Support 32-bit and 64-bit applications and unicode ODBC APIs.
  • Cross-platform ODBC: Available for Microsoft Windows, Unix, and Mac (macOS / OS X) platforms.
  • Certified Compatibility*: Our drivers undergo extensive testing and are certified to be compatible with leading analytics and reporting applications like Tableau, Microsoft Excel, and many more.
    * Please visit our knowledge base to access how-to articles.
  • ODBC Remoting: Our exclusive remoting feature allows hosting the ODBC connection on a server to enable connections from various clients on any platform (Java, .NET, C++, PHP, Python, etc.), using any standards based technology (ODBC, JDBC, etc.). ODBC 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 50 plus 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 ODBC 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

  • Pure Java Type 4/5* Drivers: 100% Java architecture based drivers that implement the native protocol without reliance on client-side libraries.
    * Our drivers fit the definition of Type 5 drivers; however, there are only 4 official JDBC Driver types.
  • All-in-One Deployment: Single JAR that supports JDBC 3.0 and JDBC 4.0 specification and JVM versions 1.5 and above.
  • 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.
    * Please visit our knowledge base to access how-to articles.
  • 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

  • Fully managed .NET: 100% fully managed ADO.NET libraries supporting .NET Framework 2.0 and beyond.
  • Developer Friendly: Seamless integration with all versions of Visual Studio.
  • Powerful ADO.NET Features: Including support for ADO.NET Entity Framework (EF 5 & 6), ADO.NET 2.0, LINQ to Datasets, etc.
  • 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 50 plus 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 ADO.NET Providers 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

  • Integration Services: Support for Microsoft SQL Server Integration Services (SSIS) (2005, 2008, 2012, & 2014)
  • Straightforward Data Workflow: Fully integrated with SQL SSIS Visual Studio .NET environment and Microsoft Business Intelligence Development Studio at design-time.
  • Easy-to-Use: Drop in Tasks requires no additional development and are easy to deploy.
  • Fully managed .NET: 100% fully managed.NET libraries supporting .NET Framework 2.0 and beyond.
  • 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 Components include a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
  • Collaborative Query Processing: Our Components 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 Components 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

  • Certified for BizTalk Server: Our Adapter framework has passed the official adapter certification program established by Microsoft for BizTalk Server, administered by Unisys. Thoroughly tested for both scalability and interoperability with Microsoft BizTalk Server.
  • Straightforward Data Orchestration: Fully integrated with BizTalk Server's Visual Studio .NET environment at design-time.
  • Fully managed .NET: 100% fully managed .NET libraries supporting .NET Framework 2.0 and beyond.
  • 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 Adapters include a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
  • Collaborative Query Processing: Our Adapters 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 Adapters 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

  • Easy-to-Use: Integration with the Excel Toolbar provides straightforward data access and one-click updates.
  • Bi-Directional Access: Access remote data from Excel, make changes, and easily push updates back to the underlying data source.
  • PowerPivot Support: Perform powerful data analysis with the Microsoft PowerPivot BI extension.
  • String, Date, Numeric SQL Functions: The Add-Ins include a library of 50 plus functions that can manipulate column values into the desired result. Popular examples include Regex, JSON, and XML processing functions.
  • Collaborative Query Processing: Our Add-Ins 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 Add-Ins 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.

  • Seamless Integration:Feature-rich high-performance Data Access Components that extend Delphi & C++Builder Apps with SaaS, NoSQL, & Big Data connectivity.
  • Developer Friendly: Full Design-time support for data operations directly from RAD Studio. Work with live data directly from the IDE Data Explorer and FireDAC explorer.
  • 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 50 plus 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 DAC Components 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.
  • Secure Connectivity: Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.


 
 
Products


Support
Downloads
Purchase
Company
Subscriptions