CData Software - Knowledge Base



Recent Excel Articles

Use the CData ODBC Driver for ServiceNow from SharePoint Excel Services

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

Work with DB2 in MS Excel on Mac OS X

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

Use the CData ODBC Driver for Dynamics GP in Microsoft Power Query

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

Import Excel Online into the Power BI Service for Visualizations

Use the CData Software Cloud Hub to create an OData feed for Excel Online and create custom reports in the Power BI Service.

Import and Visualize Sybase in Power View

Create data visualizations based on Sybase in Excel.

LINQ to Excel Services

LINQ provides general-purpose query facilities in .NET Framework 3.0 and above and provides one easy way to programmatically access data through from CData ADO.NET Data Providers. This example uses LINQ to access information from the Excel Services Data Provider.

Import and Visualize Azure Data Catalog in Power View

Create data visualizations based on Azure Data Catalog in Excel.

Create Dynamic Excel Grids Using the Infragistics XamDataGrid

Use the CData ADO.NET Provider for Excel and the Infragistics XamDataGrid to build dynamic grids.

Use the CData ODBC Driver for Excel Online in Microsoft Power Query

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

Configure a Solicit-Response Send Port for the CData BizTalk Adapter for Excel Services

Use the adapter for Excel Services with a solicit-response send port to execute updategrams and data manipulation SQL in BizTalk.

Use the CData ODBC Driver for X-Cart in Microsoft Power Query

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