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 →
API Integration Guides and Tutorials
A list of guides and tutorials for connecting to and working with live API data.
CData Software's connectivity tools enable users to connect directly to live API data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on integrating with live API data.
Integration Use-Cases
Click below to jump to articles related to specific integration use-case.
- Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
- ETL & Replication - moving and replicating data (CData Sync, AWS Glue, Oracle Data Integrator, etc.)
- Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
- Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
- Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
- Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)
Business Intelligence & Analytics
ETL & Replication
| Product | Technology | Article Title |
|---|---|---|
| Airbyte | Connect Cloud | Connect to API Data in Airbyte ELT Pipelines |
| AWS Glue | Connect Cloud | Build ETL Jobs with API Data in AWS Glue Jobs |
| Azure Data Factory | Connect Cloud | Import API Data Using Azure Data Factory |
| Google Data Fusion | JDBC | Build Pipelines with Live API Data in Google Cloud Data Fusion (CData Connect Cloud) |
| Microsoft Power Automate | Connect Cloud | Build API-Connected Automated Tasks with Power Automate (Desktop) |
| SnapLogic | Connect Cloud | Integration with API Data in SnapLogic (Connect Cloud) |
| SQL Server Linked Server | Connect Cloud | Connect to API Data as a SQL Server Linked Server |
| Workato | Connect Cloud | Build Automated Workflows with Live API Data in Workato |
| Zapier | Connect Cloud | Build Automated API-Connected Workflows in Zapier |
Data Virtualization
| Product | Technology | Article Title |
|---|---|---|
| APOS Live Data Gateway | Connect Cloud | Build Semantic Layer Views for API Data (Connect Cloud) |
| Salesforce Connect | Connect Cloud | Edit and Search API External Objects in Salesforce Connect |
| Salesforce External Services | Connect Cloud | Connect to API through External Services in Salesforce |
| SQL Server PolyBase | Connect Cloud | Connect to API Data using PolyBase with Connect Cloud |
Software Development
Data Management
| Product | Technology | Article Title |
|---|---|---|
| HeidiSQL | Connect Cloud | Connect to API Data in HeidiSQL |
| MySQL Workbench | Connect Server | Query API Data in MySQL Workbench (Connect Server) |
Workflow Automation
| Product | Technology | Article Title |
|---|---|---|
| Nintex Workflow Cloud | Connect Cloud | Build API-Connected Workflows in Nintex |
| Power Automate | Connect Cloud | Integrate API Data into Power Automate Automated Tasks |
Data Connectors
ETL/ ELT Solutions
Cloud & API Connectivity
OEM & Custom Drivers