CData Software - Knowledge Base



Recent Office 365 Articles

ETL Office 365 in Oracle Data Integrator

This article shows how to transfer Microsoft Office 365 into a data warehouse using Oracle Data Integrator.

Visualize Office 365 in TIBCO Spotfire through ADO.NET

Integrate Microsoft Office 365 into dashboards in TIBCO Spotfire.

Visualize Office 365 from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft Office 365.

Deploy the ADO.NET Provider for Office 365 on an SSRS Report Server

Connect to Microsoft Office 365 from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Connect to Office 365 in NetBeans

Connect to Microsoft Office 365 in NetBeans with the data source configuration wizard.

DataBind Wijmo Grid to Office 365

Provide real-time Microsoft Office 365 to interactive controls.

How to connect to Office 365 in DBVisualizer

Integrate Microsoft Office 365 with visual data analysis tools and data connection wizards in DBVisualizer

Analyze Office 365 with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Office 365 from Power Pivot. You will use the Table Import Wizard to load Microsoft Office 365. You can visually build the import query or use any SQL supported by the driver.

Edit and Search External Office 365 Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Microsoft Office 365 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Office 365 objects that you can access from apps and the dashboard.

How to use SQLAlchemy ORM to access Office 365 in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Office 365.

Connect to Office 365 from Asprova with CData Software ODBC Driver for Office 365

This article shows how to connect faster to Office 365 data from Asprova.

How to publish and share Office 365 dashboards with Tableau Server

The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.

Connect to Office 365 from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Microsoft Office 365 and execute queries in PowerBuilder.

Connect to Office 365 in CloverDX (formerly CloverETL)

Transfer Microsoft Office 365 using the visual workflow in the CloverDX data integration tool.

Import and Visualize Office 365 in Power View

Create data visualizations based on Microsoft Office 365 in Excel.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Office 365

Provide connectivity to Microsoft Office 365 through an SAP BusinessObjects universe.

Connect to Office 365 in Jaspersoft Studio

Execute SQL to remote Microsoft Office 365 in Jaspersoft Studio.

Create Apps from Office 365 in Qlik Sense Cloud

Use CData Connect Cloud to connect to Office 365 and build apps from live Microsoft Office 365 in Qlik Sense Cloud.

Analyze Office 365 in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Microsoft Office 365 and visualize Microsoft Office 365 in SAP Analytics Cloud.

Connect to Office 365 through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Microsoft Office 365 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Office 365 objects that you can access from apps and the dashboard.

Connect to Office 365 in SpagoBI

Create reports featuring live Microsoft Office 365 in SpagoBI Studio. Host Office 365 reports on SpagoBI Server.

Load Office 365 to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Office 365 to a database.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Office 365

Provide connectivity to Microsoft Office 365 through an SAP BusinessObjects universe.

Manage Office 365 in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Office 365.

Natively Connect to Office 365 in PHP

The CData ODBC driver for Office 365 enables you to create PHP applications with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.

DataBind Office 365 to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Office 365 with the DevExpress Windows Forms and Web controls to provide Microsoft Office 365 to a chart.

DataBind Controls to Office 365 in Delphi

DataBind to Microsoft Office 365 in Delphi with standard data access components and controls.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Use CData Connect Cloud to Access Office 365 in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Microsoft Office 365 in the Power Pivot business intelligence tool.

Viewing Office 365 in RAD Studio Data Explorer

How to view Microsoft Office 365 in RAD Studio Data Explorer using the CData ODBC Driver for Office 365.

Connect to Office 365 as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Office 365.

Connect to Office 365 in DBArtisan

Use wizards in DBArtisan to configure Microsoft Office 365 as a data source.

Create Informatica Mappings From/To an ODBC Data Source for Office 365

Create an ODBC connection to Office 365 in Informatica and browse and transfer Microsoft Office 365.

How to Use a Microsoft Access Database to Update Office 365 in Real Time

Update Office 365 data by creating a linked table in Microsoft Access with the CData Office 365 ODBC Driver.

