CData Software - Knowledge Base



Recent Excel Articles

Work with Parquet in MS Excel on Mac OS X

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

Transfer Data from Excel to RSS

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

Use Biml to Build SSIS Tasks to Replicate Excel Services to SQL Server

Use Biml to dynamically build SSIS tasks using CData Software SSIS Components to replicate SharePoint Excel Services to SQL Server.

Explore Geographical Relationships in Sage 200 with Power Map

Create data visualizations with Sage 200 in Power Map.

Author and Share Power BI Reports on Real-Time MySQL

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

Explore Geographical Relationships in SAP ByDesign with Power Map

Create data visualizations with SAP Business ByDesign in Power Map.

Use the CData ODBC Driver for SAP Business One DI in Microsoft Power Query

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

Automated Continuous Excel Services Replication to Azure SQL

Use CData Sync for automated, continuous, customizable Excel Services replication to Azure SQL.

Visualize Excel Online from Tableau

Use the Tableau Desktop business intelligence tool to connect to Microsoft Excel Online.

Transfer Data from Excel to Blackbaud FE NXT

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

Use the CData ODBC Driver for DB2 in Microsoft Power Query

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