Microsoft Exchange Integration Guides and Tutorials

A list of guides and tutorials for connecting to and working with live Microsoft Exchange data.

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

Back to top

ETL & Replication


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

Back to top

Data Virtualization



Back to top

Software Development


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

Back to top

Data Management



Back to top

Workflow Automation



Back to top