Dynamics CRM
 

Connect to Dynamics CRM data through easy-to-use, bi-directional drivers.


Integrate with BI, Reporting, Analytics, ETL Tools, and Custom Solutions.


"Excellent stuff. I am finally getting the hang of this and it is brilliant may I add!"

- Mark Couvaras, General Manager, Databarracks



Connect to Microsoft Dynamics CRM Data from Anywhere!

Easily access live Microsoft Dynamics CRM data from BI, Analytics, Reporting, ETL, & Custom Apps.







Dynamics CRM Integration Guides and Tutorials

BI & Analytics


Our drivers offer the fastest and easiest way to connect real-time Dynamics CRM data with BI, analytics, reporting and data visualization technologies. They provide unmatched query performance, comprehensive access to Dynamics CRM 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 Dynamics CRM in Alteryx Designer Amazon QuickSight: Build Interactive Dashboards from Dynamics CRM in Amazon QuickSight Aqua Data Studio: Connect to Dynamics CRM in Aqua Data Studio Birst: Build Visualizations of Dynamics CRM in Birst BIRT: Design BIRT Reports on Dynamics CRM Clear Analytics: Build Charts with Dynamics CRM in Clear Analytics Microsoft Excel: Excel Spreadsheet Automation with the QUERY Formula DBxtra: Build Dashboards with Dynamics CRM in DBxtra Domo: Create Datasets from Dynamics CRM in Domo Workbench Dundas BI: Build Dashboards with Dynamics CRM in Dundas BI FineReport: Feed Dynamics CRM into FineReport Google Data Studio: Create Reports from Dynamics CRM in Google Data Studio IBM Cognos BI: Create Data Visualizations in Cognos BI with Dynamics CRM JasperServer: Create Dynamics CRM Reports on JasperReports Server Jaspersoft BI Suite: Connect to Dynamics CRM in Jaspersoft Studio JReport Designer: Integrate with Dynamics CRM in JReport Designer Klipfolio: Create Dynamics CRM-Connected Visualizations in Klipfolio KNIME: Enable the Dynamics CRM JDBC Driver in KNIME LINQPad: Working with Dynamics CRM in LINQPad Power BI Desktop: Author Power BI Reports on Real-Time Dynamics CRM Power BI Online: Visualize Live Dynamics CRM in the Power BI Service Microsoft SSAS: Build an OLAP Cube in SSAS from Dynamics CRM MicroStrategy: Use the CData JDBC Driver for Dynamics CRM in MicroStrategy OBIEE: Dynamics CRM Reporting in OBIEE with the Dynamics CRM JDBC Driver pandas: Use pandas to Visualize Dynamics CRM in Python Pentaho Report Designer: Integrate Dynamics CRM in the Pentaho Report Designer QlikView: Connect to and Query Dynamics CRM in QlikView over ODBC R: Analyze Dynamics CRM in R RapidMiner : Connect to Dynamics CRM in RapidMiner SAP Business Objects: Create an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics CRM SAP Crystal Reports: Publish Reports with Dynamics CRM in Crystal Reports SAP Lumira: Consume Dynamics CRM OData Feeds in SAP Lumira SAS: Use the CData ODBC Driver for Dynamics CRM in SAS for Real-Time Reporting and Analytics Sisense: Visualize Live Dynamics CRM in Sisense Spago BI: Connect to Dynamics CRM in SpagoBI Tableau: Visualize Dynamics CRM in Tableau Desktop Tableau Online: Build Dynamics CRM Visualizations in Tableau Online Tableau Server: Publish Dynamics CRM-Connected Dashboards in Tableau Server TIBCO Spotfire: Visualize Dynamics CRM in TIBCO Spotfire through ADO.NET TIBCO Spotfire Server: Operational Reporting on Dynamics CRM from Spotfire Server Visio: Link Visio Shapes to Dynamics CRM

ETL, Replication, & Warehousing


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

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


Popular Data Warehousing Integrations


