Ready to get started?

Learn more about Dynamics CRM Connectivity Solutions

Learn More

Dynamics CRM Integration Guides and Tutorials

A list of guides and tutorials for connecting to and working with live Dynamics CRM data.

CData Software connectivity tools provide access to live Dynamics CRM data from popular BI, analytics, ETL, and custom applications, offering our customers access to their data wherever they want. Below you will find a list of guides and tutorials for integrating with live Dynamics CRM data.

Integration Use-Cases

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

Business Intelligence & Analytics


ProductTechnologyArticle Title
Alteryx DesignerODBCPrepare, Blend, and Analyze Dynamics CRM in Alteryx Designer
Amazon QuickSightCloud HubBuild Interactive Dashboards from Dynamics CRM in Amazon QuickSight
Aqua Data StudioJDBCConnect to Dynamics CRM in Aqua Data Studio
BirstJDBCBuild Visualizations of Dynamics CRM in Birst
BIRTJDBCDesign BIRT Reports on Dynamics CRM
Clear AnalyticsODBCBuild Charts with Dynamics CRM in Clear Analytics
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
DBxtraODBCBuild Dashboards with Dynamics CRM in DBxtra
DomoODBCCreate Datasets from Dynamics CRM in Domo Workbench
Dundas BIODBCBuild Dashboards with Dynamics CRM in Dundas BI
FineReportJDBCFeed Dynamics CRM into FineReport
Google Data StudioCloud HubCreate Reports from Dynamics CRM in Google Data Studio
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Dynamics CRM
JasperServerJDBCCreate Dynamics CRM Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Dynamics CRM in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Dynamics CRM in JReport Designer
KlipfolioCloud HubCreate Dynamics CRM-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Dynamics CRM JDBC Driver in KNIME
LINQPadADO.NETWorking with Dynamics CRM in LINQPad
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Dynamics CRM
Power BI OnlineCloud HubVisualize Live Dynamics CRM in the Power BI Service
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Dynamics CRM
MicroStrategyJDBCUse the CData JDBC Driver for Dynamics CRM in MicroStrategy
OBIEEJDBCDynamics CRM Reporting in OBIEE with the Dynamics CRM JDBC Driver
pandasPythonUse pandas to Visualize Dynamics CRM in Python
Pentaho Report DesignerJDBCIntegrate Dynamics CRM in the Pentaho Report Designer
QlikViewODBCConnect to and Query Dynamics CRM in QlikView over ODBC
RJDBCAnalyze Dynamics CRM in R
RapidMiner JDBCConnect to Dynamics CRM in RapidMiner
SAP Business ObjectsJDBCCreate an SAP BusinessObjects Universe on the CData JDBC Driver for Dynamics CRM
SAP Crystal ReportsJDBCPublish Reports with Dynamics CRM in Crystal Reports
SAP LumiraAPI ServerConsume Dynamics CRM OData Feeds in SAP Lumira
SASODBCUse the CData ODBC Driver for Dynamics CRM in SAS for Real-Time Reporting and Analytics
SisenseJDBCVisualize Live Dynamics CRM in Sisense
Spago BIJDBCConnect to Dynamics CRM in SpagoBI
TableauODBCVisualize Dynamics CRM in Tableau
Tableau OnlineCloud HubBuild Dynamics CRM Visualizations in Tableau Online
Tableau ServerODBCPublish and Share Dynamics CRM Dashboards with Tableau Server
TIBCO SpotfireADO.NETVisualize Dynamics CRM in TIBCO Spotfire through ADO.NET
TIBCO Spotfire ServerJDBCOperational Reporting on Dynamics CRM from Spotfire Server
VisioODBCLink Visio Shapes to Dynamics CRM

Back to top

ETL & Replication


