Read the blog
 

CData Software - Knowledge Base



Recent Google Sheets ADO.NET Articles

Create Dynamic Google Sheets Grids Using the Infragistics XamDataGrid

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

Access Google Sheets with Entity Framework 6

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.

Automate Google Sheets Integration Tasks from PowerShell

Are you looking for a quick and easy way to access Google Sheets from PowerShell? We show how to use the Cmdlets for Google Sheets and the CData ADO.NET Provider for Google Sheets to connect to Google Sheets and synchronize, automate, download, and more.

Connect to Google Sheets from PowerBuilder

This article demonstrates how to access Google Sheets from PowerBuilder using the CData ADO.NET Provider for Google Sheets.

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.

LINQ to Google Sheets

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 Google Sheets Data Provider.

Import Google Sheets Data into SQL Server using SSIS

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

Back Up Google Sheets to SQL Server through SSIS

Easily back up data to SQL Server using the CData ADO.NET Provider for Google Sheets. This example uses an SSIS workflow to populate a database with Google Sheets.

Build an OLAP Cube in SSAS from Google Sheets

Connect to Google Sheets in an Analysis Services project using the Google Sheets Data Provider and build OLAP cubes for use in analytics, reporting, and more.

Visualize Google Sheets in TIBCO Spotfire through ADO.NET

Integrate Google Sheets into dashboards in TIBCO Spotfire.