Simple, codeless, automated API connectivity
Easily connect BI, Reporting, & ETL tools to real-time API data through standard data interfaces.
- 75+ pre-configured API data source connections
- 10+ standards-based driver technologies
- 100+ BI, ETL, & Reporting integrations
- Fully-extensible, codeless design
Download Now View API Profiles
Simple codeless connectivity to any API
Connect BI, Reporting, & ETL tools to live data from any application, database, or Web API. Built on the same robust SQL engine that powers other CData Drivers, the CData API Driver enables simple codeless query access to APIs through a single client interface.
Connect applications through standard data interfaces like ODBC, JDBC, ADO.NET, SSIS, Excel, Power BI, and more.
Easily integrate BI, ETL, & reporting with cloud APIs through dozens of pre-defined API Profiles.
The same reliability, scalability, performance & security powering leading data integration solutions.
Extend included API Profiles with custom capabilities, or create entirely new Profiles to enable new API connectivity.
Pre-configured API Profiles
API Profiles extend the CData API Driver with connectivity to all types of APIs and services. Users can download and install any of the pre-defined profiles below, extend these API Profiles with custom logic, or easily build new Profiles to target new applications and services.
Universal application integration
Straightforward data connectivity through standards-based Driver and Adapter interfaces
Python Connectors
Database API (DB-API) modules for Python-based data integration and analytics
Learn More
Excel Add-Ins
Read-write access to live data from hundreds of sources directly from Excel
Learn More
PowerShell Cmdlets
Data cmdlets for IT automation and scripting from the PowerShell command-line
Learn More
Direct integration with popular BI, ETL, & reporting
Through standard interfaces like ODBC, JDBC, & ADO.NET, the CData API Drivers simplify data connectivity for a wide range of popular data tools. The API Driver offers seamless and certified connectivity from BI, ETL, and Reporting solutions, including:
- Aqua Data Studio
- Clover ETL
- ColdFusion
- Crystal Reports
- DBeaver
- DbVisualizer
- IBM WebSphere
- Informatica
- IntelliJ
- JBoss
- Jetty
- NetBeans IDE
- Oracle WebLogic
- RazorSQL
- Cognos BI
- FileMaker Pro
- FoxPro
- Microsoft Access
- Microsoft Excel
- MicroStrategy
- Oracle DB
- Power Map
- Power Pivot
- QlikView
- SAP Business Objects
- SharePoint Services
- Tableau
- Looker
Key features
Plug-n-Play API Integration
Access an unlimited number of data sources through the same driver interface. With API Driver it is possible to connect to just about any application, database, or Web service.
Easily Extensible Connectivity
Each API Profile defines the data source tables, views, and stored procedures that are available, along with code for reading, writing, and updating API data.
The data model for each Profile can easily be customized to add or remove tables/columns, change data types, etc. These customizations are supported at runtime using human-readable schema files that are easy to edit.
The open architecture allows developers to easily update profiles to support new functionality or rapidly build API profiles for entirely new data sources.
Robust Data-Centric API Access
Next-level Codeless Data Connectivity. Each API Driver includes a robust SQL-92 Engine that seamlessly supports bulk operations, push-down, dynamic schema & metadata discovery, and unmatched performance. Features include:
- String, Date, Numeric SQL Functions
- Collaborative Query Processing
- Query Folding / Pushdown
- Replication and Caching
Read/Write/Update API Data
API Drivers provide the interfaces to support bi-directional access to API data. Individual profiles selectively support CRUD capabilities through these interfaces.
Universal Client Integration
API Driver offers universal data connectivity through standards-based Driver and Adapter interfaces. Users can install any one of the popular API Driver form factors like ODBC, JDBC, ADO.NET, Excel, Power BI, etc. and easily connect their applications with data.
Enterprise-Class Security
Includes standard enterprise-class security features, such as TLS/SSL data encryption for all client-server communications.
Universal API Connectivity
Watch the API Driver overview video for a first-hand look at how you can simplify API data connectivity with CData API Driver.