Create Informatica Mappings From/To a JDBC Data Source for Office 365

Create Office 365 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Access Office 365 as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Office 365 from your Oracle system.

Automate Office 365 Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Microsoft Office 365 from PowerShell? This article demonstrates how to utilize the Office 365 Cmdlets for tasks like connecting to Microsoft Office 365, automating operations, downloading data, and more.

How to create Office 365 federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Office 365 in MySQL .

How to Connect to & Open Office 365 in Microsoft Excel

This article uses the CData ODBC driver for Office 365 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Build MVC Applications with Connectivity to Office 365

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Office 365 from an ASP.NET MVC application.

Query Office 365 in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Office 365.

How to Visualize Office 365 Data in Python with pandas

Use pandas and other modules to analyze and visualize live Microsoft Office 365 in Python.

Build Dashboards with Office 365 in Dundas BI

Create dynamic dashboards and perform analytics based on Microsoft Office 365 in Dundas BI.

Use the CData ODBC Driver for Office 365 in SAS JMP

You can use the CData ODBC Driver to integrate Microsoft Office 365 into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Office 365 in the Graph Builder and Query Builder.

Visualize Office 365 in TIBCO Spotfire through OData

Integrate Microsoft Office 365 into dashboards in TIBCO Spotfire.

Analyze Office 365 in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Microsoft Office 365 and visualize live Microsoft Office 365 in Infragistics Reveal.

Configure the CData JDBC Driver for Office 365 in a Connection Pool in Tomcat

Connect to Microsoft Office 365 from a connection pool in Tomcat.

How to connect to Office 365 with Squirrel SQL client

Connect to Microsoft Office 365 and execute queries in the Squirrel SQL Client.

How to connect to Office 365 from IntelliJ

Integrate connectivity to Microsoft Office 365 with wizards in IntelliJ.

Connect to Office 365 in Aqua Data Studio

Access Microsoft Office 365 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to create Visio diagrams from Office 365

Automatically update Microsoft Office 365 with the changes you make to Visio master shapes.

Connect to Office 365 in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Office 365 and connect to Microsoft Office 365 in Akorbi Digital RunMyProcess.

Connect to and Visualize Live Office 365 in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Office 365.

Publish Crystal Reports on Office 365

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Office 365.

Integrate Office 365 in the Pentaho Report Designer

Publish reports based on Microsoft Office 365 in the Pentaho BI tool.

Access Office 365 in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Office 365.

Using Cookie-Based Authentication with the CData SharePoint Data Provider.

The SharePoint Data Provider offers connectivity with an on-premise SharePoint Server as well as SharePoint Online and Office 365. This walk-through demonstrates how to properly authenticate and connect to SharePoint Online / Office 365.

Explore Geographical Relationships in Office 365 with Power Map

Create data visualizations with Microsoft Office 365 in Power Map.

Establish a Live Connection with Office 365 using Tableau Bridge

The CData ODBC Driver for Office 365 enables you to integrate live Microsoft Office 365 into Tableau Cloud dashboards using the Tableau Bridge.

Visualize Office 365 in Tableau

The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.

Back Up Microsoft Office 365 to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Office 365. In this article, we will employ an SSIS workflow to populate a database with Microsoft Office 365 data.

Build an OLAP Cube in SSAS from Office 365

Establish a connection to Microsoft Office 365 data from SQL Server Analysis Services, and use the Office 365 Data Provider to build OLAP cubes for use in analytics and reporting.

Create SSAS Tabular Models from Office 365

How to build a SQL Server Analysis Service Tabular Model from Microsoft Office 365 using CData drivers.

PowerShell Scripting to Replicate Office 365 to MySQL

Write a simple PowerShell script to replicate Microsoft Office 365 to a MySQL database.

Use the CData ODBC Driver for Office 365 from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Microsoft Office 365 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Office 365 in Excel.

How to Connect DBeaver to Office 365 via a JDBC Driver

Manage Microsoft Office 365 with visual tools in DBeaver like the query browser.

Import Office 365 into FileMaker Pro