Amazon Redshift: Automated Continuous Dynamics CRM Replication to Amazon Redshift Amazon S3: Automated Continuous Dynamics CRM Replication to Amazon S3 Apache Camel: Integrate with Dynamics CRM using Apache Camel Apache Cassandra: Automated Continuous Dynamics CRM Replication to Apache Cassandra Apache NiFi: Bridge Dynamics CRM Connectivity with Apache NiFi AWS Glue: Connect to Dynamics CRM in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Dynamics CRM to SQL Server CloverDX: Connect to Dynamics CRM in CloverDX (formerly CloverETL) CSV: Automated Continuous Dynamics CRM Replication to Local Delimited Files IBM DB2: Automated Continuous Dynamics CRM Replication to IBM DB2 FoxPro: Work with Dynamics CRM in FoxPro Google BigQuery: Automated Continuous Dynamics CRM Replication to Google BigQuery Google Cloud SQL: Automated Continuous Dynamics CRM Replication to Google Cloud SQL Google Data Fusion: Build Dynamics CRM-Connected ETL Processes in Google Data Fusion Heroku / Salesforce Connect: Replicate Dynamics CRM for Use in Salesforce Connect HULFT Integrate: Connect to Dynamics CRM in HULFT Integrate Informatica Cloud: Integrate Dynamics CRM in Your Informatica Cloud Instance Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Dynamics CRM Jaspersoft ETL: Connect to Dynamics CRM in Jaspersoft Studio Microsoft Access: Automated Continuous Dynamics CRM Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Dynamics CRM Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Dynamics CRM MongoDB: Automated Continuous Dynamics CRM Replication to MongoDB MySQL: Automated Continuous Dynamics CRM Replication to MySQL Oracle Data Integrator: ETL Dynamics CRM in Oracle Data Integrator Oracle Database: Automated Continuous Dynamics CRM Replication to Oracle petl: Extract, Transform, and Load Dynamics CRM in Python PostgreSQL: Automated Continuous Dynamics CRM Replication to PostgreSQL Replicate to CSV: Replicate Dynamics CRM to MySQL with PowerShell Snowflake: Automated Continuous Dynamics CRM Replication to Snowflake SQL Server: Automated Continuous Dynamics CRM Replication to SQL Server SQLite: Automated Continuous Dynamics CRM Replication to SQLite Talend: Connect to Dynamics CRM and Transfer Data in Talend UiPath Studio: Create an RPA Flow that Connects to Dynamics CRM in UiPath Studio

Developer Tools & Technologies


The easiest way to integrate with Dynamics CRM from anywhere. Our Dynamics CRM drivers offer a data-centric model for Dynamics CRM 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 Dynamics CRM .NET QueryBuilder: Rapidly Develop Dynamics CRM-Driven Apps with Active Query Builder Angular JS: Using AngularJS to Build Dynamic Web Pages with Dynamics CRM Apache Spark: Work with Dynamics CRM in Apache Spark Using SQL AppSheet: Create Dynamics CRM-Connected Business Apps in AppSheet Microsoft Azure Logic Apps: Trigger Dynamics CRM IFTTT Flows in Azure App Service ColdFusion: Query Dynamics CRM in ColdFusion Dash: Use Dash & Python to Build Web Apps on Dynamics CRM DevExpress: DataBind Dynamics CRM to the DevExpress Data Grid EF - Code First: Access Dynamics CRM with Entity Framework 6 EF - LINQ: LINQ to Dynamics CRM EF - MVC: Build MVC Applications with Connectivity to Dynamics CRM Filemaker Pro: Bidirectional Access to Dynamics CRM from FileMaker Pro Go: Write a Simple Go Application to work with Dynamics CRM on Linux Google Apps Script: Connect to Dynamics CRM in Google Apps Script Hibernate: Object-Relational Mapping (ORM) with Dynamics CRM Entities in Java IntelliJ: Connect to Dynamics CRM in IntelliJ JBoss: Connect to Dynamics CRM from a Connection Pool in JBoss JDBI: Create a Data Access Object for Dynamics CRM using JDBI JRuby: Connect to Dynamics CRM in JRuby NodeJS: Query Dynamics CRM from Node.js NodeJS: Query Dynamics CRM as a MySQL Database in Node.js NodeJS: Query Dynamics CRM through ODBC in Node.js PHP: Access Dynamics CRM in PHP through the Cloud Hub PHP: Natively Connect to Dynamics CRM in PHP PowerShell: Pipe Dynamics CRM to CSV in PowerShell PowerBuilder: Connect to Dynamics CRM from PowerBuilder PyCharm: Using the CData ODBC Driver for Dynamics CRM in PyCharm Python: Connect to Dynamics CRM in Python on Linux/UNIX Ruby: Connect to Dynamics CRM in Ruby SAP UI5: Integrate Real-Time Access to Dynamics CRM in SAPUI5 MVC Apps Servoy: Build Dynamics CRM-Connected Apps in Servoy SQLAlchemy: Use SQLAlchemy ORMs to Access Dynamics CRM in Python Tomcat: Configure the CData JDBC Driver for Dynamics CRM in a Connection Pool in Tomcat Unqork: Create Dynamics CRM-Connected Applications in Unqork VCL App (RAD Studio): Build a Simple VCL Application for Dynamics CRM WebLogic: Connect to Dynamics CRM from a Connection Pool in WebLogic


When Only the Best Dynamics CRM Drivers Will Do

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





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:

Using the Dynamics CRM Drivers


Other Microsoft Dynamics Drivers