Microsoft Dataverse Drivers & Connectors
for Data Integration

Connect to Microsoft Dataverse (Common Data Service) data through easy-to-use, bi-directional drivers. Easily integrate Microsoft Dataverse data with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


Decorative Icon Microsoft Dataverse Logo


Other Technologies



BI & Analytics



Our drivers offer the fastest and easiest way to connect real-time Microsoft Dataverse data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Microsoft Dataverse data and metadata, and seamlessly integrate with your favorite analytics tools.

LEARN MORE: Connectivity for BI & Analytics

Popular BI & Analytics Integrations



Alteryx Designer: Prepare, Blend, and Analyze Microsoft Dataverse in Alteryx Designer (ODBC) Alteryx Designer: Work with Live Microsoft Dataverse Data in Alteryx Designer (Connect Cloud) Amazon QuickSight: Build Interactive Dashboards from Microsoft Dataverse Data in Amazon QuickSight Amazon SageMaker: Integrate Live Microsoft Dataverse data into Amazon SageMaker Canvas Aqua Data Studio: Connect to Microsoft Dataverse in Aqua Data Studio AWS Databricks: Process & Analyze Microsoft Dataverse Data in Databricks (AWS) Azure Analysis Services: Model Microsoft Dataverse Data Using Azure Analysis Services Birst: Build Visualizations of Microsoft Dataverse in Birst BIRT: Design BIRT Reports on Microsoft Dataverse Clear Analytics: Build Charts with Microsoft Dataverse in Clear Analytics Cognos Analytics (On-Prem): Analyze Microsoft Dataverse Data in Cognos Analytics DBxtra: Build Dashboards with Microsoft Dataverse in DBxtra Domo: Create Datasets from Microsoft Dataverse in Domo Workbench Dundas BI: Build Dashboards with Microsoft Dataverse in Dundas BI Excel (on Mac OS): Work with Microsoft Dataverse Data in MS Excel on Mac OS X FineReport: Feed Microsoft Dataverse into FineReport Google Sheets: Access Live Microsoft Dataverse Data in Google Sheets IBM Cognos BI: Create Data Visualizations in Cognos BI with Microsoft Dataverse Infragistics Reveal: Analyze Microsoft Dataverse Data in Infragistics Reval JasperServer: Create Microsoft Dataverse Reports on JasperReports Server Jaspersoft BI Suite: Connect to Microsoft Dataverse in Jaspersoft Studio JReport Designer: Integrate with Microsoft Dataverse in JReport Designer Klipfolio: Create Microsoft Dataverse-Connected Visualizations in Klipfolio KNIME: Enable the Microsoft Dataverse JDBC Driver in KNIME LINQPad: Working with Microsoft Dataverse in LINQPad Looker: Analyze Microsoft Dataverse Data in Looker Looker Studio: Create Reports from Microsoft Dataverse Data in Looker Studio Metabase: Create Interactive Microsoft Dataverse-Connected Metabase Dashboards Microsoft Excel: Access Live Microsoft Dataverse Data in Excel Desktop Microsoft Excel for the Web: Access Live Microsoft Dataverse Data in Excel for the Web Microsoft SSAS: Build an OLAP Cube in SSAS from Microsoft Dataverse MicroStrategy: Connect to Live Microsoft Dataverse Data in MicroStrategy through Connect Cloud MicroStrategy: Use the CData JDBC Driver for Microsoft Dataverse in MicroStrategy Microstrategy Desktop: Use the CData JDBC Driver for Microsoft Dataverse in MicroStrategy Desktop Microstrategy Web: Use the CData JDBC Driver for Microsoft Dataverse in MicroStrategy Web Mode Analytics: Create Microsoft Dataverse-Connected Visualizations in Mode OBIEE: Microsoft Dataverse Reporting in OBIEE with the Microsoft Dataverse JDBC Driver pandas: Use pandas to Visualize Microsoft Dataverse in Python Pentaho Report Designer: Integrate Microsoft Dataverse in the Pentaho Report Designer Power BI Desktop: Author Power BI Reports on Real-Time Microsoft Dataverse Power BI Service: Visualize Live Microsoft Dataverse Data in the Power BI Service Power Pivot: Access Microsoft Dataverse Data in Microsoft Power Pivot Power Query: Access Microsoft Dataverse Data in Microsoft Power Query Qlik Cloud: Create Apps from Microsoft Dataverse Data in Qlik Sense Cloud QlikView: Connect to and Query Microsoft Dataverse in QlikView over ODBC R: Analyze Microsoft Dataverse in R (JDBC) R: Analyze Microsoft Dataverse in R (ODBC) RapidMiner: Connect to Microsoft Dataverse in RapidMiner Redash: Build Microsoft Dataverse-Connected Dashboards in Redash SAP Analytics Cloud: Analyze Microsoft Dataverse Data in SAP Analytics Cloud SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Microsoft Dataverse SAP Crystal Reports: Publish Reports with Microsoft Dataverse in Crystal Reports SAS: Use the CData ODBC Driver for Microsoft Dataverse in SAS for Real-Time Reporting and Analytics SAS JMP: Use the CData ODBC Driver for Microsoft Dataverse in SAS JMP SAS Viya: Analyze Live Microsoft Dataverse Data in SAS Viya Sisense: Visualize Live Microsoft Dataverse in Sisense Spago BI: Connect to Microsoft Dataverse in SpagoBI Tableau: Visualize Microsoft Dataverse in Tableau Desktop Tableau Cloud: Build Microsoft Dataverse Visualizations in Tableau Cloud Tableau Server: Publish Microsoft Dataverse-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Microsoft Dataverse in TIBCO Spotfire through ADO.NET TIBCO Spotfire: Visualize Microsoft Dataverse Data in TIBCO Spotfire TIBCO Spotfire Server: Operational Reporting on Microsoft Dataverse from Spotfire Server Visio: Link Visio Shapes to Microsoft Dataverse Zoho Analytics: Create Microsoft Dataverse-Connected Dashboards in Zoho Analytics