Create reports that integrate Microsoft Office 365 in Filemaker Pro.

Design BIRT Reports on Office 365

Provide current Microsoft Office 365 to your embedded analytics.

Build Charts with Office 365 in Clear Analytics

Create dynamic charts and perform analytics based on Microsoft Office 365 in Clear Analytics.

Connect to Office 365 from a Connection Pool in WebLogic

Use the CData JDBC Driver for Office 365 to connect to Microsoft Office 365 from Web applications running on WebLogic.

Connect to Office 365 in Ruby

Connect to Microsoft Office 365 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to Build Dynamic React Apps with Office 365

Use the CData Connect and React to Build Dynamic Web Apps with Live Office 365 .

Build a Simple VCL Application for Office 365

How to build a simple VCL Application to view Microsoft Office 365 in RAD Studio using the CData ODBC Driver for Office 365.

Object-Relational Mapping (ORM) with Office 365 Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft Office 365 into a Java-based ORM framework, Hibernate.

How to Build an ETL App for Office 365 in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Office 365 in Python with petl.

Connect to Office 365 in RazorSQL

Connect to Office 365 from wizards and query Microsoft Office 365 from the GUI in the RazorSQL database management tool.

Connect to Office 365 from a Connection Pool in Jetty

The Office 365 JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Office 365 from Web apps in Jetty.

Visualize Office 365 in Sisense

Create an ElastiCube in Sisense app with access to Microsoft Office 365.

Visualize Office 365 in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Office 365 into TIBCO Spotfire.

How to connect PolyBase to Office 365

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Office 365.

Work with Office 365 in FoxPro

Load Microsoft Office 365 into a FoxPro database. This article includes full code and a walk-through of the process.

Connect to Live Office 365 in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Office 365 in CData Connect Cloud and connect to your Microsoft Office 365 from PostgreSQL.

Extract, Transform, and Load Office 365 in Informatica PowerCenter

Create a simple Workflow for Microsoft Office 365 in Informatica PowerCenter.

Working with Office 365 in LINQPad

Execute LINQ queries to Microsoft Office 365 in LINQPad.

Use Dash to Build to Web Apps on Office 365

Create Python applications that use pandas and Dash to build Office 365-connected web apps.

Connect to Office 365 in JRuby

Create a simple JRuby app with access to live Microsoft Office 365.

Publish Office 365-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Office 365.

Create Data Visualizations in Cognos BI with Office 365

Access Microsoft Office 365 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Connect to Office 365 in Google Apps Script

Use the ODBC Driver for Office 365 and the SQL Gateway to access Microsoft Office 365 from Google Apps Script.

Export Data from SQL Server to Office 365 through SSIS

Easily push SQL Server data to Office 365 using the CData SSIS Tasks for Office 365.

How to Access Office 365 Using Entity Framework

This article shows how to access Microsoft Office 365 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

How to Import Office 365 into SQL Server using SSIS

Easily back up Microsoft Office 365 to SQL Server using the SSIS components for Office 365.

Connect to Office 365 in Google Apps Script

Use CData Connect Cloud to access Microsoft Office 365 in Google Apps Script.

How to update Office 365 from Excel

This article explains how to transfer data from Excel to Office 365 using the Excel Add-In for Office 365.

How to Connect to Office 365 in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Microsoft Office 365. Leverage the pyodbc module for ODBC in Python.

Natively Connect to Office 365 in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.

Connect to Office 365 from PowerBuilder

This article demonstrates how to access Microsoft Office 365 from Appeon PowerBuilder using the CData ADO.NET Provider for Office 365.

Integrate with Office 365 in JReport Designer

Create charts and reports based on Microsoft Office 365 in JReport Designer.

Using AngularJS to Build Dynamic Web Pages with Office 365

Use the CData Connect Server to create Office 365 OData feeds and build single-page applications with live Microsoft Office 365.

Build Dashboards with Office 365 in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Office 365 in DBxtra.

Create Dynamic Office 365 Grids Using the Infragistics XamDataGrid

