Connect to live Office 365 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




BI & Analytics



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

ETL, Replication, & Warehousing



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

Connect your RDBMS or data warehouse with Office 365 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 Office 365 Replication to Amazon Redshift Amazon S3: Automated Continuous Office 365 Replication to Amazon S3 Apache Cassandra: Automated Continuous Office 365 Replication to Apache Cassandra AWS Glue: Connect to Office 365 in AWS Glue Jobs Using JDBC BIML: Use Biml to Build SSIS Tasks to Replicate Office 365 to SQL Server Clover ETL: Connect to Office 365 in CloverETL CSV: Automated Continuous Office 365 Replication to Local Delimited Files IBM DB2: Automated Continuous Office 365 Replication to IBM DB2 FoxPro: Work with Office 365 in FoxPro Google BigQuery: Automated Continuous Office 365 Replication to Google BigQuery Google Cloud SQL: Automated Continuous Office 365 Replication to Google Cloud SQL Heroku / Salesforce Connect: Replicate Office 365 for Use in Salesforce Connect Informatica PowerCenter: Create Informatica Mappings From/To a JDBC Data Source for Office 365 Jaspersoft ETL: Connect to Office 365 in Jaspersoft Studio Microsoft Access: Automated Continuous Office 365 Replication to Microsoft Access Microsoft Azure Tables: Automated Continuous Office 365 Replication to Azure SQL Microsoft Excel: Transfer Data from Excel to Office 365 MongoDB: Automated Continuous Office 365 Replication to MongoDB MySQL: Automated Continuous Office 365 Replication to MySQL Oracle Data Integrator: ETL Office 365 in Oracle Data Integrator Oracle Database: Automated Continuous Office 365 Replication to Oracle PostgreSQL: Automated Continuous Office 365 Replication to PostgreSQL Replicate to CSV: PowerShell Scripting to Replicate Office 365 to MySQL Snowflake: Automated Continuous Office 365 Replication to Snowflake SQL Server: Automated Continuous Office 365 Replication to SQL Server SQLite: Automated Continuous Office 365 Replication to SQLite Talend: Connect to Office 365 and Transfer Data in Talend

Data Management



By supporting popular database protocols like ODBC, JDBC, and ADO.NET, as well as wire-protocol interfaces for SQL Server and MySQL, it is easy to connect to and manage Office 365 data from a wide range of database management applications.

Popular Data Management Tool Integrations




Developer Tools & Technologies



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


When Only the Best Office 365 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: