API Driver


Universal API Connectivity


Simple, Codeless, Automated API Connectivity


Easily Connect BI, Reporting, & ETL tools to real-time API data.

75+

Pre-Configured Data
Source Connections

10+

Standards-based
Driver Technologies

100+

BI, ETL, & Reporting
Integrations

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.

Universal API Connectivity

Connect applications through standard data interfaces like ODBC, JDBC, ADO.NET, SSIS, Excel, Power BI, and more.

Codeless Integration

Easily integrate BI, ETL, & Reporting with cloud APIs through dozens of pre-defined API Profiles.

Robust SQL-Engine

The same reliability, scalability, performance & security powering leading data integration solutions.

Fully-Extensible Design

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 application and services.

Accelo
Active Campaign
AfterShip
AgileCRM
Aha!
Aircall
Amplitude
Autopilot
BenchmarkEmail
Branch
Buffer
Bugsnag
calendly
Campaign Monitor
CapsuleCRM
ClickTime
ClickUp
Clockify
Close CRM
Clubhouse
Codat
Coinbase
ConstantContact
Contify
ConvertKit
Copper CRM
Delighted
Dotmailer
Drift
Drip
Enchant
Eventbrite
Everhour
Figshare
Float
Foursquare
Freshsales
Freshservice
Front
GetResponse
Gorgias
Grafana
Groove
Harvest
HelloSign
Helpscout
Humanity
IVA
Insightly
Intercom
JotForm
Jumpseller
Klaviyo
KnowledgeOwl
LaunchDarkly
Leaddesk
LionDesk
Mailjet
Mattermark
MessageBird
Mode
Monday
Moosend
OANDA
Omnisend
Ontraport
Optimizely
PagerDuty
PayRun.io
PersistIQ
Pipedrive
PipelineDeals
Pipeliner CRM
PivotalTracker
Planio
ProdPad
PubNub
Recurly
Retently
Samanage
Sendinblue
Sendwithus
ServiceM8
Shipengine
ShipStation
Shippo
SpaceX
SparkPost
Stack Exchange
Streak
Swell
Teamwork
Timely
Toggl
Typeform
Unbounce
VWO
Wistia
Workstack
Wrike
Wunderlist
Yelp
Yotpo
ZendeskSell
Zenkit
Zoom
Your Custom API



Download API Profiles


Universal Application Integration

Straightforward data connectivity through standards-based Driver and Adapter interfaces


ODBC

JDBC

ADO.NET

Python

SQL SSIS

BizTalk

MuleSoft

Excel

Power BI

Cmdlets

FireDAC

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
  • Crystal Reports
  • FileMaker Pro
  • FoxPro
  • Microsoft Access
  • Microsoft Excel
  • MicroStrategy
  • Oracle DB
  • Power Map
  • Power Pivot
  • QlikView
  • SAP Business Objects
  • SharePoint Services
  • Tableau
  • Looker
  • ... and many more!

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 developer 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.


API DRIVER TECHNICAL RESOURCES:

Universal API Connectivity

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 OVERVIEW

Download CData API Drivers


Easily 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.


Download Now    Contact Us