ETL, Replication, & Warehousing



From drivers and adapters that extend your favorite ETL tools with Microsoft Dataverse connectivity to ETL/ELT tools for replication — our Microsoft Dataverse integration solutions provide robust, reliable, and secure data movement.

Connect your RDBMS or data warehouse with Microsoft Dataverse to facilitate operational reporting, offload queries and increase performance, support data governance initiatives, archive data for disaster recovery, and more.


Popular Data Warehousing Integrations



Airbyte: Connect to Microsoft Dataverse Data in Airbyte ELT Pipelines Amazon Redshift: Automated Continuous Microsoft Dataverse Replication to Amazon Redshift Amazon S3: Automated Continuous Microsoft Dataverse Replication to Amazon S3 Apache Airflow: Bridge Microsoft Dataverse Connectivity with Apache Airflow Apache Camel: Integrate with Microsoft Dataverse using Apache Camel Apache Cassandra: Automated Continuous Microsoft Dataverse Replication to Apache Cassandra Apache Kafka: Automated Continuous Microsoft Dataverse Replication to Apache Kafka Apache NiFi: Bridge Microsoft Dataverse Connectivity with Apache NiFi Apache NiFi Batch Operations: Perform Batch Operations with Microsoft Dataverse Data in Apache NiFi AWS Glue: Build ETL Jobs with Microsoft Dataverse Data in AWS Glue Jobs Azure Data Factory: Import Microsoft Dataverse Data Using Azure Data Factory Azure Data Lake: Automated Continuous Microsoft Dataverse Replication to Azure Data Lake Azure Synapse: Automated Continuous Microsoft Dataverse Replication to Azure Synapse BIML: Use Biml to Build SSIS Tasks to Replicate Microsoft Dataverse to SQL Server CloverDX: Connect to Microsoft Dataverse in CloverDX (formerly CloverETL) Couchbase: Automated Continuous Microsoft Dataverse Replication to Couchbase CSV: Automated Continuous Microsoft Dataverse Replication to Local Delimited Files Databricks: Automated Continuous Microsoft Dataverse Replication to Databricks FoxPro: Work with Microsoft Dataverse in FoxPro Google AlloyDB: Automated Continuous Microsoft Dataverse Replication to Google AlloyDB Google BigQuery: Automated Continuous Microsoft Dataverse Replication to Google BigQuery Google Cloud SQL: Automated Continuous Microsoft Dataverse Replication to Google Cloud SQL Google Data Fusion: Build Microsoft Dataverse-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate Microsoft Dataverse for Use in Salesforce Connect HULFT Integrate: Connect to Microsoft Dataverse in HULFT Integrate IBM DB2: Automated Continuous Microsoft Dataverse Replication to IBM DB2 Informatica Cloud: Integrate Microsoft Dataverse in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Microsoft Dataverse Jaspersoft ETL: Connect to Microsoft Dataverse in Jaspersoft Studio Microsoft Access: Automated Continuous Microsoft Dataverse Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Microsoft Dataverse Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Microsoft Dataverse Microsoft Power Automate: Build Microsoft Dataverse-Connected Automated Tasks with Power Automate (Desktop) MongoDB: Automated Continuous Microsoft Dataverse Replication to MongoDB MySQL: Automated Continuous Microsoft Dataverse Replication to MySQL Oracle Data Integrator: ETL Microsoft Dataverse in Oracle Data Integrator Oracle Database: Automated Continuous Microsoft Dataverse Replication to Oracle petl: Extract, Transform, and Load Microsoft Dataverse in Python PostgreSQL: Automated Continuous Microsoft Dataverse Replication to PostgreSQL Replicate to MySQL: Replicate Microsoft Dataverse to MySQL with PowerShell SAP HANA: Automated Continuous Microsoft Dataverse Replication to SAP HANA SingleStore: Automated Continuous Microsoft Dataverse Replication to SingleStore SnapLogic: Integrate Microsoft Dataverse with External Services using SnapLogic Snowflake: Automated Continuous Microsoft Dataverse Replication to Snowflake SQL Server: Automated Continuous Microsoft Dataverse Replication to SQL Server SQL Server Linked Server: Connect to Microsoft Dataverse Data as a SQL Server Linked Server SQLite: Automated Continuous Microsoft Dataverse Replication to SQLite Talend: Connect to Microsoft Dataverse and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Microsoft Dataverse in UiPath Studio Vertica: Automated Continuous Microsoft Dataverse Replication to a Vertica Database