Learn how you can connect Office 365 to Infragistics XamDataGrid to build dynamic grids.

Integrating Office 365 in Talend Cloud Data Management Platform

Connect Office 365 with Talend Cloud Data Management Platform using the [product_name].

Connect to Office 365 from a Connection Pool in JBoss

Integrate Microsoft Office 365 into Java servlets: Use the Management Console in JBoss to install the Office 365 JDBC Driver.

Connect to Office 365 in RapidMiner

Integrate Microsoft Office 365 with standard components and data source configuration wizards in RapidMiner Studio.

Connect to Office 365 from PowerBuilder

This article demonstrates how to access Microsoft Office 365 from PowerBuilder using the Office 365 JDBC Driver.

LINQ to Office 365

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Office 365 Data Provider.

Using the CData Software ODBC Driver for Office 365 in PyCharm

Connect to Office 365 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Office 365.

Publish Office 365-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Microsoft Office 365.

Visualize Live Office 365 in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Office 365.

Provide OData Services of Office 365 from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Microsoft Office 365 by developing a WCF Service Application.

Feed Office 365 into FineReport

How to set Microsoft Office 365 as a JDBC data source in FineReport.

Connect to and Query Office 365 in QlikView over ODBC

Create data visualizations with Microsoft Office 365 in QlikView.

Bidirectional Access to Office 365 from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Office 365 in Filemaker Pro for Mac or Windows.

Publish Reports with Office 365 in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.

Create Reports with Office 365 in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.

DataBind Controls to Office 365 in C++Builder

DataBind to Microsoft Office 365 in C++Builder with standard components and controls.

Replicate Office 365 from PowerShell

Write a quick PowerShell script to query Microsoft Office 365. Use connectivity to the live data to replicate Microsoft Office 365 to SQL Server.

Enable the Office 365 JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Microsoft Office 365.

ETL Office 365 in Oracle Data Integrator

This article shows how to transfer Microsoft Office 365 into a data warehouse using Oracle Data Integrator.

Visualize Office 365 in TIBCO Spotfire through ADO.NET

Integrate Microsoft Office 365 into dashboards in TIBCO Spotfire.

Visualize Office 365 from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft Office 365.

Deploy the ADO.NET Provider for Office 365 on an SSRS Report Server

Connect to Microsoft Office 365 from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Connect to Office 365 in NetBeans

Connect to Microsoft Office 365 in NetBeans with the data source configuration wizard.

DataBind Wijmo Grid to Office 365

Provide real-time Microsoft Office 365 to interactive controls.

How to connect to Office 365 in DBVisualizer

Integrate Microsoft Office 365 with visual data analysis tools and data connection wizards in DBVisualizer

Analyze Office 365 with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Office 365 from Power Pivot. You will use the Table Import Wizard to load Microsoft Office 365. You can visually build the import query or use any SQL supported by the driver.

Edit and Search External Office 365 Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Microsoft Office 365 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Office 365 objects that you can access from apps and the dashboard.

How to use SQLAlchemy ORM to access Office 365 in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Office 365.

Connect to Office 365 from Asprova with CData Software ODBC Driver for Office 365

This article shows how to connect faster to Office 365 data from Asprova.

How to publish and share Office 365 dashboards with Tableau Server

The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.

Connect to Office 365 from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Microsoft Office 365 and execute queries in PowerBuilder.

Connect to Office 365 in CloverDX (formerly CloverETL)

Transfer Microsoft Office 365 using the visual workflow in the CloverDX data integration tool.

Import and Visualize Office 365 in Power View

Create data visualizations based on Microsoft Office 365 in Excel.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Office 365

Provide connectivity to Microsoft Office 365 through an SAP BusinessObjects universe.

Connect to Office 365 in Jaspersoft Studio

Execute SQL to remote Microsoft Office 365 in Jaspersoft Studio.

Create Apps from Office 365 in Qlik Sense Cloud

Use CData Connect Cloud to connect to Office 365 and build apps from live Microsoft Office 365 in Qlik Sense Cloud.

