We are proud to share our inclusion in the 2024 Gartner Magic Quadrant for Data Integration Tools. We believe this recognition reflects the differentiated business outcomes CData delivers to our customers.
Get the Report →Universal API Connector
Transform APIs into datasets for analytics
The API Connector feature of CData Connect Cloud makes it easy to integrate all your data applications and processes with data from any internal or external API.
- Quickly connect analytics & reporting to custom APIs: Automatically model any API as a data table for easy consumption.
- Code-free integration: Simple point-and-click configuration makes integrating with custom APIs from any client application easy.
Get a Demo
How it works
Work with live data from any API
Get started with the API connectivity in minutes. Watch the tutorial video to see how you can:
- Connect to your API from the Connect Cloud Web interface.
- Customize how your API data should appear.
- Work with live API data from any data application or tool.
Use Cases
Connect data from any API to data management processes
The API Connector is a powerful general-purpose extensibility tool. With this single connector, users can easily integrate data from all types of APIs and services through the CData Connect Cloud data platform.
- Analyze data from SaaS applications or other APIs not natively supported by CData Connect Cloud.
- Integrate API data with ETL/ELT data pipelines and data warehousing processes.
- Easily connect and combine data from public APIs, for example, geographical, crime statistics, demographics, news, or social media.
Technical features
Universal API connectivity
Connect to any generic, custom, or public API, or other data sources not directly supported out-of-the-box by Connect Cloud.
Tabular data modeling
API data is automatically modeled as a table for easy consumption from analytics and data processes, regardless of the original source format. Connect to APIs like you would a simple database.
Code-free integration
Connecting to data from custom APIs used to be a time-consuming and tedious process, best left to software developers or IT - but not anymore. The API Connector's intuitive online configuration wizard guides users through API consumption via straightforward point-and-click configuration.
SQL access to API data
As with other connections, CData Connect Cloud provides a standard SQL-92 compliant interface to data. After configuring an API connection, users can access the data the same way they would with any other data source connection. The powerful SQL engine of Connect Cloud seamlessly translates SQL queries into API calls, making the data ready for analytics, reporting, and data management.
Simple API data modeling
The straightforward configuration wizard guides users through defining data tables, fields, and other parameters to access API data. Users can preview criteria and test outputs through the online data explorer.
Secure API integration
API security centers around protecting APIs from malicious attacks, ensuring only authorized users access and use them, and safeguarding transmitted data from unauthorized access or manipulation. The API Connector supports major API security and access controls, including advanced SSL and TLS network encryption and user authentication via Basic Auth, Digest Auth, OAuth 1.0, OAuth 2.0, and more.
Enhanced processing of large data sets
Embedded data pagination offers granular control of API data processing across multiple requests. Control the page size and number of records with four pagination types: Offset, Number, Token, and URL.
Server-side filtering
Filtering criteria and parameters are pushed to the data source API to process requests, returning only the requested data, reducing the amount of data to transfer and further enhancing performance.
Nested data structures
CData Connect Cloud preserves the child table's inherent relationships with parent tables, providing more flexibility when retrieving data