Learn more
 

CData Software - Knowledge Base

Recent Excel ODBC Articles

Import and Visualize Salesforce Pardot in Power View

Create data visualizations based on Salesforce Pardot in Excel.

Excel Spreadsheet Automation with the QUERY Formula

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

Use the CData ODBC Driver for Microsoft OneDrive in Microsoft Power Query

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

Author and Share Power BI Reports on Real-Time SendGrid

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

Use the CData ODBC Driver for SAP Ariba Source in Microsoft Power Query

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

Author and Share Power BI Reports on Real-Time Azure Synapse

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

Author and Share Power BI Reports on Real-Time Zoho Creator

Use the CData ODBC Driver for Zoho Creator to visualize Zoho Creator 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.

Query Excel through ODBC in Node.js

Use node-odbc to execute SQL queries against Microsoft Excel from Node.js.

Author and Share Power BI Reports on Real-Time Clio

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

Use the CData ODBC Driver for Authorize.Net from SharePoint Excel Services

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

Use the CData ODBC Driver for Veeva in Microsoft Power Query

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

Import and Visualize Monday.com in Power View

Create data visualizations based on Monday.com in Excel.

How to publish and share Excel Online dashboards with Tableau Server

The CData ODBC driver for Excel Online enables you integrate Microsoft Excel Online into Tableau dashboards.

Natively Connect to Excel in PHP

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