Learn more
 

CData Software - Knowledge Base

Recent Excel ODBC Articles

Use the CData ODBC Driver for Klaviyo from SharePoint Excel Services

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

Use the CData ODBC Driver for Google Data Catalog in Microsoft Power Query

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

Explore Geographical Relationships in Highrise with Power Map

Create data visualizations with Highrise CRM in Power Map.

Excel Spreadsheet Automation with the QUERY Formula

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

Video: Connecting to Google BigQuery Data from Microsoft Excel

This video shows how to use the CData ODBC Driver for Google BigQuery to connect to Google BigQuery. You will create a DSN and then use the Data Connection Wizard in Excel to retrieve BigQuery data.

Use the CData ODBC Driver for Workday from SharePoint Excel Services

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

Use the CData ODBC Driver for Impala from SharePoint Excel Services

This article demonstrates how to use the CData ODBC Driver for Impala to connect to Apache Impala from Excel in on-premises editions of SharePoint. This technique allows SharePoint users to create reports, scorecards, and dashboards featuring Apache Impala 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 Unbounce in Microsoft Power Query

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

Import and Visualize ShipStation in Power View

Create data visualizations based on ShipStation in Excel.

Author and Share Power BI Reports on Real-Time QuickBooks Time

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

How to connect to Google Sheets from MS Excel on Mac OS X

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

Explore Geographical Relationships in Couchbase with Power Map

Create data visualizations with Couchbase in Power Map.

Explore Geographical Relationships in Printify with Power Map

Create data visualizations with Printify in Power Map.

Use the CData ODBC Driver for Sybase IQ in Microsoft Power Query

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