Workflow & Automation Tools



Connect to Microsoft Dataverse from popular data migration, ESB, iPaaS, and BPM tools.

Our drivers and adapters provide straightforward access to Microsoft Dataverse data from popular applications like BizTalk, MuleSoft, SQL SSIS, Microsoft Flow, Power Apps, Talend, and many more.

Popular Workflow & Automation Tool Integrations



Developer Tools & Technologies



The easiest way to integrate with Microsoft Dataverse from anywhere. Our Microsoft Dataverse drivers offer a data-centric model for Microsoft Dataverse that dramatically simplifies integration — allowing developers to build higher quality applications, faster than ever before. Learn more about the benefits for developers:



Popular Developer Integrations



.NET Charts: DataBind Charts to Microsoft Dataverse .NET QueryBuilder: Rapidly Develop Microsoft Dataverse-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Microsoft Dataverse Apache Spark: Work with Microsoft Dataverse in Apache Spark Using SQL AppSheet: Create Microsoft Dataverse-Connected Business Apps in AppSheet Bubble.io: Build Microsoft Dataverse-Connected Apps in Bubble C++Builder: DataBind Controls to Microsoft Dataverse Data in C++Builder Choreo: Build Custom Apps on Microsoft Dataverse Data in Choreo ColdFusion: Query Microsoft Dataverse in ColdFusion Using JDBC ColdFusion: Query Microsoft Dataverse in ColdFusion Using ODBC Dash: Use Dash & Python to Build Web Apps on Microsoft Dataverse Delphi: DataBind Controls to Microsoft Dataverse Data in Delphi DevExpress: DataBind Microsoft Dataverse to the DevExpress Data Grid EF - Code First: Access Microsoft Dataverse with Entity Framework 6 EF - LINQ: LINQ to Microsoft Dataverse EF - MVC: Build MVC Applications with Connectivity to Microsoft Dataverse Filemaker Pro: Bidirectional Access to Microsoft Dataverse from FileMaker Pro Filemaker Pro (on Mac): Bidirectional Access to Microsoft Dataverse from FileMaker Pro (on Mac) Go: Write a Simple Go Application to work with Microsoft Dataverse on Linux Google Apps Script: Connect to Microsoft Dataverse Data in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Microsoft Dataverse Entities in Java IntelliJ: Connect to Microsoft Dataverse in IntelliJ JBoss: Connect to Microsoft Dataverse from a Connection Pool in JBoss JDBI: Create a Data Access Object for Microsoft Dataverse using JDBI JRuby: Connect to Microsoft Dataverse in JRuby Mendix: Build Microsoft Dataverse-Connected Apps in Mendix Microsoft Power Apps: Integrate Live Microsoft Dataverse Data into Custom Business Apps Built in Power Apps NodeJS: Query Microsoft Dataverse Data in Node.js (via Connect Cloud) NodeJS: Query Microsoft Dataverse through ODBC in Node.js OutSystems: Create Microsoft Dataverse-Connected Enterprise Applications in OutSystems PHP: Access Microsoft Dataverse in PHP through Connect Server PHP: Natively Connect to Microsoft Dataverse in PHP PowerBuilder: Connect to Microsoft Dataverse from PowerBuilder PowerShell: Pipe Microsoft Dataverse to CSV in PowerShell PyCharm: Using the CData ODBC Driver for Microsoft Dataverse in PyCharm Python: Connect to Microsoft Dataverse in Python on Linux/UNIX React: Build Dynamic React Apps with Microsoft Dataverse Data Ruby: Connect to Microsoft Dataverse in Ruby RunMyProcess: Connect to Microsoft Dataverse Data in RunMyProcess RunMyProcess DSEC: Connect to Microsoft Dataverse in DigitalSuite Studio through RunMyProcess DSEC SAP UI5: Integrate Real-Time Access to Microsoft Dataverse in SAPUI5 MVC Apps Servoy: Build Microsoft Dataverse-Connected Apps in Servoy Spring Boot: Access Live Microsoft Dataverse Data in Spring Boot Apps SQLAlchemy: Use SQLAlchemy ORMs to Access Microsoft Dataverse in Python Tomcat: Configure the CData JDBC Driver for Microsoft Dataverse in a Connection Pool in Tomcat Unqork: Create Microsoft Dataverse-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for Microsoft Dataverse WebLogic: Connect to Microsoft Dataverse from a Connection Pool in WebLogic


