Model Context Protocol (MCP) finally gives AI models a way to access the business data needed to make them really useful at work. CData MCP Servers have the depth and performance to make sure AI has access to all of the answers.
Try them now for free →Office 365 Data Cloud Connectivity
Explore a compilation of guides and tutorials demonstrating how to establish connections to Office 365 data through CData Connect Cloud using different applications and tools.
CData Connect Cloud provides access to Office 365 data from popular BI, analytics, ETL, and custom applications. In addition to pre-built client tools, CData Connect Cloud enables direct real-time bi-directional integration from a wide range of cloud applications. Below you will find a list of guides and tutorials for integrating with live Office 365 data.
Connect Cloud Integrations
Click below to jump to articles related to specific integration use-case.
- Business Intelligence & Analytics - charting, reports, and more (Tableau, Power BI, Amazon QuickSight, etc.)
- ETL & Replication - moving and replicating data (AWS Glue, Oracle Data Integrator, etc.)
- Data Virtualization - retrieving and manipulating data (DbVisualizer, SQL Server PolyBase, etc.)
- Software Development - developing custom applications (.NET, AngularJS, Ruby, Python, etc.)
- Data Management - managing data (DBArtisan, RazorSQL, SQuirreL, etc.)
- Workflow Automation - building automated workflows (SSIS, Power Automate, etc.)
Business Intelligence & Analytics
ETL & Replication
Product | Article Title |
---|---|
Airbyte | Connect to Office 365 Data in Airbyte ELT Pipelines |
AWS Glue | Build ETL Jobs with Office 365 Data in AWS Glue Jobs |
Azure Data Factory | Import Office 365 Data Using Azure Data Factory |
Google Data Fusion | Build Pipelines with Live Office 365 Data in Google Cloud Data Fusion (CData Connect Cloud) |
Microsoft Power Automate | Build Office 365-Connected Automated Tasks with Power Automate (Desktop) |
SnapLogic | Integration with Office 365 Data in SnapLogic (Connect Cloud) |
SQL Server Linked Server | Connect to Office 365 Data as a SQL Server Linked Server |
Data Virtualization
Product | Article Title |
---|---|
APOS Live Data Gateway | Build Semantic Layer Views for Office 365 Data (Connect Cloud) |
Salesforce Connect | Edit and Search Office 365 External Objects in Salesforce Connect |
Salesforce External Services | Connect to Office 365 through External Services in Salesforce |
SQL Server PolyBase | Connect to Office 365 Data using PolyBase with Connect Cloud |
Software Development
Product | Article Title |
---|---|
AppSheet | Create Office 365-Connected Business Apps in AppSheet |
Bubble.io | Build Office 365-Connected Apps in Bubble |
Choreo | Build Custom Apps on Office 365 Data in Choreo |
Google Apps Script | Connect to Office 365 Data in Google Apps Script |
Jitterbit | Integrate with Live Office 365 Data in Jitterbit |
Mendix | Build Office 365-Connected Apps in Mendix |
Microsoft Power Apps | Integrate Live Office 365 Data into Custom Business Apps Built in Power Apps |
NodeJS | Query Office 365 Data in Node.js (via Connect Cloud) |
OutSystems | Create Office 365-Connected Enterprise Applications in OutSystems |
RunMyProcess | Connect to Office 365 Data in RunMyProcess |
Unqork | Create Office 365-Connected Applications in Unqork |
Data Management
Product | Article Title |
---|---|
HeidiSQL | Connect to Office 365 Data in HeidiSQL |
Workflow Automation
Product | Article Title |
---|---|
Nintex Workflow Cloud | Build Office 365-Connected Workflows in Nintex |
Power Automate | Integrate Office 365 Data into Power Automate Automated Tasks |