Dynamics 365 Business Central Data Cloud Connectivity

Jerod Johnson
Director, Technology Evangelism

Explore a compilation of guides and tutorials demonstrating how to establish connections to Dynamics 365 Business Central data through CData Connect AI using different applications and tools.

CData Connect AI provides access to Dynamics 365 Business Central 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 Dynamics 365 Business Central 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

Product	Technology	Article Title
Agentforce	Connect AI	Connecting Agentforce with Dynamics 365 Business Central Data
Azure AI Foundry	Connect AI	Use Azure AI Foundry to Talk to Your Dynamics 365 Business Central Data
Boomi AgentStudio	Connect AI	Integrating Boomi AgentStudio with Dynamics 365 Business Central Data
ChatGPT	Connect AI	Connect Dynamics 365 Business Central Data to ChatGPT
Claude Code	Connect AI	How to Query Live Dynamics 365 Business Central in Claude Code
Claude.ai	Connect AI	Use Claude.ai to Talk to Your Dynamics 365 Business Central Data
crewAI	Connect AI	How to Connect to Live Dynamics 365 Business Central Data from crewAI Agents
Cursor	Connect AI	Integrate Cursor with Live Dynamics 365 Business Central Data
Databricks Agent Bricks	Connect AI	Use Databricks Agent Bricks to Talk to Dynamics 365 Business Central Data
Dataiku	Connect AI	Integrating Dataiku with Dynamics 365 Business Central Data
Flowise	Connect AI	How to Connect Flowise AI Agents to Live Dynamics 365 Business Central Data
Gemini (CLI)	Connect AI	How to Connect to Live Dynamics 365 Business Central Data from Gemini CLI
Gemini Enterprise	Connect AI	How to Connect to Live Dynamics 365 Business Central Data from Gemini Enterprise
Google ADK	Connect AI	How to Connect to Live Dynamics 365 Business Central Data from Google ADK Agents
Google Vertex AI	Connect AI	Integrate Google Vertex AI Agents with Live Dynamics 365 Business Central Data
Gumloop	Connect AI	Integrating Gumloop with Dynamics 365 Business Central Data
IBM watsonx Orchestrate	Connect AI	Build AI Agents with Dynamics 365 Business Central Data in IBM watsonx Orchestrate
Langchain	Connect AI	Integrating LangChain with Dynamics 365 Business Central Data
LangGraph	Connect AI	Integrating LangGraph with Dynamics 365 Business Central Data
Mastra	Connect AI	Connecting Mastra with Dynamics 365 Business Central Data
Mistral (Le Chat)	Connect AI	Connect Dynamics 365 Business Central Data to Mistral
MS Copilot Studio	Connect AI	Connect Dynamics 365 Business Central Data to Microsoft Copilot Studio
n8n	Connect AI	Build Dynamics 365 Business Central-Connected Workflows and AI Agents in n8n
OpenAI SDK (Python)	Connect AI	How to Connect to Live Dynamics 365 Business Central Data from OpenAI Python Applications
Relevance AI	Connect AI	Build Agents in Relevance AI with Access to Live Dynamics 365 Business Central Data
Sourcegraph Amp	Connect AI	How to Connect to Live Dynamics 365 Business Central Data from Sourcegraph Amp

Business Intelligence & Analytics

