Ready to get started?

Microsoft Exchange Integration Guides and Tutorials



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

CData Software's connectivity tools enable users to connect directly to live Microsoft Exchange data data from widely-used BI, analytics, ETL, and custom applications, ensuring that our customers can access their data wherever they desire. Below, you'll find a collection of guides and tutorials on 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 (ODBC)
Alteryx DesignerConnect CloudWork with Live Microsoft Exchange Data in Alteryx Designer (Connect Cloud)
Amazon QuickSightConnect CloudBuild Interactive Dashboards from Microsoft Exchange Data in Amazon QuickSight
Amazon SageMakerConnect CloudIntegrate Live Microsoft Exchange data into Amazon SageMaker Canvas
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 Data 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 Data in Looker
Looker StudioConnect CloudCreate Reports from Microsoft Exchange Data in Looker Studio
MetabaseConnect CloudCreate Interactive Microsoft Exchange-Connected Metabase Dashboards
Microsoft ExcelConnect CloudAccess Live Microsoft Exchange Data in Excel Desktop
Microsoft Excel for the WebConnect CloudAccess Live Microsoft Exchange Data in Excel for the Web
Microsoft SSASADO.NETBuild an OLAP Cube in SSAS from Microsoft Exchange
MicroStrategyConnect CloudConnect to Live Microsoft Exchange Data 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 Data in the Power BI Service
Power PivotConnect CloudAccess Microsoft Exchange Data in Microsoft Power Pivot
Power QueryConnect CloudAccess Microsoft Exchange Data in Microsoft Power Query
Qlik CloudConnect CloudCreate Apps from Microsoft Exchange Data 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
RedashConnect ServerBuild Microsoft Exchange-Connected Dashboards in Redash
SAP Analytics CloudConnect CloudAnalyze Microsoft Exchange Data 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
SAS ViyaConnect CloudAnalyze Live Microsoft Exchange Data in SAS Viya
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 SpotfireConnect ServerVisualize Microsoft Exchange Data in TIBCO Spotfire
TIBCO Spotfire ServerJDBCOperational Reporting on Microsoft Exchange from Spotfire Server
VisioODBCLink Visio Shapes to Microsoft Exchange
Zoho AnalyticsConnect CloudCreate Microsoft Exchange-Connected Dashboards in Zoho Analytics

Back to top

ETL & Replication


ProductTechnologyArticle Title
AirbyteConnect CloudConnect to Microsoft Exchange Data in Airbyte ELT Pipelines
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 CassandraCData SyncAutomated Continuous Microsoft Exchange Replication to Apache Cassandra
Apache KafkaCData SyncAutomated Continuous Microsoft Exchange Replication to Apache Kafka
Apache NiFiJDBCBridge Microsoft Exchange Connectivity with Apache NiFi
Apache NiFi Batch OperationsJDBCPerform Batch Operations with Microsoft Exchange Data in Apache NiFi
AWS GlueConnect CloudBuild ETL Jobs with Microsoft Exchange Data 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)
CouchbaseCData SyncAutomated Continuous Microsoft Exchange Replication to Couchbase
CSVCData SyncAutomated Continuous Microsoft Exchange Replication to Local Delimited Files
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
Heroku / Salesforce ConnectCData SyncReplicate Microsoft Exchange for Use in Salesforce Connect
HULFT IntegrateJDBCConnect to Microsoft Exchange in HULFT Integrate
IBM DB2CData SyncAutomated Continuous Microsoft Exchange Replication to IBM DB2
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
Microsoft Power AutomateConnect CloudBuild Microsoft Exchange-Connected Automated Tasks with Power Automate (Desktop)
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
petlPythonExtract, Transform, and Load Microsoft Exchange in Python
PostgreSQLCData SyncAutomated Continuous Microsoft Exchange Replication to PostgreSQL
Replicate to MySQLPowerShellReplicate 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 ServerCData SyncAutomated Continuous Microsoft Exchange Replication to SQL Server
SQL Server Linked ServerConnect CloudConnect to Microsoft Exchange Data as a SQL Server Linked 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
VerticaCData SyncAutomated Continuous Microsoft Exchange Replication to a Vertica Database

Back to top

Data Virtualization



Back to top

Software Development


ProductTechnologyArticle Title
AWS LambdaJDBCAccess Live Microsoft Exchange Data in AWS Lambda
.NET ChartsADO.NETDataBind Charts to Microsoft Exchange
.NET QueryBuilderODBCRapidly Develop Microsoft Exchange-Driven Apps with Active Query Builder
Angular JSConnect ServerUsing AngularJS to Build Dynamic Web Pages with Microsoft Exchange
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
C++BuilderODBCDataBind Controls to Microsoft Exchange Data in C++Builder
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
DelphiODBCDataBind Controls to Microsoft Exchange Data in Delphi
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 Data 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 Data into Custom Business Apps Built in Power Apps
NodeJSConnect CloudQuery Microsoft Exchange Data in Node.js (via Connect Cloud)
NodeJSODBCQuery Microsoft Exchange through ODBC in Node.js
OutSystemsConnect CloudCreate Microsoft Exchange-Connected Enterprise Applications in OutSystems
PHPConnect ServerAccess Microsoft Exchange in PHP through Connect Server
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
ReactConnect ServerBuild Dynamic React Apps with Microsoft Exchange Data
RubyODBCConnect to Microsoft Exchange in Ruby
RunMyProcessConnect CloudConnect to Microsoft Exchange Data in RunMyProcess
RunMyProcess DSECJDBCConnect to Microsoft Exchange in DigitalSuite Studio through RunMyProcess DSEC
SAP UI5Connect ServerIntegrate Real-Time Access to Microsoft Exchange in SAPUI5 MVC Apps
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)ODBCBuild 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