Analyze Office 365 in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Microsoft Office 365 and visualize Microsoft Office 365 in SAP Analytics Cloud.

Connect to Office 365 through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Microsoft Office 365 to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Office 365 objects that you can access from apps and the dashboard.

Connect to Office 365 in SpagoBI

Create reports featuring live Microsoft Office 365 in SpagoBI Studio. Host Office 365 reports on SpagoBI Server.

Load Office 365 to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Microsoft Office 365 to a database.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Office 365

Provide connectivity to Microsoft Office 365 through an SAP BusinessObjects universe.

Manage Office 365 in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Office 365.

Natively Connect to Office 365 in PHP

The CData ODBC driver for Office 365 enables you to create PHP applications with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.

DataBind Office 365 to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for Office 365 with the DevExpress Windows Forms and Web controls to provide Microsoft Office 365 to a chart.

DataBind Controls to Office 365 in Delphi

DataBind to Microsoft Office 365 in Delphi with standard data access components and controls.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Use CData Connect Cloud to Access Office 365 in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Microsoft Office 365 in the Power Pivot business intelligence tool.

Viewing Office 365 in RAD Studio Data Explorer

How to view Microsoft Office 365 in RAD Studio Data Explorer using the CData ODBC Driver for Office 365.

Connect to Office 365 as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Microsoft Office 365.

Connect to Office 365 in DBArtisan

Use wizards in DBArtisan to configure Microsoft Office 365 as a data source.

Create Informatica Mappings From/To an ODBC Data Source for Office 365

Create an ODBC connection to Office 365 in Informatica and browse and transfer Microsoft Office 365.

How to Use a Microsoft Access Database to Update Office 365 in Real Time

Update Office 365 data by creating a linked table in Microsoft Access with the CData Office 365 ODBC Driver.

Create Informatica Mappings From/To a JDBC Data Source for Office 365

Create Office 365 data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

Access Office 365 as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Microsoft Office 365 from your Oracle system.

Automate Office 365 Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Microsoft Office 365 from PowerShell? This article demonstrates how to utilize the Office 365 Cmdlets for tasks like connecting to Microsoft Office 365, automating operations, downloading data, and more.

How to create Office 365 federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Microsoft Office 365 in MySQL .

How to Connect to & Open Office 365 in Microsoft Excel

This article uses the CData ODBC driver for Office 365 to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Build MVC Applications with Connectivity to Office 365

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Office 365 from an ASP.NET MVC application.

Query Office 365 in ColdFusion

Write standard ColdFusion data access code to connect to Microsoft Office 365.

How to Visualize Office 365 Data in Python with pandas

Use pandas and other modules to analyze and visualize live Microsoft Office 365 in Python.

Build Dashboards with Office 365 in Dundas BI

Create dynamic dashboards and perform analytics based on Microsoft Office 365 in Dundas BI.

Use the CData ODBC Driver for Office 365 in SAS JMP

You can use the CData ODBC Driver to integrate Microsoft Office 365 into the statistical analysis tools available in SAS JMP. This article shows how to use Microsoft Office 365 in the Graph Builder and Query Builder.

Visualize Office 365 in TIBCO Spotfire through OData

Integrate Microsoft Office 365 into dashboards in TIBCO Spotfire.

Analyze Office 365 in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Microsoft Office 365 and visualize live Microsoft Office 365 in Infragistics Reveal.

Configure the CData JDBC Driver for Office 365 in a Connection Pool in Tomcat

Connect to Microsoft Office 365 from a connection pool in Tomcat.

How to connect to Office 365 with Squirrel SQL client

Connect to Microsoft Office 365 and execute queries in the Squirrel SQL Client.

How to connect to Office 365 from IntelliJ

Integrate connectivity to Microsoft Office 365 with wizards in IntelliJ.

Connect to Office 365 in Aqua Data Studio

Access Microsoft Office 365 from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

How to create Visio diagrams from Office 365

Automatically update Microsoft Office 365 with the changes you make to Visio master shapes.

