DB2 Data Cloud Connectivity
CData Connect AI provides access to DB2 data from popular BI, analytics, ETL, and custom applications. In addition to pre-built client tools, CData Connect AI enables direct real-time bi-directional integration from a wide range of cloud applications. Below you will find a list of guides and tutorials for integrating with live DB2 data.
Connect AI Integrations
Click below to jump to articles related to specific integration use-case.
- Artificial Intelligence - agents, chatbots, and workflows (Claude, ChatGPT, n8n, crewAI, etc.)
- Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
- ETL & Replication - moving and replicating data (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.)
Artificial Intelligence
Business Intelligence & Analytics
ETL & Replication
| Product | Article Title |
|---|---|
| Airbyte | Connect to DB2 Data in Airbyte ELT Pipelines |
| AWS Glue | Build ETL Jobs with DB2 Data in AWS Glue Jobs |
| Azure Data Factory | Import DB2 Data Using Azure Data Factory |
| Google Data Fusion | Build Pipelines with Live DB2 Data in Google Cloud Data Fusion (CData Connect AI) |
| Microsoft Power Automate | Build DB2-Connected Automated Tasks with Power Automate (Desktop) |
| SnapLogic | Integration with DB2 Data in SnapLogic (Connect AI) |
| SQL Server Linked Server | Connect to DB2 Data as a SQL Server Linked Server |
| Workato | Build Automated Workflows with Live DB2 Data in Workato |
| Zapier | Build Automated DB2-Connected Workflows in Zapier |
Data Virtualization
| Product | Article Title |
|---|---|
| APOS Live Data Gateway | Build Semantic Layer Views for DB2 Data (Connect AI) |
| Salesforce Connect | Edit and Search DB2 External Objects in Salesforce Connect |
| Salesforce External Services | Connect to DB2 through External Services in Salesforce |
| SQL Server PolyBase | Connect to DB2 Data using PolyBase with Connect AI |
Software Development
| Product | Article Title |
|---|---|
| Axios | Build DB2-Connected Web Apps with Axios and CData Connect AI |
| AppSheet | Create DB2-Connected Business Apps in AppSheet |
| Bubble.io | Build DB2-Connected Apps in Bubble |
| Choreo | Build Custom Apps on DB2 Data in Choreo |
| Google Apps Script | Connect to DB2 Data in Google Apps Script |
| Jitterbit | Integrate with Live DB2 Data in Jitterbit |
| Mendix | Build DB2-Connected Apps in Mendix (Connect AI) |
| Microsoft Power Apps | Integrate Live DB2 Data into Custom Business Apps Built in Power Apps |
| NodeJS | Query DB2 Data in Node.js (via Connect AI) |
| OutSystems | Create DB2-Connected Enterprise Applications in OutSystems |
| Retool | Build DB2-Connected Apps in Retool |
| RunMyProcess | Connect to DB2 Data in RunMyProcess |
| Unqork | Create DB2-Connected Applications in Unqork |
Data Management
| Product | Article Title |
|---|---|
| HeidiSQL | Connect to DB2 Data in HeidiSQL |
Workflow Automation
| Product | Article Title |
|---|---|
| Nintex Workflow Cloud | Build DB2-Connected Workflows in Nintex |
| Power Automate | Integrate DB2 Data into Power Automate Automated Tasks |