Dynamics 365 Integration Guides and Tutorials
CData Software's connectivity tools enable users to connect directly to live Dynamics 365 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 Dynamics 365 data.
Integration Use-Cases
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 (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.)
Artificial Intelligence
Business Intelligence & Analytics
ETL & Replication
Data Virtualization
Software Development
Data Management
| Product | Technology | Article Title |
|---|---|---|
| HeidiSQL | Connect AI | Connect to Dynamics 365 Data in HeidiSQL |
| Apache Solr | JDBC | Import Dynamics 365 Data into Apache Solr |
| Coginiti Pro | JDBC | Access Live Dynamics 365 Data in Coginiti Pro |
| DataGrip | JDBC | Query Dynamics 365 Data in DataGrip |
| DB Artisan | JDBC | Manage Dynamics 365 in DBArtisan as a JDBC Source |
| DbVisualizer | JDBC | Connect to Dynamics 365 in DBVisualizer |
| DBeaver | JDBC | Connect to Dynamics 365 in DBeaver |
| Informatica Enterprise Data Catalog | JDBC | Add Dynamics 365 to Informatica Enterprise Data Catalog |
| QuerySurge | JDBC | Validate Dynamics 365 Data with QuerySurge |
| RazorSQL | JDBC | Connect to Dynamics 365 in RazorSQL |
| SQuirreL | JDBC | Connect to Dynamics 365 in Squirrel SQL Client |
| DB Artisan | ODBC | Connect to Dynamics 365 in DBArtisan |
| MySQL Workbench | ODBC | Query Dynamics 365 in MySQL Workbench (ODBC) |
Workflow Automation
| Product | Technology | Article Title |
|---|---|---|
| Nintex Workflow Cloud | Connect AI | Build Dynamics 365-Connected Workflows in Nintex |
| Pipedream | Connect AI | Connecting Pipedream with Dynamics 365 Data via CData Connect AI |
| Power Automate | Connect AI | Integrate Dynamics 365 Data into Power Automate Automated Tasks |
| MuleSoft Anypoint | JDBC | Access Dynamics 365 in Anypoint Using SQL |
| Blue Prism | ODBC | Integrate Live Dynamics 365 Data for Intelligent Robotic Process Automation |
| SSIS Export | SSIS | Export Data from SQL Server to Dynamics 365 through SSIS |
| SSIS Import | SSIS | Import Dynamics 365 Data into SQL Server using SSIS |
| SSIS Lookup | SSIS | Insert New or Update Existing Dynamics 365 Records from SQL Server |