ProductTechnologyArticle Title
Amazon RedshiftCData SyncAutomated Continuous Dynamics CRM Replication to Amazon Redshift
Amazon S3CData SyncAutomated Continuous Dynamics CRM Replication to Amazon S3
Apache CamelJDBCIntegrate with Dynamics CRM using Apache Camel
Apache CassandraCData SyncAutomated Continuous Dynamics CRM Replication to Apache Cassandra
Apache NiFiJDBCBridge Dynamics CRM Connectivity with Apache NiFi
AWS GlueJDBCConnect to Dynamics CRM in AWS Glue Jobs Using JDBC
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Dynamics CRM to SQL Server
CloverDXJDBCConnect to Dynamics CRM in CloverDX (formerly CloverETL)
CSVCData SyncAutomated Continuous Dynamics CRM Replication to Local Delimited Files
IBM DB2CData SyncAutomated Continuous Dynamics CRM Replication to IBM DB2
FoxProODBCWork with Dynamics CRM in FoxPro
Google BigQueryCData SyncAutomated Continuous Dynamics CRM Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Dynamics CRM Replication to Google Cloud SQL
Google Data FusionJDBCBuild Dynamics CRM-Connected ETL Processes in Google Data Fusion
Heroku / Salesforce ConnectCData SyncReplicate Dynamics CRM for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Dynamics CRM in HULFT Integrate
Informatica CloudJDBCIntegrate Dynamics CRM in Your Informatica Cloud Instance
Informatica PowerCenterJDBCCreate Informatica Mappings From/To a JDBC Data Source for Dynamics CRM
Jaspersoft ETLJDBCConnect to Dynamics CRM in Jaspersoft Studio
Microsoft AccessCData SyncAutomated Continuous Dynamics CRM Replication to Microsoft Access
Microsoft Azure TablesCData SyncAutomated Continuous Dynamics CRM Replication to Azure SQL
Microsoft ExcelExcelTransfer Data from Excel to Dynamics CRM
MongoDBCData SyncAutomated Continuous Dynamics CRM Replication to MongoDB
MySQLCData SyncAutomated Continuous Dynamics CRM Replication to MySQL
Oracle Data IntegratorJDBCETL Dynamics CRM in Oracle Data Integrator
Oracle DatabaseCData SyncAutomated Continuous Dynamics CRM Replication to Oracle
petlPythonExtract, Transform, and Load Dynamics CRM in Python
PostgreSQLCData SyncAutomated Continuous Dynamics CRM Replication to PostgreSQL
Replicate to CSVPowerShellReplicate Dynamics CRM to MySQL with PowerShell
SnowflakeCData SyncAutomated Continuous Dynamics CRM Replication to Snowflake
SQL ServerCData SyncAutomated Continuous Dynamics CRM Replication to SQL Server
SQLiteCData SyncAutomated Continuous Dynamics CRM Replication to SQLite
TalendJDBCConnect to Dynamics CRM and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Dynamics CRM in UiPath Studio

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
.NET ChartsADO.NETDataBind Charts to Dynamics CRM
.NET QueryBuilderODBCRapidly Develop Dynamics CRM-Driven Apps with Active Query Builder
Angular JSAPI ServerUsing AngularJS to Build Dynamic Web Pages with Dynamics CRM
Apache SparkJDBCWork with Dynamics CRM in Apache Spark Using SQL
AppSheetCloud HubCreate Dynamics CRM-Connected Business Apps in AppSheet
Microsoft Azure Logic AppsAPI ServerTrigger Dynamics CRM IFTTT Flows in Azure App Service
ColdFusionJDBCQuery Dynamics CRM in ColdFusion
DashPythonUse Dash & Python to Build Web Apps on Dynamics CRM
DevExpressADO.NETDataBind Dynamics CRM to the DevExpress Data Grid
EF - Code FirstADO.NETAccess Dynamics CRM with Entity Framework 6
EF - LINQADO.NETLINQ to Dynamics CRM
EF - MVCADO.NETBuild MVC Applications with Connectivity to Dynamics CRM
Filemaker ProJDBCBidirectional Access to Dynamics CRM from FileMaker Pro
GoODBCWrite a Simple Go Application to work with Dynamics CRM on Linux
Google Apps ScriptCloud HubConnect to Dynamics CRM in Google Apps Script
HibernateJDBCObject-Relational Mapping (ORM) with Dynamics CRM Entities in Java
IntelliJJDBCConnect to Dynamics CRM in IntelliJ
JBossJDBCConnect to Dynamics CRM from a Connection Pool in JBoss
JDBIJDBCCreate a Data Access Object for Dynamics CRM using JDBI
JRubyJDBCConnect to Dynamics CRM in JRuby
NodeJSAPI ServerQuery Dynamics CRM from Node.js
NodeJSCloud HubQuery Dynamics CRM as a MySQL Database in Node.js
NodeJSJDBCQuery Dynamics CRM through ODBC in Node.js
PHPCloud HubAccess Dynamics CRM in PHP through the Cloud Hub
PHPODBCNatively Connect to Dynamics CRM in PHP
PowerShellPowerShellPipe Dynamics CRM to CSV in PowerShell
PowerBuilderADO.NETConnect to Dynamics CRM from PowerBuilder
PyCharmODBCUsing the CData ODBC Driver for Dynamics CRM in PyCharm
PythonODBCConnect to Dynamics CRM in Python on Linux/UNIX
RubyODBCConnect to Dynamics CRM in Ruby
SAP UI5API ServerIntegrate Real-Time Access to Dynamics CRM in SAPUI5 MVC Apps
ServoyJDBCBuild Dynamics CRM-Connected Apps in Servoy
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Dynamics CRM in Python
TomcatJDBCConfigure the CData JDBC Driver for Dynamics CRM in a Connection Pool in Tomcat
VCL App (RAD Studio)FireDACBuild a Simple VCL Application for Dynamics CRM
WebLogicJDBCConnect to Dynamics CRM from a Connection Pool in WebLogic

Back to top

Data Management



Back to top

Workflow Automation



Back to top