Learn more
 

Ready to get started?

Learn more:

API Connectivity Solutions

In this article

Related articles

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


ProductTechnologyArticle Title
Alteryx DesignerConnect CloudWork with Live API Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from API Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live API data into Amazon SageMaker Canvas
Azure Analysis ServicesConnect CloudModel API Data Using Azure Analysis Services
Cognos Analytics (On-Prem)Connect CloudAnalyze API Data in Cognos Analytics
Google SheetsConnect CloudAccess Live API Data in Google Sheets
Infragistics RevealConnect CloudAnalyze API Data in Infragistics Reval
KlipfolioConnect CloudCreate API-Connected Visualizations in Klipfolio
LookerConnect CloudAnalyze API Data in Looker
Looker StudioConnect CloudCreate Reports from API Data in Looker Studio
MetabaseConnect CloudCreate Interactive API-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live API Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live API Data in Excel for the Web
MicroStrategyConnect CloudConnect to Live API Data in MicroStrategy through Connect Cloud
Mode AnalyticsConnect CloudCreate API-Connected Visualizations in Mode
Power BI ServiceConnect CloudVisualize Live API Data in the Power BI Service
Power PivotConnect CloudAccess API Data in Microsoft Power Pivot
Power QueryConnect CloudAccess API Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from API Data in Qlik Sense Cloud
RedashConnect ServerBuild API-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze API Data in SAP Analytics Cloud
SAS ViyaConnect CloudAnalyze Live API Data in SAS Viya
Tableau CloudConnect CloudBuild API Visualizations in Tableau Cloud
TIBCO SpotfireConnect ServerVisualize API Data in TIBCO Spotfire
Zoho AnalyticsConnect CloudCreate API-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to API Data in Airbyte ELT Pipelines
AWS GlueConnect CloudBuild ETL Jobs with API Data in AWS Glue Jobs
Azure Data FactoryConnect CloudImport API Data Using Azure Data Factory
Microsoft Power AutomateConnect CloudBuild API-Connected Automated Tasks with Power Automate (Desktop)
SQL Server Linked ServerConnect CloudConnect to API Data as a SQL Server Linked Server

Back to top

Data Virtualization


ProductTechnologyArticle Title
APOS Live Data GatewayConnect CloudBuild Semantic Layer Views for API Data (Connect Cloud)
Salesforce ConnectConnect CloudEdit and Search API External Objects in Salesforce Connect
SQL Server PolyBaseConnect CloudConnect to API Data using PolyBase with Connect Cloud

Back to top

Software Development


ProductTechnologyArticle Title
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with API
AppSheetConnect CloudCreate API-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild API-Connected Apps in Bubble
ChoreoConnect CloudBuild Custom Apps on API Data in Choreo
Google Apps ScriptConnect CloudConnect to API Data in Google Apps Script
MendixConnect CloudBuild API-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live API Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery API Data in Node.js (via Connect Cloud)
OutSystemsConnect CloudCreate API-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess API in PHP through Connect Server
ReactConnect ServerBuild Dynamic React Apps with API Data
RunMyProcessConnect CloudConnect to API Data in RunMyProcess
SAP UI5Connect ServerIntegrate Real-Time Access to API in SAPUI5 MVC Apps
UnqorkConnect CloudCreate API-Connected Applications in Unqork

Back to top

Data Management


ProductTechnologyArticle Title
MySQL WorkbenchConnect ServerQuery API Data in MySQL Workbench (Connect Server)

Back to top

Workflow Automation


ProductTechnologyArticle Title
Nintex Workflow CloudConnect CloudBuild API-Connected Workflows in Nintex
Power AutomateConnect CloudIntegrate API Data into Power Automate Automated Tasks

Back to top