CData Software - Knowledge Base



Recent Office 365 Articles

Import Office 365 Data into SQL Server using SSIS

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

Excel Spreadsheet Automation with the QUERY Formula

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

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 in Jaspersoft Studio

Execute SQL to remote Microsoft Office 365 in Jaspersoft Studio.

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.

Publish Reports with Office 365 in Crystal Reports

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

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.

Import and Visualize Office 365 in Power View

Create data visualizations based on Microsoft Office 365 in Excel.

Build an OLAP Cube in SSAS from Office 365

Connect to Microsoft Office 365 in an Analysis Services project using the Office 365 Data Provider and build OLAP cubes for use in analytics, reporting, and more.

Use SQLAlchemy ORMs to Access Office 365 in Python

The CData Software Python Connector for Office 365 enables you to create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Microsoft Office 365.

Connect to Office 365 in RapidMiner

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