Learn more
 

CData Software - Knowledge Base

Recent Excel ODBC Articles

Excel Spreadsheet Automation with the QUERY Formula

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

Author and Share Power BI Reports on Real-Time LinkedIn Ads

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

How to create an RPA flow for Excel Online in UiPath Studio

Use the Excel Online ODBC Driver to create workflows that access real-time Microsoft Excel Online without any coding.

Explore Geographical Relationships in Exact Online with Power Map

Create data visualizations with Exact Online in Power Map.

Author and Share Power BI Reports on Real-Time Oracle SCM

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

How to create Excel Online federated tables in MySQL

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

Import and Visualize EventBrite in Power View

Create data visualizations based on Eventbrite in Excel.

Explore Geographical Relationships in AlloyDB with Power Map

Create data visualizations with Google AlloyDB in Power Map.

How to connect to Kintone from MS Excel on Mac OS X

Create a Data Source Name in iODBC with the CData ODBC Driver for Kintone and work with Kintone in Microsoft Excel on Mac OS X.

Use the CData ODBC Driver for SQL Server in Microsoft Power Query

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

Use the CData ODBC Driver for Couchbase from SharePoint Excel Services

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

Excel Spreadsheet Automation with the QUERY Formula

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

Author and Share Power BI Reports on Real-Time Microsoft Dataverse

Use the CData ODBC Driver for Microsoft Dataverse to visualize Microsoft Dataverse (CDS) in Power BI Desktop and then upload to the Power BI service.

Explore Geographical Relationships in WordPress with Power Map

Create data visualizations with WordPress in Power Map.