Microsoft Dataverse Integration Guides and Tutorials

Jerod Johnson
Jerod Johnson
Director, Technology Evangelism
A list of guides and tutorials for connecting to and working with live Microsoft Dataverse data.

CData Software's connectivity tools enable users to connect directly to live Microsoft Dataverse 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 Microsoft Dataverse data.

Integration Use-Cases

Click below to jump to articles related to specific integration use-case.

Artificial Intelligence


ProductTechnologyArticle Title
AgentforceConnect AIConnecting Agentforce with Microsoft Dataverse Data
AgnoConnect AIUse Agno to Talk to Your Microsoft Dataverse Data
Sourcegraph AmpConnect AIHow to Connect to Live Microsoft Dataverse Data from Sourcegraph Amp
AntigravityConnect AIIntegrate Google's Antigravity Agent with Live Microsoft Dataverse Data
Boomi AgentStudioConnect AIIntegrating Boomi AgentStudio with Microsoft Dataverse Data
ChatGPTConnect AIConnect Microsoft Dataverse Data to ChatGPT
Claude Agent SDKConnect AIHow to Connect to Live Microsoft Dataverse Data from Claude Agent SDK
Claude CodeConnect AIHow to Query Live Microsoft Dataverse in Claude Code
Claude.aiConnect AIUse Claude.ai to Talk to Your Microsoft Dataverse Data
ClineConnect AIIntegrate Cline with Live Microsoft Dataverse Data
MS Copilot StudioConnect AIConnect Microsoft Dataverse Data to Microsoft Copilot Studio
crewAIConnect AIHow to Connect to Live Microsoft Dataverse Data from crewAI Agents
CursorConnect AIIntegrate Cursor with Live Microsoft Dataverse Data
Databricks Agent BricksConnect AIUse Databricks Agent Bricks to Talk to Microsoft Dataverse Data
DataikuConnect AIIntegrating Dataiku with Microsoft Dataverse Data
DifyConnect AIIntegrate Dify with Live Microsoft Dataverse Data via CData Connect AI
ElevenLabsConnect AIBuild Voice Agents in ElevenLabs with Access to Live Microsoft Dataverse Data
EmergentConnect AIAccess Live Microsoft Dataverse Data in Emergent
FlowiseConnect AIHow to Connect Flowise AI Agents to Live Microsoft Dataverse Data
Azure AI FoundryConnect AIUse Azure AI Foundry to Talk to Your Microsoft Dataverse Data
Gemini EnterpriseConnect AIHow to Connect to Live Microsoft Dataverse Data from Gemini Enterprise
Gemini (CLI)Connect AIHow to Connect to Live Microsoft Dataverse Data from Gemini CLI
GenSparkConnect AIConnecting GenSpark with Microsoft Dataverse Data
Google ADKConnect AIHow to Connect to Live Microsoft Dataverse Data from Google ADK Agents
Google Vertex AIConnect AIIntegrate Google Vertex AI Agents with Live Microsoft Dataverse Data
GooseConnect AIIntegrate Goose with Live Microsoft Dataverse Data via CData Connect AI
GrokConnect AIUse Grok to Talk to Your Microsoft Dataverse Data
GumloopConnect AIIntegrating Gumloop with Microsoft Dataverse Data
IBM watsonx OrchestrateConnect AIBuild AI Agents with Microsoft Dataverse Data in IBM watsonx Orchestrate
LangchainConnect AIIntegrating LangChain with Microsoft Dataverse Data
LangGraphConnect AIIntegrating LangGraph with Microsoft Dataverse Data
LibreChatConnect AIIntegrate LibreChat with Live Microsoft Dataverse Data
LlamaIndexConnect AIIntegrating LlamaIndex with Microsoft Dataverse Data
Manus AIConnect AIUse Manus AI to Talk to Your Microsoft Dataverse Data
MastraConnect AIConnecting Mastra with Microsoft Dataverse Data
Mistral (Le Chat)Connect AIConnect Microsoft Dataverse Data to Mistral
MoonlitConnect AIConnecting Moonlit Workflow with Microsoft Dataverse Data
n8nConnect AIBuild Microsoft Dataverse-Connected Workflows and AI Agents in n8n
OpenAI SDK (Python)Connect AIHow to Connect to Live Microsoft Dataverse Data from OpenAI Python Applications
OpenCodeConnect AIIntegrate OpenCode with Live Microsoft Dataverse Data via CData Connect AI
Open WebUIConnect AIIntegrate Open WebUI with Live Microsoft Dataverse Data
Relevance AIConnect AIBuild Agents in Relevance AI with Access to Live Microsoft Dataverse Data
Roo CodeConnect AIAccess Live Microsoft Dataverse Data in Roo Code
Theia IDEConnect AIIntegrate Theia IDE with Live Microsoft Dataverse Data
WindsurfConnect AIIntegrate Live Microsoft Dataverse Data in the Windsurf IDE
ZedConnect AIQuery Live Microsoft Dataverse Data in Zed Editor
Python MCP ServerPythonConnect Microsoft Dataverse to AI Assistants With the CData Python MCP Server