When Only the Best Microsoft Dataverse Drivers Will Do

See what customers have to say about our products and support.



Frequently Asked Microsoft Dataverse Driver Questions

Learn more about Microsoft Dataverse drivers & connectors for data and analytics integration


The Microsoft Dataverse driver acts like a bridge that facilitates communication between various applications and Microsoft Dataverse, allowing the application to read data as if it were a relational database. The Microsoft Dataverse driver abstracts the complexities of Microsoft Dataverse APIs, authentication methods, and data types, making it simple for any application to connect to Microsoft Dataverse data in real-time via standard SQL queries.

Working with a Microsoft Dataverse Driver is different than connecting with Microsoft Dataverse through other means. Microsoft Dataverse API integrations require technical experience from a software developer or IT resources. Additionally, due to the constant evolution of APIs and services, once you build your integration you have to constantly maintain Microsoft Dataverse integration code moving forward.

By comparison, our Microsoft Dataverse Drivers offer codeless access to live Microsoft Dataverse data for both technical and non-technical users alike. Any user can install our drivers and begin working with live Microsoft Dataverse data from any client application. Because our drivers conform to standard data interfaces like ODBC, JDBC, ADO.NET etc. they offer a consistent, maintenance-free interface to Microsoft Dataverse data. We manage all of the complexities of Microsoft Dataverse integration within each driver and deploy updated drivers as systems evolve so your applications continue to run seamlessly.

