ODBC Drivers
Easy-to-use ODBC Drivers with powerful Enterprise-level features
- Hundreds of data sources
- 100+ integrations with BI, ETL, and reporting tools
- Familiar ODBC / SQL access
- Universally available: Windows & Linux - 32 & 64 bit drivers
Universal ODBC data connectivity
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, data virtualization
BI & reporting tools, such as SAP BusinessObjects, SAP Crystal Reports, MS PowerBI, Qlik, SAS, MS Access
Integration with custom applications
ODBC interfaces are accessible from every major development technology including C#, PHP, Python, Go, Node.js and more.
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.
Available ODBC Drivers
Standards Compliant ODBC Drivers with powerful Enterprise-level features.
(API Driver)
Case Study
Santa Clara University Connects to Workday to Visualize Historical Student Data
Santa Clara University relies on CData to access Workday data in their preferred reporting platforms to better understand historical program trends and improve student engagement.
Read case study
2 easy steps to connect your data from your data client
The most advanced ODBC components anywhere
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 (Windows/Linux)
Available for Microsoft Windows and Unix platforms.
Certified ODBC 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.
Embedded Remoting Capabilities
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 and SQL (TDS) wire protocol server.
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.
Enterprise-class Secure Connectivity
Includes standard Enterprise-class security features such as TLS/ SSL data encryption for all client-server communications.
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.
Certified connectivity from many BI, ETL, and reporting tools
ODBC is one of the most widely supported interfaces for connecting applications with data. Our drivers offer seamless and certified connectivity from popular tools, including:
Server
Connect from SQL Server as Linked-Server. You can query from familiar Transact-SQL without need of setting up another application.
Integrate to your system through popular ETL / EAI tools such as Informatica PowerCenter. Standard SQL and Stored Procedures enable fast delivery of your integration projects.
Connect from any ODBC compatible tools:
- SAP BusinessObjects
- SAP Crystal Reports
- MS Power BI
- QlikView/Sense
- Tableau
- SAS
- and more
Desktop
Your familiar tools can connect using CData ODBC.
- Microsoft Access
- Power Query
- DBeaver
- and more
