Microsoft Exchange Integration Guides and Tutorials

Ready to get started?

Learn more:

Microsoft Exchange Connectivity Solutions


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 QuickSightConnect CloudBuild Interactive Dashboards from Microsoft Exchange in Amazon QuickSight
Aqua Data StudioJDBCConnect to Microsoft Exchange in Aqua Data Studio
AWS DatabricksJDBCProcess & Analyze Microsoft Exchange Data in Databricks (AWS)
Azure Analysis ServicesConnect CloudModel Microsoft Exchange Data Using Azure Analysis Services
BirstJDBCBuild Visualizations of Microsoft Exchange in Birst
BIRTJDBCDesign BIRT Reports on Microsoft Exchange
Clear AnalyticsODBCBuild Charts with Microsoft Exchange in Clear Analytics
Cognos Analytics (On-Prem)Connect CloudAnalyze Microsoft Exchange Data in Cognos Analytics
DBxtraODBCBuild Dashboards with Microsoft Exchange in DBxtra
DomoODBCCreate Datasets from Microsoft Exchange in Domo Workbench
Dundas BIODBCBuild Dashboards with Microsoft Exchange in Dundas BI
Excel (on Mac OS)ODBCWork with Microsoft Exchange Data in MS Excel on Mac OS X
FineReportJDBCFeed Microsoft Exchange into FineReport
Google SheetsConnect CloudAccess Live Microsoft Exchange in Google Sheets
IBM Cognos BIODBCCreate Data Visualizations in Cognos BI with Microsoft Exchange
Infragistics RevealConnect CloudAnalyze Microsoft Exchange Data in Infragistics Reval
JasperServerJDBCCreate Microsoft Exchange Reports on JasperReports Server
Jaspersoft BI SuiteJDBCConnect to Microsoft Exchange in Jaspersoft Studio
JReport DesignerJDBCIntegrate with Microsoft Exchange in JReport Designer
KlipfolioConnect CloudCreate Microsoft Exchange-Connected Visualizations in Klipfolio
KNIMEJDBCEnable the Microsoft Exchange JDBC Driver in KNIME
LINQPadADO.NETWorking with Microsoft Exchange in LINQPad
LookerConnect CloudAnalyze Microsoft Exchange in Looker
Looker StudioConnect CloudCreate Reports from Microsoft Exchange in Looker Studio
MetabaseConnect CloudCreate Interactive Microsoft Exchange-Connected Metabase Dashboards
Microsoft ExcelExcelExcel Spreadsheet Automation with the QUERY Formula
Microsoft Excel 365Connect CloudAccess Live Microsoft Exchange Data in Excel 365
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Microsoft Exchange
MicroStrategyConnect CloudConnect to Live Microsoft Exchange in MicroStrategy through Connect Cloud
MicroStrategyJDBCUse the CData JDBC Driver for Microsoft Exchange in MicroStrategy
Microstrategy DesktopJDBCUse the CData JDBC Driver for Microsoft Exchange in MicroStrategy Desktop
Microstrategy WebJDBCUse the CData JDBC Driver for Microsoft Exchange in MicroStrategy Web
Mode AnalyticsConnect CloudCreate Microsoft Exchange-Connected Visualizations in Mode
OBIEEJDBCMicrosoft Exchange Reporting in OBIEE with the Microsoft Exchange JDBC Driver
pandasPythonUse pandas to Visualize Microsoft Exchange in Python
Pentaho Report DesignerJDBCIntegrate Microsoft Exchange in the Pentaho Report Designer
Power BI DesktopPower BIAuthor Power BI Reports on Real-Time Microsoft Exchange
Power BI ServiceConnect CloudVisualize Live Microsoft Exchange in the Power BI Service
Qlik CloudConnect CloudCreate Apps from Microsoft Exchange in Qlik Sense Cloud
QlikViewODBCConnect to and Query Microsoft Exchange in QlikView over ODBC
RJDBCAnalyze Microsoft Exchange in R (JDBC)
RODBCAnalyze Microsoft Exchange in R (ODBC)
RapidMinerJDBCConnect to Microsoft Exchange in RapidMiner
SAP Analytics CloudConnect CloudAnalyze Microsoft Exchange in SAP Analytics Cloud
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
SASODBCUse the CData ODBC Driver for Microsoft Exchange in SAS for Real-Time Reporting and Analytics
SAS JMPODBCUse the CData ODBC Driver for Microsoft Exchange in SAS JMP
SisenseJDBCVisualize Live Microsoft Exchange in Sisense
Spago BIJDBCConnect to Microsoft Exchange in SpagoBI
TableauTableauVisualize Microsoft Exchange in Tableau Desktop
Tableau CloudConnect CloudBuild Microsoft Exchange Visualizations in Tableau Cloud
Tableau ServerTableauPublish Microsoft Exchange-Connected Dashboards in 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
Zoho AnalyticsConnect CloudCreate Microsoft Exchange-Connect Dashboards in Zoho Analytics

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 AirflowJDBCBridge Microsoft Exchange Connectivity with Apache Airflow
Apache CamelJDBCIntegrate with Microsoft Exchange using Apache Camel
Apache NiFiJDBCBridge Microsoft Exchange Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Microsoft Exchange Data in Apache NiFi
AWS GlueConnect CloudConnect to Microsoft Exchange in AWS Glue Jobs
Azure Data FactoryConnect CloudImport Microsoft Exchange Data Using Azure Data Factory
Azure Data LakeCData SyncAutomated Continuous Microsoft Exchange Replication to Azure Data Lake
Azure SynapseCData SyncAutomated Continuous Microsoft Exchange Replication to Azure Synapse
BIMLSSISUse Biml to Build SSIS Tasks to Replicate Microsoft Exchange to SQL Server
CloverDXJDBCConnect to Microsoft Exchange in CloverDX (formerly CloverETL)
DatabricksCData SyncAutomated Continuous Microsoft Exchange Replication to Databricks
FoxProODBCWork with Microsoft Exchange in FoxPro
Google AlloyDBCData SyncAutomated Continuous Microsoft Exchange Replication to Google AlloyDB
Google BigQueryCData SyncAutomated Continuous Microsoft Exchange Replication to Google BigQuery
Google Cloud SQLCData SyncAutomated Continuous Microsoft Exchange Replication to Google Cloud SQL
Google Data FusionJDBCBuild Microsoft Exchange-Connected ETL Processes in Google Data Fusion
HULFT IntegrateJDBCConnect to Microsoft Exchange in HULFT Integrate
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 ExcelExcelTransfer Data from Excel to Microsoft Exchange
Microsoft Power AutomateConnect CloudBuild Microsoft Exchange-Connected Automated Tasks with Power Automate (Desktop)
Oracle Data IntegratorJDBCETL Microsoft Exchange in Oracle Data Integrator
petlPythonExtract, Transform, and Load Microsoft Exchange in Python
Replicate to CSVPowerShellReplicate Microsoft Exchange to MySQL with PowerShell
SAP HANACData SyncAutomated Continuous Microsoft Exchange Replication to SAP HANA
SingleStoreCData SyncAutomated Continuous Microsoft Exchange Replication to SingleStore
SnapLogicJDBCIntegrate Microsoft Exchange with External Services using SnapLogic
SnowflakeCData SyncAutomated Continuous Microsoft Exchange Replication to Snowflake
SQL Server Linked ServerConnect CloudConnect to Microsoft Exchange as a SQL Server Linked Server
TalendJDBCConnect to Microsoft Exchange and Transfer Data in Talend
UiPath StudioODBCCreate an RPA Flow that Connects to Microsoft Exchange in UiPath Studio
VerticaCData SyncAutomated Continuous Microsoft Exchange Replication to a Vertica Database

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
Apache SparkJDBCWork with Microsoft Exchange in Apache Spark Using SQL
AppSheetConnect CloudCreate Microsoft Exchange-Connected Business Apps in AppSheet
Bubble.ioConnect CloudBuild Microsoft Exchange-Connected Apps in Bubble
ChoreoConnect CloudBuild Custom Apps on Microsoft Exchange Data in Choreo
ColdFusionJDBCQuery Microsoft Exchange in ColdFusion Using JDBC
ColdFusionODBCQuery Microsoft Exchange in ColdFusion Using ODBC
DashPythonUse Dash & Python to Build Web Apps on Microsoft Exchange
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 ProODBCBidirectional Access to Microsoft Exchange from FileMaker Pro
Filemaker Pro (on Mac)JDBCBidirectional Access to Microsoft Exchange from FileMaker Pro (on Mac)
GoODBCWrite a Simple Go Application to work with Microsoft Exchange on Linux
Google Apps ScriptConnect CloudConnect 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
MendixConnect CloudBuild Microsoft Exchange-Connected Apps in Mendix
Microsoft Power AppsConnect CloudIntegrate Live Microsoft Exchange into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Microsoft Exchange in Node.js (via Connect Cloud)
NodeJSJDBCQuery Microsoft Exchange through ODBC in Node.js
OutSystemsConnect CloudCreate Microsoft Exchange-Connected Enterprise Applications in OutSystems
PHPODBCNatively Connect to Microsoft Exchange in PHP
PowerBuilderADO.NETConnect to Microsoft Exchange from PowerBuilder
PowerShellPowerShellPipe Microsoft Exchange to CSV in PowerShell
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
RunMyProcessConnect CloudConnect to Microsoft Exchange in RunMyProcess
RunMyProcess DSECJDBCConnect to Microsoft Exchange in DigitalSuite Studio through RunMyProcess DSEC
ServoyJDBCBuild Microsoft Exchange-Connected Apps in Servoy
Spring BootJDBCAccess Live Microsoft Exchange Data in Spring Boot Apps
SQLAlchemyPythonUse SQLAlchemy ORMs to Access Microsoft Exchange in Python
TomcatJDBCConfigure the CData JDBC Driver for Microsoft Exchange in a Connection Pool in Tomcat
UnqorkConnect CloudCreate Microsoft Exchange-Connected Applications in Unqork
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