Configure the API Driver to Connect to a RESTful API
Configure the CData API Driver to enable codeless API connectivity between apps and APIs.
Universal API Connectivity
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
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 application and services.
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:
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.
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 developer to easily update profiles to support new functionality or
rapidly build
API profiles for entirely new data sources.
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:
API Drivers provide the interfaces to support bi-directional access to API data. Individual profiles selectively support CRUD capabilities through these interfaces.
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.
Includes standard enterprise-class security features, such as TLS/ SSL data encryption for all client-server communications.
API DRIVER TECHNICAL RESOURCES:
Watch the API Driver overview video for a first hand look at how you can simplify API data connectivity with API Driver:
WATCH THE API DRIVER VIDEO OVERVIEWEasily connect with APIs and RESTful services. Interested in a data source that is not listed above? Users can easily extend API Driver with new connectivity, or contact us below and we can help.