CData Software - Knowledge Base



Recent Excel Articles

Import and Visualize Microsoft Planner in Power View

Create data visualizations based on Microsoft Planner in Excel.

Author and Share Power BI Reports on Real-Time OneNote

Use the CData ODBC Driver for OneNote to visualize Microsoft OneNote in Power BI Desktop and then upload to the Power BI service.

Publish Real-Time Excel Services to PowerBI.com

Connect to the CData Software Power BI Connectors from PowerBI.com to provide real-time datasets across the organization.

Replicate Multiple Excel Accounts

Replicate multiple Excel accounts to one or many databases.

Excel Spreadsheet Automation with the QUERY Formula

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

Load Excel Online data to a DB using OSS ETL/ELT tool Embulk

Use CData JDBC Driver for Excel Online on OSS ETL/ELT tool Embulk to import Excel Online data to a database.

Use the CData ODBC Driver for SQL Server from SharePoint Excel Services

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

Author and Share Power BI Reports on Real-Time FinancialForce

Use the CData ODBC Driver for FinancialForce to visualize FinancialForce in Power BI Desktop and then upload to the Power BI service.

Import and Visualize Google Analytics in Power View

Create data visualizations based on Google Analytics in Excel.

Explore Geographical Relationhips in TaxJar with Power Map

Create data visualizations with TaxJar in Power Map.

Use the CData ODBC Driver for REST in Microsoft Power Query

You can use the CData REST ODBC Driver with Microsoft Power Query. In this article, you will use the ODBC driver to import REST into Microsoft Power Query.