Learn more
 

CData Software - Knowledge Base

Recent Google Sheets ADO.NET Articles

How to Import Google Sheets into SQL Server using SSIS

Easily back up Google Sheets to SQL Server using the SSIS components for Google Sheets.

LINQ to Google Sheets

LINQ offers versatile querying capabilities within the .NET Framework (v3.0+), offering a straightforward method for programmatic data access through CData ADO.NET Data Providers. In this article, we demonstrate the use of LINQ to retrieve information from the Google Sheets Data Provider.

Provide OData Services of Google Sheets from a WCF Application

In this article, we will demonstrate the process of generating an OData feed for Google Sheets by developing a WCF Service Application.

Back Up Google Sheets to SQL Server through SSIS

Effortlessly backup data to SQL Server by utilizing the CData ADO.NET Provider for Google Sheets. In this article, we will employ an SSIS workflow to populate a database with Google Sheets data.

Export Data from SQL Server to Google Sheets through SSIS

Easily push SQL Server data to Google Sheets using the CData SSIS Tasks for Google Sheets.

Build an OLAP Cube in SSAS from Google Sheets

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

How to Access Google Sheets Using Entity Framework

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

Visualize Google Sheets in TIBCO Spotfire through ADO.NET

Integrate Google Sheets into dashboards in TIBCO Spotfire.

Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid

Learn how you can connect Google Sheets to Infragistics XamDataGrid to build dynamic grids.

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

Connect to Google Sheets 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.