Product	Article Title
Alteryx Designer	Work with Live Dynamics 365 Business Central Data in Alteryx Designer (Connect AI)
Amazon QuickSight	Build Interactive Dashboards from Dynamics 365 Business Central Data in Amazon QuickSight
Amazon SageMaker	Integrate Live Dynamics 365 Business Central data into Amazon SageMaker Canvas
Azure Analysis Services	Model Dynamics 365 Business Central Data Using Azure Analysis Services
Cognos Analytics (On-Prem)	Analyze Dynamics 365 Business Central Data in Cognos Analytics
Gecokboard	Create Dashboards and Visualize Live Dynamics 365 Business Central Data in Geckoboard
Google Sheets	Access Live Dynamics 365 Business Central Data in Google Sheets
Grafana	Create Dynamics 365 Business Central-Connected Dashboards in Grafana
Infragistics Reveal	Analyze Dynamics 365 Business Central Data in Infragistics Reval
Klipfolio	Create Dynamics 365 Business Central-Connected Visualizations in Klipfolio
Looker	Analyze Dynamics 365 Business Central Data in Looker
Looker Studio	Create Reports from Dynamics 365 Business Central Data in Looker Studio
Metabase	Create Interactive Dynamics 365 Business Central-Connected Metabase Dashboards
Microsoft Excel	Access Live Dynamics 365 Business Central Data in Excel Desktop
Microsoft Excel for the Web	Access Live Dynamics 365 Business Central Data in Excel for the Web
MicroStrategy	Connect to Live Dynamics 365 Business Central Data in MicroStrategy through Connect AI
Mode Analytics	Create Dynamics 365 Business Central-Connected Visualizations in Mode
Power BI Service	Visualize Live Dynamics 365 Business Central Data in the Power BI Service
Power Pivot	Access Dynamics 365 Business Central Data in Microsoft Power Pivot
Power Query	Access Dynamics 365 Business Central Data in Microsoft Power Query
Qlik Cloud	Create Apps from Dynamics 365 Business Central Data in Qlik Sense Cloud
Redash	Query, Visualize, and Share live Dynamics 365 Business Central Data in Redash
SAP Analytics Cloud	Analyze Dynamics 365 Business Central Data in SAP Analytics Cloud
SAP Crystal Reports	Publish Reports with Dynamics 365 Business Central in Crystal Reports (Connect AI)
SAS Viya	Analyze Live Dynamics 365 Business Central Data in SAS Viya
Tableau	Visualize Dynamics 365 Business Central in Tableau Desktop (Connect AI)
Tableau Cloud	Build Dynamics 365 Business Central Visualizations in Tableau Cloud
ThoughtSpot	Model, Search, and Visualize Live Dynamics 365 Business Central Data in ThoughtSpot
Zoho Analytics	Create Dynamics 365 Business Central-Connected Dashboards in Zoho Analytics

ETL & Replication

Product	Article Title
Airbyte	Connect to Dynamics 365 Business Central Data in Airbyte ELT Pipelines
AWS Glue	Build ETL Jobs with Dynamics 365 Business Central Data in AWS Glue Jobs
Azure Data Factory	Import Dynamics 365 Business Central Data Using Azure Data Factory
Google Data Fusion	Build Pipelines with Live Dynamics 365 Business Central Data in Google Cloud Data Fusion (CData Connect AI)
Microsoft Power Automate	Build Dynamics 365 Business Central-Connected Automated Tasks with Power Automate (Desktop)
SnapLogic	Integration with Dynamics 365 Business Central Data in SnapLogic (Connect AI)
SQL Server Linked Server	Connect to Dynamics 365 Business Central Data as a SQL Server Linked Server
Workato	Build Automated Workflows with Live Dynamics 365 Business Central Data in Workato
Zapier	Build Automated Dynamics 365 Business Central-Connected Workflows in Zapier

Data Virtualization

Product	Article Title
APOS Live Data Gateway	Build Semantic Layer Views for Dynamics 365 Business Central Data (Connect AI)
Salesforce Connect	Edit and Search Dynamics 365 Business Central External Objects in Salesforce Connect
Salesforce External Services	Connect to Dynamics 365 Business Central through External Services in Salesforce
SQL Server PolyBase	Connect to Dynamics 365 Business Central Data using PolyBase with Connect AI

Software Development

Product	Article Title
Axios	Build Dynamics 365 Business Central-Connected Web Apps with Axios and CData Connect AI
AppSheet	Create Dynamics 365 Business Central-Connected Business Apps in AppSheet
Bubble.io	Build Dynamics 365 Business Central-Connected Apps in Bubble
Choreo	Build Custom Apps on Dynamics 365 Business Central Data in Choreo
Google Apps Script	Connect to Dynamics 365 Business Central Data in Google Apps Script
Jitterbit	Integrate with Live Dynamics 365 Business Central Data in Jitterbit
Mendix	Build Dynamics 365 Business Central-Connected Apps in Mendix (Connect AI)
Microsoft Power Apps	Integrate Live Dynamics 365 Business Central Data into Custom Business Apps Built in Power Apps
NodeJS	Query Dynamics 365 Business Central Data in Node.js (via Connect AI)
OutSystems	Create Dynamics 365 Business Central-Connected Enterprise Applications in OutSystems
Retool	Build Dynamics 365 Business Central-Connected Apps in Retool
RunMyProcess	Connect to Dynamics 365 Business Central Data in RunMyProcess
Unqork	Create Dynamics 365 Business Central-Connected Applications in Unqork

Data Management

Product	Article Title
HeidiSQL	Connect to Dynamics 365 Business Central Data in HeidiSQL

Workflow Automation

Product	Article Title
Nintex Workflow Cloud	Build Dynamics 365 Business Central-Connected Workflows in Nintex
Power Automate	Integrate Dynamics 365 Business Central Data into Power Automate Automated Tasks

Ready to get started?

Learn more about CData Connect AI or sign up for free trial access:

Free Trial

URL: https://www.cdata.com/kb/tech/d365businesscentral-cloud-integration.rst