Connect to Office 365 in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Office 365 and connect to Microsoft Office 365 in Akorbi Digital RunMyProcess.

Connect to and Visualize Live Office 365 in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Microsoft Office 365.

Publish Crystal Reports on Office 365

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Microsoft Office 365.

Integrate Office 365 in the Pentaho Report Designer

Publish reports based on Microsoft Office 365 in the Pentaho BI tool.

Access Office 365 in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Microsoft Office 365.

Using Cookie-Based Authentication with the CData SharePoint Data Provider.

The SharePoint Data Provider offers connectivity with an on-premise SharePoint Server as well as SharePoint Online and Office 365. This walk-through demonstrates how to properly authenticate and connect to SharePoint Online / Office 365.

Explore Geographical Relationships in Office 365 with Power Map

Create data visualizations with Microsoft Office 365 in Power Map.

Establish a Live Connection with Office 365 using Tableau Bridge

The CData ODBC Driver for Office 365 enables you to integrate live Microsoft Office 365 into Tableau Cloud dashboards using the Tableau Bridge.

Visualize Office 365 in Tableau

The CData ODBC driver for Office 365 enables you integrate Microsoft Office 365 into Tableau dashboards.

Back Up Microsoft Office 365 to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Office 365. In this article, we will employ an SSIS workflow to populate a database with Microsoft Office 365 data.

Build an OLAP Cube in SSAS from Office 365

Establish a connection to Microsoft Office 365 data from SQL Server Analysis Services, and use the Office 365 Data Provider to build OLAP cubes for use in analytics and reporting.

Create SSAS Tabular Models from Office 365

How to build a SQL Server Analysis Service Tabular Model from Microsoft Office 365 using CData drivers.

PowerShell Scripting to Replicate Office 365 to MySQL

Write a simple PowerShell script to replicate Microsoft Office 365 to a MySQL database.

Use the CData ODBC Driver for Office 365 from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Office 365 to connect to Microsoft Office 365 from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Microsoft Office 365 in Excel.

How to Connect DBeaver to Office 365 via a JDBC Driver

Manage Microsoft Office 365 with visual tools in DBeaver like the query browser.

Import Office 365 into FileMaker Pro

Create reports that integrate Microsoft Office 365 in Filemaker Pro.

Design BIRT Reports on Office 365

Provide current Microsoft Office 365 to your embedded analytics.

Build Charts with Office 365 in Clear Analytics

Create dynamic charts and perform analytics based on Microsoft Office 365 in Clear Analytics.

Connect to Office 365 from a Connection Pool in WebLogic

Use the CData JDBC Driver for Office 365 to connect to Microsoft Office 365 from Web applications running on WebLogic.

Connect to Office 365 in Ruby

Connect to Microsoft Office 365 in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to Build Dynamic React Apps with Office 365

Use the CData Connect and React to Build Dynamic Web Apps with Live Office 365 .

Build a Simple VCL Application for Office 365

How to build a simple VCL Application to view Microsoft Office 365 in RAD Studio using the CData ODBC Driver for Office 365.

Object-Relational Mapping (ORM) with Office 365 Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Microsoft Office 365 into a Java-based ORM framework, Hibernate.

How to Build an ETL App for Office 365 in Python with CData

Create ETL applications and real-time data pipelines for Microsoft Office 365 in Python with petl.

Connect to Office 365 in RazorSQL

Connect to Office 365 from wizards and query Microsoft Office 365 from the GUI in the RazorSQL database management tool.

Connect to Office 365 from a Connection Pool in Jetty

The Office 365 JDBC Driver supports connection pooling: This article shows how to connect faster to Microsoft Office 365 from Web apps in Jetty.

Visualize Office 365 in Sisense

Create an ElastiCube in Sisense app with access to Microsoft Office 365.

Visualize Office 365 in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Microsoft Office 365 into TIBCO Spotfire.

How to connect PolyBase to Office 365

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Microsoft Office 365.

Work with Office 365 in FoxPro

Load Microsoft Office 365 into a FoxPro database. This article includes full code and a walk-through of the process.