Back to top

Business Intelligence & Analytics


ProductTechnologyArticle Title
LINQPadADO.NETWorking with Microsoft Dataverse in LINQPad
TIBCO SpotfireADO.NETVisualize Microsoft Dataverse in TIBCO Spotfire through ADO.NET
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Microsoft Dataverse
Azure Analysis ServicesConnect AIModel Microsoft Dataverse Data Using Azure Analysis Services
ACL AnalyticsConnect AIConnect to Microsoft Dataverse Data in ACL Analytics
Alteryx DesignerConnect AIWork with Live Microsoft Dataverse Data in Alteryx Designer (Connect AI)
Cognos Analytics (On-Prem)Connect AIAnalyze Microsoft Dataverse Data in Cognos Analytics
SAP Crystal ReportsConnect AIPublish Reports with Microsoft Dataverse in Crystal Reports (Connect AI)
GeckoboardConnect AICreate Dashboards and Visualize Live Microsoft Dataverse Data in Geckoboard
Looker StudioConnect AICreate Reports from Microsoft Dataverse Data in Looker Studio
GrafanaConnect AICreate Microsoft Dataverse-Connected Dashboards in Grafana
Infragistics RevealConnect AIAnalyze Microsoft Dataverse Data in Infragistics Reveal
KlipfolioConnect AICreate Microsoft Dataverse-Connected Visualizations in Klipfolio
LookerConnect AIAnalyze Microsoft Dataverse Data in Looker
MetabaseConnect AICreate Interactive Microsoft Dataverse-Connected Metabase Dashboards
MicroStrategyConnect AIConnect to Live Microsoft Dataverse Data in MicroStrategy through Connect AI
Mode AnalyticsConnect AICreate Microsoft Dataverse-Connected Visualizations in Mode
Power PivotConnect AIAccess Microsoft Dataverse Data in Microsoft Power Pivot
Power QueryConnect AIAccess Microsoft Dataverse Data in Microsoft Power Query
Power BI ServiceConnect AIVisualize Live Microsoft Dataverse Data in the Power BI Service
Qlik CloudConnect AICreate Apps from Microsoft Dataverse Data in Qlik Sense Cloud
Amazon QuickSightConnect AIBuild Interactive Dashboards from Microsoft Dataverse Data in Amazon QuickSight
RedashConnect AIQuery, Visualize, and Share live Microsoft Dataverse Data in Redash
SAP Analytics CloudConnect AIAnalyze Microsoft Dataverse Data in SAP Analytics Cloud
Amazon SageMakerConnect AIIntegrate Live Microsoft Dataverse data into Amazon SageMaker Canvas
SAS ViyaConnect AIAnalyze Live Microsoft Dataverse Data in SAS Viya
TableauConnect AIVisualize Microsoft Dataverse in Tableau Desktop (Connect AI)
Tableau CloudConnect AIBuild Microsoft Dataverse Visualizations in Tableau Cloud
ThoughtSpotConnect AIModel, Search, and Visualize Live Microsoft Dataverse Data in ThoughtSpot
Zoho AnalyticsConnect AICreate Microsoft Dataverse-Connected Dashboards in Zoho Analytics
Aqua Data StudioJDBCConnect to Microsoft Dataverse in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Microsoft Dataverse Data in Databricks (AWS)
BirstJDBCBuild Visualizations of Microsoft Dataverse in Birst
BIRTJDBCDesign BIRT Reports on Microsoft Dataverse
SAP Crystal ReportsJDBCPublish Reports with Microsoft Dataverse in Crystal Reports (JDBC)
FineReportJDBCFeed Microsoft Dataverse into FineReport
JasperServerJDBCCreate Microsoft Dataverse Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Microsoft Dataverse in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Microsoft Dataverse in JReport Designer
KNIMEJDBCEnable the Microsoft Dataverse JDBC Driver in KNIME
Microstrategy DesktopJDBCUse the CData JDBC Driver for Microsoft Dataverse in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Microsoft Dataverse in MicroStrategy Web
MicroStrategyJDBCUse the CData JDBC Driver for Microsoft Dataverse in MicroStrategy
OBIEEJDBCMicrosoft Dataverse Reporting in OBIEE with the Microsoft Dataverse JDBC Driver
Pentaho Report DesignerJDBCIntegrate Microsoft Dataverse in the Pentaho Report Designer
RJDBCAnalyze Microsoft Dataverse in R (JDBC)
RapidMinerJDBCConnect to Microsoft Dataverse in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Dataverse
SisenseJDBCVisualize Live Microsoft Dataverse in Sisense
Spago BIJDBCConnect to Microsoft Dataverse in SpagoBI
TIBCO Spotfire ServerJDBCOperational Reporting on Microsoft Dataverse from Spotfire Server
Alteryx DesignerODBCPrepare, Blend, and Analyze Microsoft Dataverse in Alteryx Designer (ODBC)
Clear AnalyticsODBCBuild Charts with Microsoft Dataverse in Clear Analytics
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Microsoft Dataverse
DBxtraODBCBuild Dashboards with Microsoft Dataverse in DBxtra
DomoODBCCreate Datasets from Microsoft Dataverse in Domo Workbench
Dundas BIODBCBuild Dashboards with Microsoft Dataverse in Dundas BI
QlikViewODBCConnect to and Query Microsoft Dataverse in QlikView over ODBC
RODBCAnalyze Microsoft Dataverse in R (ODBC)
SAS JMPODBCUse the CData ODBC Driver for Microsoft Dataverse in SAS JMP
SASODBCUse the CData ODBC Driver for Microsoft Dataverse in SAS for Real-Time Reporting and Analytics
VisioODBCLink Visio Shapes to Microsoft Dataverse
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Microsoft Dataverse
pandasPythonUse pandas to Visualize Microsoft Dataverse in Python
Microsoft Excel for the WebConnect SpreadsheetsAccess Live Microsoft Dataverse Data in Excel for the Web
Microsoft ExcelConnect SpreadsheetsAccess Live Microsoft Dataverse Data in Excel Desktop
Google SheetsConnect SpreadsheetsAccess Live Microsoft Dataverse Data in Google Sheets
TableauTableauVisualize Microsoft Dataverse in Tableau Desktop
Tableau ServerTableauPublish Microsoft Dataverse-Connected Dashboards in Tableau Server

