Learn more
 

CData Software - Knowledge Base

Recent Excel Excel Articles

Explore Geographical Relationships in QuickBooks Online with Power Map

Create data visualizations with QuickBooks Online in Power Map.

Author and Share Power BI Reports on Real-Time Harvest

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

Excel Spreadsheet Automation with the QUERY Formula

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

Excel Spreadsheet Automation with the QUERY Formula

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

Use the CData ODBC Driver for Sugar CRM in Microsoft Power Query

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

How to connect to SharePoint Excel Services from Google Apps Script

Use CData Software Connect Server to access SharePoint Excel Services in Google Apps Script.

Author and Share Power BI Reports on Real-Time Excel Online

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

Automated Continuous Excel Online Replication to Databricks

Use CData Sync for automated, continuous, customizable Excel Online replication to Databricks.

Build Visualizations of Excel Online in Birst

Use CData drivers and the Birst Cloud Agent to build real-time visualizations of Microsoft Excel Online in Birst.

Use the CData ODBC Driver for PostgreSQL in Microsoft Power Query

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

How to update Instagram from Excel

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

Analyze Excel in R

Use standard R functions and the development environment of your choice to analyze Microsoft Excel with the CData JDBC Driver for Excel.

Use the CData ODBC Driver for Microsoft Teams from SharePoint Excel Services

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

Import and Visualize Azure DevOps in Power View

Create data visualizations based on Azure DevOps in Excel.

Import and Visualize SAS xpt in Power View

Create data visualizations based on SAS XPORT in Excel.