Read the release
 

CData Software - Knowledge Base



Recent Excel ADO.NET Articles

Export Data from SQL Server to SharePoint Excel Services through SSIS

Easily push SQL Server data to SharePoint Excel Services using the CData SSIS Tasks for SharePoint Excel Services.

Deploy the ADO.NET Provider for Excel Online on an SSRS Report Server

Connect to Microsoft Excel Online from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

DataBind SharePoint Excel Services to the DevExpress Data Grid

Use the CData Software ADO.NET Provider for SharePoint Excel Services with the DevExpress Windows Forms and Web controls to provide SharePoint Excel Services to a chart.

Author and Share Power BI Reports on Real-Time Adobe Analytics

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

Transfer Data from Excel to Adobe Commerce

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

Import Real-Time Excel Online in ColdFusion to Build Applications

Use the CData ODBC Driver for Excel Online to import and use Microsoft Excel Online in ColdFusion.

Use the CData ODBC Driver for Adobe Commerce from SharePoint Excel Services

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

Visualize Excel Online in TIBCO Spotfire through ADO.NET

Integrate Microsoft Excel Online into dashboards in TIBCO Spotfire.

Access Excel Online with Entity Framework 6

This article shows how to access Microsoft Excel Online using an Entity Framework code-first approach. Entity Framework 6 is available in .NET 4.5 and above.

Use the CData ODBC Driver for Adobe Analytics in Microsoft Power Query

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

Create Dynamic Excel Online Grids Using the Infragistics XamDataGrid

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

Deploy the ADO.NET Provider for Excel on an SSRS Report Server

Connect to Microsoft Excel from multiple reports and pick up updates immediately: Create a shared data source on a native mode report server or a report server on a SharePoint farm.

Build an OLAP Cube in SSAS from SharePoint Excel Services

Establish a connection to SharePoint Excel Services data from SQL Server Analysis Services, and use the SharePoint Excel Services Data Provider to build OLAP cubes for use in analytics and reporting.

Visualize SharePoint Excel Services in TIBCO Spotfire through ADO.NET

Integrate SharePoint Excel Services into dashboards in TIBCO Spotfire.

Transfer Data from Excel to Adobe Analytics

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