Connect to Live Office 365 in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Office 365 in CData Connect Cloud and connect to your Microsoft Office 365 from PostgreSQL.

Extract, Transform, and Load Office 365 in Informatica PowerCenter

Create a simple Workflow for Microsoft Office 365 in Informatica PowerCenter.

Working with Office 365 in LINQPad

Execute LINQ queries to Microsoft Office 365 in LINQPad.

Use Dash to Build to Web Apps on Office 365

Create Python applications that use pandas and Dash to build Office 365-connected web apps.

Connect to Office 365 in JRuby

Create a simple JRuby app with access to live Microsoft Office 365.

Publish Office 365-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Microsoft Office 365.

Create Data Visualizations in Cognos BI with Office 365

Access Microsoft Office 365 as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

Connect to Office 365 in Google Apps Script

Use the ODBC Driver for Office 365 and the SQL Gateway to access Microsoft Office 365 from Google Apps Script.

Export Data from SQL Server to Office 365 through SSIS

Easily push SQL Server data to Office 365 using the CData SSIS Tasks for Office 365.

How to Access Office 365 Using Entity Framework

This article shows how to access Microsoft Office 365 using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

How to Import Office 365 into SQL Server using SSIS

Easily back up Microsoft Office 365 to SQL Server using the SSIS components for Office 365.

Connect to Office 365 in Google Apps Script

Use CData Connect Cloud to access Microsoft Office 365 in Google Apps Script.

How to update Office 365 from Excel

This article explains how to transfer data from Excel to Office 365 using the Excel Add-In for Office 365.

How to Connect to Office 365 in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Microsoft Office 365. Leverage the pyodbc module for ODBC in Python.

Natively Connect to Office 365 in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Microsoft Office 365. Leverage the native support for ODBC in PHP.

Connect to Office 365 from PowerBuilder

This article demonstrates how to access Microsoft Office 365 from Appeon PowerBuilder using the CData ADO.NET Provider for Office 365.

Integrate with Office 365 in JReport Designer

Create charts and reports based on Microsoft Office 365 in JReport Designer.

Using AngularJS to Build Dynamic Web Pages with Office 365

Use the CData Connect Server to create Office 365 OData feeds and build single-page applications with live Microsoft Office 365.

Build Dashboards with Office 365 in DBxtra

Create dynamic dashboards and perform analytics based on Microsoft Office 365 in DBxtra.

Create Dynamic Office 365 Grids Using the Infragistics XamDataGrid

Learn how you can connect Office 365 to Infragistics XamDataGrid to build dynamic grids.

Integrating Office 365 in Talend Cloud Data Management Platform

Connect Office 365 with Talend Cloud Data Management Platform using the [product_name].

Connect to Office 365 from a Connection Pool in JBoss

Integrate Microsoft Office 365 into Java servlets: Use the Management Console in JBoss to install the Office 365 JDBC Driver.

Connect to Office 365 in RapidMiner

Integrate Microsoft Office 365 with standard components and data source configuration wizards in RapidMiner Studio.

Connect to Office 365 from PowerBuilder

This article demonstrates how to access Microsoft Office 365 from PowerBuilder using the Office 365 JDBC Driver.

LINQ to Office 365

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Office 365 Data Provider.

Using the CData Software ODBC Driver for Office 365 in PyCharm

Connect to Office 365 as an ODBC data source in PyCharm using the CData Software ODBC Driver for Office 365.

Publish Office 365-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Microsoft Office 365.

Visualize Live Office 365 in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Microsoft Office 365.

Provide OData Services of Office 365 from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Microsoft Office 365 by developing a WCF Service Application.

Feed Office 365 into FineReport

How to set Microsoft Office 365 as a JDBC data source in FineReport.

Connect to and Query Office 365 in QlikView over ODBC

Create data visualizations with Microsoft Office 365 in QlikView.

Bidirectional Access to Office 365 from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Microsoft Office 365 in Filemaker Pro for Mac or Windows.

Publish Reports with Office 365 in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Microsoft Office 365.