Learn more
 

CData Software - Knowledge Base

Recent Excel Articles

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

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

How to update Jira Service Management from Excel

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

Excel Spreadsheet Automation with the QUERY Formula

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

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

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

Access Live Asana in Excel (Desktop)

Use CData Connect Cloud to gain access to live Asana from your Excel spreadsheets.

Explore Geographical Relationships in REST with Power Map

Create data visualizations with REST in Power Map.

Work with Live Square in Power Query

Use CData Connect Cloud to connect to Square and work with live Square in Microsoft Power Query.

Write a Simple Go Application to work with SharePoint Excel Services on Linux

Use CData ODBC drivers and unixODBC to create a simple Go app with live connectivity to SharePoint Excel Services.

Author and Share Power BI Reports on Real-Time Reckon Accounts Hosted

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

Access Live WooCommerce in Excel 365 Online (Excel for the web)

Connect to WooCommerce from Excel 365 Online (Excel for the web) with CData Connect Cloud.

Automated Continuous Excel Replication to Vertica

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

Import SAP into Microsoft Power Query

The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access SAP ERP/NetWeaver. In this article, you will use the OData format to import SAP ERP/NetWeaver into Microsoft Power Query.

Author and Share Power BI Reports on Real-Time Spark

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

Import MarkLogic into Microsoft Power Query

The CData Software Connect Server offers standards-based Web service endpoints that allow a variety of applications to access MarkLogic. In this article, you will use the OData format to import MarkLogic into Microsoft Power Query.

Connect to Excel Online in SpagoBI

Create reports featuring live Microsoft Excel Online in SpagoBI Studio. Host Excel Online reports on SpagoBI Server.