Back to top

ETL & Replication


ProductTechnologyArticle Title
Azure Data FactoryConnect AIImport Microsoft Dataverse Data Using Azure Data Factory
AirbyteConnect AIConnect to Microsoft Dataverse Data in Airbyte ELT Pipelines
Google Data FusionConnect AIBuild Pipelines with Live Microsoft Dataverse Data in Google Cloud Data Fusion (CData Connect AI)
AWS GlueConnect AIBuild ETL Jobs with Microsoft Dataverse Data in AWS Glue Jobs
SQL Server Linked ServerConnect AIConnect to Microsoft Dataverse Data as a SQL Server Linked Server
petl (Python)Connect AIHow to Build an ETL App for Microsoft Dataverse Data in Python with petl
Microsoft Power AutomateConnect AIBuild Microsoft Dataverse-Connected Automated Tasks with Power Automate (Desktop)
SnapLogicConnect AIIntegration with Microsoft Dataverse Data in SnapLogic (Connect AI)
WorkatoConnect AIBuild Automated Workflows with Live Microsoft Dataverse Data in Workato
ZapierConnect AIBuild Automated Microsoft Dataverse-Connected Workflows in Zapier
Microsoft ExcelExcelTransfer Data from Excel to Microsoft Dataverse
Apache AirflowJDBCBridge Microsoft Dataverse Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Microsoft Dataverse using Apache Camel
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Microsoft Dataverse Data in Apache NiFi
Apache NiFiJDBCBridge Microsoft Dataverse Connectivity with Apache NiFi
CloverDXJDBCConnect to Microsoft Dataverse in CloverDX (formerly CloverETL)
ETL ValidatorJDBCHow to Work with Microsoft Dataverse in ETL Validator
Google Data FusionJDBCBuild Microsoft Dataverse-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to Microsoft Dataverse in HULFT Integrate
Informatica CloudJDBCIntegrate Microsoft Dataverse in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Microsoft Dataverse
Jaspersoft ETLJDBCConnect to Microsoft Dataverse in Jaspersoft Studio
Oracle Data IntegratorJDBCETL Microsoft Dataverse in Oracle Data Integrator
Pentaho Data IntegrationJDBCIntegrate Microsoft Dataverse in Pentaho Data Integration
SnapLogicJDBCIntegrate Microsoft Dataverse with External Services using SnapLogic (JDBC)
TalendJDBCConnect to Microsoft Dataverse and Transfer Data in Talend
FoxProODBCWork with Microsoft Dataverse in FoxPro
UiPath StudioODBCCreate an RPA Flow that Connects to Microsoft Dataverse in UiPath Studio
petlPythonExtract, Transform, and Load Microsoft Dataverse in Python
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Microsoft Dataverse to SQL Server
Google AlloyDBCData SyncAutomated Continuous Microsoft Dataverse Replication to Google AlloyDB
Microsoft Azure TablesCData SyncAutomated Continuous Microsoft Dataverse Replication to Azure SQL
Azure Data LakeCData SyncAutomated Continuous Microsoft Dataverse Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Microsoft Dataverse Replication to Azure Synapse
Google BigQueryCData SyncAutomated Continuous Microsoft Dataverse Replication to Google BigQuery
Apache CassandraCData SyncAutomated Continuous Microsoft Dataverse Replication to Apache Cassandra
CouchbaseCData SyncAutomated Continuous Microsoft Dataverse Replication to Couchbase
CSVCData SyncAutomated Continuous Microsoft Dataverse Replication to Local Delimited Files
DatabricksCData SyncAutomated Continuous Microsoft Dataverse Replication to Databricks
IBM DB2CData SyncAutomated Continuous Microsoft Dataverse Replication to IBM DB2
Google Cloud SQLCData SyncAutomated Continuous Microsoft Dataverse Replication to Google Cloud SQL
Heroku / Salesforce ConnectCData SyncReplicate Microsoft Dataverse for Use in Salesforce Connect
Apache KafkaCData SyncAutomated Continuous Microsoft Dataverse Replication to Apache Kafka
MongoDBCData SyncAutomated Continuous Microsoft Dataverse Replication to MongoDB
MySQLCData SyncAutomated Continuous Microsoft Dataverse Replication to MySQL
Microsoft OneLakeCData SyncAutomated Continuous Microsoft Dataverse Replication to Microsoft OneLake (Fabric)
Oracle DatabaseCData SyncAutomated Continuous Microsoft Dataverse Replication to Oracle
PostgreSQLCData SyncAutomated Continuous Microsoft Dataverse Replication to PostgreSQL
Amazon RedshiftCData SyncAutomated Continuous Microsoft Dataverse Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Microsoft Dataverse Replication to Amazon S3
SAP HANACData SyncAutomated Continuous Microsoft Dataverse Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Microsoft Dataverse Replication to SingleStore
SnowflakeCData SyncAutomated Continuous Microsoft Dataverse Replication to Snowflake
SQLiteCData SyncAutomated Continuous Microsoft Dataverse Replication to SQLite
SQL ServerCData SyncAutomated Continuous Microsoft Dataverse Replication to SQL Server
VerticaCData SyncAutomated Continuous Microsoft Dataverse Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Microsoft Dataverse
EF - Code FirstADO.NETAccess Microsoft Dataverse with Entity Framework 6
DevExpressADO.NETDataBind Microsoft Dataverse to the DevExpress Data Grid
EF - LINQADO.NETLINQ to Microsoft Dataverse
EF - MVCADO.NETBuild MVC Applications with Connectivity to Microsoft Dataverse
PowerBuilderADO.NETConnect to Microsoft Dataverse from PowerBuilder
Google Apps ScriptConnect AIConnect to Microsoft Dataverse Data in Google Apps Script
AppSheetConnect AICreate Microsoft Dataverse-Connected Business Apps in AppSheet
AppsmithConnect AICreate Microsoft Dataverse-Connected Applications in Appsmith
AxiosConnect AIBuild Microsoft Dataverse-Connected Web Apps with Axios and CData Connect AI
Bubble.ioConnect AIBuild Microsoft Dataverse-Connected Apps in Bubble
ChoreoConnect AIBuild Custom Apps on Microsoft Dataverse Data in Choreo
Dash (Python)Connect AIUse Dash to Build Web Apps on Live Microsoft Dataverse Data
JitterbitConnect AIIntegrate with Live Microsoft Dataverse Data in Jitterbit
MendixConnect AIBuild Microsoft Dataverse-Connected Apps in Mendix (Connect AI)
NodeJSConnect AIQuery Microsoft Dataverse Data in Node.js (via Connect AI)
OutSystemsConnect AICreate Microsoft Dataverse-Connected Enterprise Applications in OutSystems
pandas (Python)Connect AIHow to Visualize Microsoft Dataverse Data in Python with pandas
Microsoft Power AppsConnect AIIntegrate Live Microsoft Dataverse Data into Custom Business Apps Built in Power Apps
PythonConnect AIGetting Started with the CData Connect AI Python SDK for Microsoft Dataverse
RetoolConnect AIBuild Microsoft Dataverse-Connected Apps in Retool
RunMyProcessConnect AIConnect to Microsoft Dataverse Data in RunMyProcess
UnqorkConnect AICreate Microsoft Dataverse-Connected Applications in Unqork
Apache SparkJDBCWork with Microsoft Dataverse in Apache Spark Using SQL
AWS LambdaJDBCAccess Live Microsoft Dataverse Data in AWS Lambda
ColdFusionJDBCQuery Microsoft Dataverse in ColdFusion Using JDBC
Filemaker Pro (on Mac)JDBCBidirectional Access to Microsoft Dataverse from FileMaker Pro (on Mac)
HibernateJDBCObject-Relational Mapping (ORM) with Microsoft Dataverse Entities in Java
IntelliJJDBCConnect to Microsoft Dataverse in IntelliJ
JBossJDBCConnect to Microsoft Dataverse from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Microsoft Dataverse using JDBI
JetBrains RubyMineJDBCIntegrate Microsoft Dataverse with JetBrains RubyMine
JRubyJDBCConnect to Microsoft Dataverse in JRuby
MendixJDBCBuild Microsoft Dataverse-Connected Apps in Mendix (JDBC)
RunMyProcess DSECJDBCConnect to Microsoft Dataverse in DigitalSuite Studio through RunMyProcess DSEC
ServoyJDBCBuild Microsoft Dataverse-Connected Apps in Servoy
Spring BootJDBCAccess Live Microsoft Dataverse Data in Spring Boot Apps
TomcatJDBCConfigure the CData JDBC Driver for Microsoft Dataverse in a Connection Pool in Tomcat
WebLogicJDBCConnect to Microsoft Dataverse from a Connection Pool in WebLogic
.NET QueryBuilderODBCRapidly Develop Microsoft Dataverse-Driven Apps with Active Query Builder
ColdFusionODBCQuery Microsoft Dataverse in ColdFusion Using ODBC
C++BuilderODBCDataBind Controls to Microsoft Dataverse Data in C++Builder
DelphiODBCDataBind Controls to Microsoft Dataverse Data in Delphi
Filemaker ProODBCBidirectional Access to Microsoft Dataverse from FileMaker Pro
GoODBCWrite a Simple Go Application to work with Microsoft Dataverse on Linux
Lazarus IDEODBCEasily Integrate Microsoft Dataverse Data in Lazarus Pascal IDE
NodeJSODBCQuery Microsoft Dataverse through ODBC in Node.js
PHPODBCNatively Connect to Microsoft Dataverse in PHP
PyCharmODBCUsing the CData ODBC Driver for Microsoft Dataverse in PyCharm
PythonODBCConnect to Microsoft Dataverse in Python on Linux/UNIX
VCL App (RAD Studio)ODBCBuild a Simple VCL Application for Microsoft Dataverse
RubyODBCConnect to Microsoft Dataverse in Ruby
DashPythonUse Dash & Python to Build Web Apps on Microsoft Dataverse
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Microsoft Dataverse in Python

Back to top

Data Management



Back to top

Workflow Automation



Back to top

Ready to get started?