If you need truly zero-maintenance integration, check out connectivity to Microsoft Dataverse via CData Connect Cloud. With Connect Cloud you can configure all of your data connectivity in one place and connect to Microsoft Dataverse from any of the available Cloud Drivers and Client Applications. Connectivity to Microsoft Dataverse is managed in the cloud, and you never have to worry about installing new drivers when Microsoft Dataverse is updated.

Many organizations draw attention to their library of connectors. After all, data connectivity is a core capability needed for applications to maximize their business value. However, it is essential to understand exactly what you are getting when evaluating connectivity. Some vendors are happy to offer connectors that implement basic proof-of-concept level connectivity. These connectors may highlight the possibilities of working with Microsoft Dataverse, but often only provide a fraction of capability. Finding real value from these connectors usually requires additional IT or development resources.

Unlike these POC-quality connectors, every CData Microsoft Dataverse driver offers full-featured Microsoft Dataverse data connectivity. The CData Microsoft Dataverse drivers support extensive Microsoft Dataverse integration, providing access to all of the Microsoft Dataverse data and meta-data needed by enterprise integration or analytics projects. Each driver contains a powerful embedded SQL engine that offers applications easy and high-performance access to all Microsoft Dataverse data. In addition, our drivers offer robust authentication and security capabilities, allowing users to connect securely across a wide range of enterprise configurations. Compare drivers and connectors to read more about some of the benefits of CData's driver connectivity.

With our drivers and connectors, every data source is essentially SQL-based. The CData Microsoft Dataverse driver contains a full SQL-92 compliant engine that translates standard SQL queries into Microsoft Dataverse API calls dynamically. Queries are parsed and optimized for each data source, pushing down as much of the request to Microsoft Dataverse as possible. Any logic that can not be pushed to Microsoft Dataverse is handled transparently client-side by the driver/connector engine. Ultimately, this means that Microsoft Dataverse looks and acts exactly like a database to any client application or tool. Users can integrate live Microsoft Dataverse connectivity with ANY software solution that can talk to a standard database.

The Microsoft Dataverse drivers and connectors offer comprehensive access to Microsoft Dataverse data. Our Microsoft Dataverse driver exposes static and dynamic data and metadata, providing universal access to Microsoft Dataverse data for any enterprise analytics or data mangement use. To explore the Microsoft Dataverse driver data model, please review the edition-specific Microsoft Dataverse driver documentation.

Using the CData Microsoft Dataverse drivers and connectors, Microsoft Dataverse can be easily integrated with almost any application. Any software or technology that can integrate with a database or connect with standards-based drivers like ODBC, JDBC, ADO.NET, etc., can use our drivers for live Microsoft Dataverse data connectivity. Explore some of the more popular Microsoft Dataverse data integrations online.

Additionally, since Microsoft Dataverse supported by CData Connect Cloud, we enable all kinds of new Microsoft Dataverse cloud integrations.

Microsoft Dataverse Analytics and Microsoft Dataverse Cloud BI integration is universally supported for BI and data science. In addition, CData provides native client connectors for popular analytics applications like Power BI, Tableau, and Excel that simplify Microsoft Dataverse data integration. Additionally, native Python connectors are widely available for data science and data engineering projects that integrate seamlessly with popular tools like Pandas, SQLAlchemy, Dash, and Petl.

Microsoft Dataverse data integration is typically enabled with CData Sync, a robust any-to-any data pipeline solution that is easy to set up, runs everywhere, and offers comprehensive enterprise-class features for data engineering. CData Sync makes it easy to replicate Microsoft Dataverse data any database or data warehouse, and maintain parity between systems with automated incremental Microsoft Dataverse replication. In addition, our Microsoft Dataverse drivers and connectors can be easily embedded into a wide range of data integration tools to augment existing solutions.

Absolutely. The best way to integrate Microsoft Dataverse with Excel is by using the CData Connect Cloud Excel Add-In. The Microsoft Dataverse Excel Add-In provides easy Microsoft Dataverse integration directly from Microsoft Excel Desktop, Mac, or Web (Excel 365). Simply configure your connection to Microsoft Dataverse from the easy-to-use cloud interface, and access Microsoft Dataverse just like you would another native Excel data source.



Industry-Leading Support

Support is not just a part of our business, support is our business. Whenever you need help, please consult the resources below: