CData Software - Knowledge Base



Recent Google Sheets Articles

DataBind Controls to Google Sheets in C++Builder

DataBind to Google Sheets in C++Builder with standard components and controls.

Create Informatica Mappings From/To an ODBC Data Source for Google Sheets

Create an ODBC connection to Google Sheets in Informatica and browse and transfer Google Sheets.

How to connect to Google Sheets with Squirrel SQL client

Connect to Google Sheets and execute queries in the Squirrel SQL Client.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Using the CData Software ODBC Driver for Google Sheets in PyCharm

Connect to Google Sheets as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Sheets.

Use the CData ODBC Driver for Google Sheets from SharePoint Excel Services

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

How to Use a Microsoft Access Database to Update Google Sheets in Real Time

Update Google Sheets data by creating a linked table in Microsoft Access with the CData Google Sheets ODBC Driver.

Connect to Google Sheets in Jaspersoft Studio

Execute SQL to remote Google Sheets in Jaspersoft Studio.

Visualize Google Sheets Data in Tableau

The CData ODBC driver for Google Sheets enables you integrate Google Sheets data into Tableau dashboards.

Analyze Google Sheets in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Google Sheets and visualize Google Sheets in SAP Analytics Cloud.

Connect to Google Sheets from a Connection Pool in JBoss

Integrate Google Sheets into Java servlets: Use the Management Console in JBoss to install the Google Sheets JDBC Driver.

Import and Visualize Google Sheets in Power View

Create data visualizations based on Google Sheets in Excel.

Connect to Google Sheets in DBArtisan

Use wizards in DBArtisan to configure Google Sheets as a data source.

How to connect to Google Sheets in DBVisualizer

Integrate Google Sheets with visual data analysis tools and data connection wizards in DBVisualizer

Build Dashboards with Google Sheets in DBxtra

Create dynamic dashboards and perform analytics based on Google Sheets in DBxtra.

Replicate Google Sheets from PowerShell

Write a quick PowerShell script to query Google Sheets. Use connectivity to the live data to replicate Google Sheets to SQL Server.

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.

Feed Google Sheets into FineReport

How to set Google Sheets as a JDBC data source in FineReport.

Extract, Transform, and Load Google Sheets in Informatica PowerCenter

Create a simple Workflow for Google Sheets in Informatica PowerCenter.

How to connect PolyBase to Google Sheets

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Sheets.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Sheets

Provide connectivity to Google Sheets through an SAP BusinessObjects universe.

Connect to Google Sheets in NetBeans

Connect to Google Sheets in NetBeans with the data source configuration wizard.

Enable the Google Sheets JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Google Sheets.

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.

Connect to Google Sheets in Ruby

Connect to Google Sheets in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to publish and share Google Sheets dashboards with Tableau Server

The CData ODBC driver for Google Sheets enables you integrate Google Sheets into Tableau dashboards.

Visualize Google Sheets in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Sheets into 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.

Publish Crystal Reports on Google Sheets

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Sheets.

Create Informatica Mappings From/To a JDBC Data Source for Google Sheets

Create Google Sheets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

ETL Google Sheets in Oracle Data Integrator

This article shows how to transfer Google Sheets into a data warehouse using Oracle Data Integrator.

Analyze Google Sheets with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Google Sheets from Power Pivot. You will use the Table Import Wizard to load Google Sheets. You can visually build the import query or use any SQL supported by the driver.

Visualize Google Sheets in TIBCO Spotfire through ADO.NET

Integrate Google Sheets into dashboards in TIBCO Spotfire.

Object-Relational Mapping (ORM) with Google Sheets Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Sheets into a Java-based ORM framework, Hibernate.

DataBind Controls to Google Sheets in Delphi

DataBind to Google Sheets in Delphi with standard data access components and controls.

Build a Simple VCL Application for Google Sheets

How to build a simple VCL Application to view Google Sheets in RAD Studio using the CData ODBC Driver for Google Sheets.

Query Google Sheets in ColdFusion

Write standard ColdFusion data access code to connect to Google Sheets.

Connect to Live Google Sheets in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Google Sheets in CData Connect Cloud and connect to your Google Sheets from PostgreSQL.

How to use SQLAlchemy ORM to access Google Sheets in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Sheets.

Configure the CData JDBC Driver for Google Sheets in a Connection Pool in Tomcat

Connect to Google Sheets from a connection pool in Tomcat.

Build Charts with Google Sheets in Clear Analytics

Create dynamic charts and perform analytics based on Google Sheets in Clear Analytics.

Connect to Google Sheets from a Connection Pool in WebLogic

Use the CData JDBC Driver for Google Sheets to connect to Google Sheets from Web applications running on WebLogic.

How to Build Dynamic React Apps with Google Sheets

Use the CData Connect and React to Build Dynamic Web Apps with Live Google Sheets .

Connect to Google Sheets in CloverDX (formerly CloverETL)

Transfer Google Sheets using the visual workflow in the CloverDX data integration tool.

How to connect to Google Sheets from IntelliJ

Integrate connectivity to Google Sheets with wizards in IntelliJ.

Create SSAS Tabular Models from Google Sheets

How to build a SQL Server Analysis Service Tabular Model from Google Sheets using CData drivers.

Connect to Google Sheets in JRuby

Create a simple JRuby app with access to live Google Sheets.

Create Data Visualizations in Cognos BI with Google Sheets

Access Google Sheets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

How to Connect to Google Sheets in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the pyodbc module for ODBC in Python.

Natively Connect to Google Sheets in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Sheets

Provide connectivity to Google Sheets through an SAP BusinessObjects universe.

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.

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.

Build Dashboards with Google Sheets in Dundas BI

Create dynamic dashboards and perform analytics based on Google Sheets in Dundas BI.

How to Connect to & Open Google Sheets in Microsoft Excel

This article uses the CData ODBC driver for Google Sheets to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Integrate Google Sheets in the Pentaho Report Designer

Publish reports based on Google Sheets in the Pentaho BI tool.

Establish a Live Connection with Google Sheets using Tableau Bridge

The CData ODBC Driver for Google Sheets enables you to integrate live Google Sheets into Tableau Cloud dashboards using the Tableau Bridge.

Connect to and Query Google Sheets in QlikView over ODBC

Create data visualizations with Google Sheets in QlikView.

Connect to Google Sheets from PowerBuilder

This article demonstrates how to access Google Sheets from PowerBuilder using the Google Sheets JDBC Driver.

Bidirectional Access to Google Sheets from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Google Sheets in Filemaker Pro for Mac or Windows.

How to update Google Sheets from Excel

This article explains how to transfer data from Excel to Google Sheets using the Excel Add-In 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.

Connect to Google Sheets in RapidMiner

Integrate Google Sheets with standard components and data source configuration wizards in RapidMiner Studio.

Use CData Connect Cloud to Access Google Sheets in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Google Sheets in the Power Pivot business intelligence tool.

Connect to Google Sheets in SpagoBI

Create reports featuring live Google Sheets in SpagoBI Studio. Host Google Sheets reports on SpagoBI Server.

Load Google Sheets to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Sheets to a database.

DataBind Google Sheets to the DevExpress Data Grid

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

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.

Connect to Google Sheets from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Google Sheets to connect to Google Sheets and execute queries in PowerBuilder.

Create Reports with Google Sheets in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Google Sheets.

Connect to Google Sheets from a Connection Pool in Jetty

The Google Sheets JDBC Driver supports connection pooling: This article shows how to connect faster to Google Sheets from Web apps in Jetty.

Visualize Google Sheets in Sisense

Create an ElastiCube in Sisense app with access to Google Sheets.

Connect to Google Sheets in Google Apps Script

Use the ODBC Driver for Google Sheets and the SQL Gateway to access Google Sheets from Google Apps Script.

Connect to Google Sheets from PowerBuilder

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

Connect to and Visualize Live Google Sheets in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Sheets.

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.

Connect to Google Sheets from Asprova with CData Software ODBC Driver for Google Sheets

This article shows how to connect faster to Google Sheets data from Asprova.

How to create Visio diagrams from Google Sheets

Automatically update Google Sheets with the changes you make to Visio master shapes.

Visualize Live Google Sheets in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Google Sheets.

Import Google Sheets into FileMaker Pro

Create reports that integrate Google Sheets in Filemaker Pro.

Publish Google Sheets-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Google Sheets.

Connect to Google Sheets as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Sheets.

Create Apps from Google Sheets in Qlik Sense Cloud

Use CData Connect Cloud to connect to Google Sheets and build apps from live Google Sheets in Qlik Sense Cloud.

Connect to Google Sheets in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Google Sheets and connect to Google Sheets in Akorbi Digital RunMyProcess.

Connect to Google Sheets in RazorSQL

Connect to Google Sheets from wizards and query Google Sheets from the GUI in the RazorSQL database management tool.

Working with Google Sheets in LINQPad

Execute LINQ queries to Google Sheets in LINQPad.

Visualize Google Sheets in TIBCO Spotfire through OData

Integrate Google Sheets into dashboards in TIBCO Spotfire.

Using AngularJS to Build Dynamic Web Pages with Google Sheets

Use the CData Connect Server to create Google Sheets OData feeds and build single-page applications with live Google Sheets.

Manage Google Sheets in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Google Sheets.

Visualize Google Sheets from Tableau

Use the Tableau Desktop business intelligence tool to connect to Google Sheets.

DataBind Wijmo Grid to Google Sheets

Provide real-time Google Sheets to interactive controls.

Use the CData ODBC Driver for Google Sheets in SAS JMP

You can use the CData ODBC Driver to integrate Google Sheets into the statistical analysis tools available in SAS JMP. This article shows how to use Google Sheets in the Graph Builder and Query Builder.

How to Connect DBeaver to Google Sheets via a JDBC Driver

Manage Google Sheets with visual tools in DBeaver like the query browser.

Publish Google Sheets-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Google Sheets.

Design BIRT Reports on Google Sheets

Provide current Google Sheets to your embedded analytics.

Viewing Google Sheets in RAD Studio Data Explorer

How to view Google Sheets in RAD Studio Data Explorer using the CData ODBC Driver for Google Sheets.

PowerShell Scripting to Replicate Google Sheets to MySQL

Write a simple PowerShell script to replicate Google Sheets to a MySQL database.

Access Google Sheets in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Sheets.

Edit and Search External Google Sheets Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Google Sheets to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Sheets objects that you can access from apps and the dashboard.

How to Build an ETL App for Google Sheets in Python with CData

Create ETL applications and real-time data pipelines for Google Sheets in Python with petl.

Explore Geographical Relationships in Google Sheets with Power Map

Create data visualizations with Google Sheets in Power Map.

Publish Reports with Google Sheets in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Google Sheets.

Connect to Google Sheets in Google Apps Script

Use CData Connect Cloud to access Google Sheets in Google Apps Script.

Natively Connect to Google Sheets in PHP

The CData ODBC driver for Google Sheets enables you to create PHP applications with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.

Connect to Google Sheets through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Google Sheets to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Sheets objects that you can access from apps and the dashboard.

Integrating Google Sheets in Talend Cloud Data Management Platform

Connect Google Sheets with Talend Cloud Data Management Platform using the [product_name].

Integrate with Google Sheets in JReport Designer

Create charts and reports based on Google Sheets in JReport Designer.

Automate Google Sheets Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Google Sheets from PowerShell? This article demonstrates how to utilize the Google Sheets Cmdlets for tasks like connecting to Google Sheets, automating operations, downloading data, and more.

Work with Google Sheets in FoxPro

Load Google Sheets into a FoxPro database. This article includes full code and a walk-through of the process.

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.

Build MVC Applications with Connectivity to Google Sheets

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Sheets from an ASP.NET MVC application.

Analyze Google Sheets in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Google Sheets and visualize live Google Sheets in Infragistics Reveal.

Import Salesforce Data into Google Spreadsheets

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to get data from Salesforce (plus 80+ other sources). These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into a Google Spreadsheet.

How to Visualize Google Sheets Data in Python with pandas

Use pandas and other modules to analyze and visualize live Google Sheets in Python.

Visualize Google Sheets in Tableau

The CData ODBC driver for Google Sheets enables you integrate Google Sheets into Tableau dashboards.

Connect to Google Sheets in Aqua Data Studio

Access Google Sheets from tools in Aqua Data Studio such as the Visual Query Builder and the Table Data Editor.

Access Google Sheets as a Remote Oracle Database

Use the Oracle ODBC Gateway and Heterogeneous Services technology to access Google Sheets from your Oracle system.

How to create Google Sheets federated tables in MySQL

Use the SQL Gateway and the ODBC Driver to set up federated tables for Google Sheets in MySQL .

Use Dash to Build to Web Apps on Google Sheets

Create Python applications that use pandas and Dash to build Google Sheets-connected web apps.

DataBind Controls to Google Sheets in C++Builder

DataBind to Google Sheets in C++Builder with standard components and controls.

Create Informatica Mappings From/To an ODBC Data Source for Google Sheets

Create an ODBC connection to Google Sheets in Informatica and browse and transfer Google Sheets.

How to connect to Google Sheets with Squirrel SQL client

Connect to Google Sheets and execute queries in the Squirrel SQL Client.

Excel Spreadsheet Automation with the QUERY Formula

Pull data, automate spreadsheets, and more with the QUERY formula.

Using the CData Software ODBC Driver for Google Sheets in PyCharm

Connect to Google Sheets as an ODBC data source in PyCharm using the CData Software ODBC Driver for Google Sheets.

Use the CData ODBC Driver for Google Sheets from SharePoint Excel Services

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

How to Use a Microsoft Access Database to Update Google Sheets in Real Time

Update Google Sheets data by creating a linked table in Microsoft Access with the CData Google Sheets ODBC Driver.

Connect to Google Sheets in Jaspersoft Studio

Execute SQL to remote Google Sheets in Jaspersoft Studio.

Visualize Google Sheets Data in Tableau

The CData ODBC driver for Google Sheets enables you integrate Google Sheets data into Tableau dashboards.

Analyze Google Sheets in SAP Analytics Cloud

Use CData Connect Cloud to create an OData API on top of Google Sheets and visualize Google Sheets in SAP Analytics Cloud.

Connect to Google Sheets from a Connection Pool in JBoss

Integrate Google Sheets into Java servlets: Use the Management Console in JBoss to install the Google Sheets JDBC Driver.

Import and Visualize Google Sheets in Power View

Create data visualizations based on Google Sheets in Excel.

Connect to Google Sheets in DBArtisan

Use wizards in DBArtisan to configure Google Sheets as a data source.

How to connect to Google Sheets in DBVisualizer

Integrate Google Sheets with visual data analysis tools and data connection wizards in DBVisualizer

Build Dashboards with Google Sheets in DBxtra

Create dynamic dashboards and perform analytics based on Google Sheets in DBxtra.

Replicate Google Sheets from PowerShell

Write a quick PowerShell script to query Google Sheets. Use connectivity to the live data to replicate Google Sheets to SQL Server.

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.

Feed Google Sheets into FineReport

How to set Google Sheets as a JDBC data source in FineReport.

Extract, Transform, and Load Google Sheets in Informatica PowerCenter

Create a simple Workflow for Google Sheets in Informatica PowerCenter.

How to connect PolyBase to Google Sheets

Use CData drivers and PolyBase to create an external data source in SQL Server 2019 with access to live Google Sheets.

Create an SAP BusinessObjects Universe on the CData JDBC Driver for Google Sheets

Provide connectivity to Google Sheets through an SAP BusinessObjects universe.

Connect to Google Sheets in NetBeans

Connect to Google Sheets in NetBeans with the data source configuration wizard.

Enable the Google Sheets JDBC Driver in KNIME

Use standard data access components in KNIME to create charts and reports with Google Sheets.

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.

Connect to Google Sheets in Ruby

Connect to Google Sheets in Ruby with ruby-dbi, dbd-odbc, and ruby-odbc.

How to publish and share Google Sheets dashboards with Tableau Server

The CData ODBC driver for Google Sheets enables you integrate Google Sheets into Tableau dashboards.

Visualize Google Sheets in TIBCO Spotfire through ODBC

The ODBC standard has ubiquitous support and makes self-service business intelligence easy. Use the ODBC Driver to load Google Sheets into 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.

Publish Crystal Reports on Google Sheets

Use the Report Wizard and standard ADO.NET to design a report based on up-to-date Google Sheets.

Create Informatica Mappings From/To a JDBC Data Source for Google Sheets

Create Google Sheets data objects in Informatica using the standard JDBC connection process: Copy the JAR and then connect.

ETL Google Sheets in Oracle Data Integrator

This article shows how to transfer Google Sheets into a data warehouse using Oracle Data Integrator.

Analyze Google Sheets with Power Pivot

This article walks you through the process of using the CData ODBC Driver for Google Sheets from Power Pivot. You will use the Table Import Wizard to load Google Sheets. You can visually build the import query or use any SQL supported by the driver.

Visualize Google Sheets in TIBCO Spotfire through ADO.NET

Integrate Google Sheets into dashboards in TIBCO Spotfire.

Object-Relational Mapping (ORM) with Google Sheets Entities in Java

Object-relational mapping (ORM) techniques make it easier to work with relational data sources and can bridge your logical business model with your physical storage model. Follow this tutorial to integrate connectivity to Google Sheets into a Java-based ORM framework, Hibernate.

DataBind Controls to Google Sheets in Delphi

DataBind to Google Sheets in Delphi with standard data access components and controls.

Build a Simple VCL Application for Google Sheets

How to build a simple VCL Application to view Google Sheets in RAD Studio using the CData ODBC Driver for Google Sheets.

Query Google Sheets in ColdFusion

Write standard ColdFusion data access code to connect to Google Sheets.

Connect to Live Google Sheets in PostGresSQL Interface through CData Connect Cloud

Create a live connection to Google Sheets in CData Connect Cloud and connect to your Google Sheets from PostgreSQL.

How to use SQLAlchemy ORM to access Google Sheets in Python

Create Python applications and scripts that use SQLAlchemy Object-Relational Mappings of Google Sheets.

Configure the CData JDBC Driver for Google Sheets in a Connection Pool in Tomcat

Connect to Google Sheets from a connection pool in Tomcat.

Build Charts with Google Sheets in Clear Analytics

Create dynamic charts and perform analytics based on Google Sheets in Clear Analytics.

Connect to Google Sheets from a Connection Pool in WebLogic

Use the CData JDBC Driver for Google Sheets to connect to Google Sheets from Web applications running on WebLogic.

How to Build Dynamic React Apps with Google Sheets

Use the CData Connect and React to Build Dynamic Web Apps with Live Google Sheets .

Connect to Google Sheets in CloverDX (formerly CloverETL)

Transfer Google Sheets using the visual workflow in the CloverDX data integration tool.

How to connect to Google Sheets from IntelliJ

Integrate connectivity to Google Sheets with wizards in IntelliJ.

Create SSAS Tabular Models from Google Sheets

How to build a SQL Server Analysis Service Tabular Model from Google Sheets using CData drivers.

Connect to Google Sheets in JRuby

Create a simple JRuby app with access to live Google Sheets.

Create Data Visualizations in Cognos BI with Google Sheets

Access Google Sheets as an ODBC data source in Cognos Business Intelligence and create data visualizations in Cognos Report Studio.

How to Connect to Google Sheets in Using Python: 6 Steps

Create Python applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the pyodbc module for ODBC in Python.

Natively Connect to Google Sheets in PHP

Create PHP applications on Linux/UNIX machines with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.

Create an SAP BusinessObjects Universe on the CData ODBC Driver for Google Sheets

Provide connectivity to Google Sheets through an SAP BusinessObjects universe.

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.

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.

Build Dashboards with Google Sheets in Dundas BI

Create dynamic dashboards and perform analytics based on Google Sheets in Dundas BI.

How to Connect to & Open Google Sheets in Microsoft Excel

This article uses the CData ODBC driver for Google Sheets to import data in Excel with Microsoft Query. This article also demonstrates how to use parameters with Microsoft Query.

Integrate Google Sheets in the Pentaho Report Designer

Publish reports based on Google Sheets in the Pentaho BI tool.

Establish a Live Connection with Google Sheets using Tableau Bridge

The CData ODBC Driver for Google Sheets enables you to integrate live Google Sheets into Tableau Cloud dashboards using the Tableau Bridge.

Connect to and Query Google Sheets in QlikView over ODBC

Create data visualizations with Google Sheets in QlikView.

Connect to Google Sheets from PowerBuilder

This article demonstrates how to access Google Sheets from PowerBuilder using the Google Sheets JDBC Driver.

Bidirectional Access to Google Sheets from FileMaker Pro

Use the MySQL Remoting feature of the JDBC driver to integrate Google Sheets in Filemaker Pro for Mac or Windows.

How to update Google Sheets from Excel

This article explains how to transfer data from Excel to Google Sheets using the Excel Add-In 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.

Connect to Google Sheets in RapidMiner

Integrate Google Sheets with standard components and data source configuration wizards in RapidMiner Studio.

Use CData Connect Cloud to Access Google Sheets in Microsoft Power Pivot

Use CData Connect Cloud to connect to live Google Sheets in the Power Pivot business intelligence tool.

Connect to Google Sheets in SpagoBI

Create reports featuring live Google Sheets in SpagoBI Studio. Host Google Sheets reports on SpagoBI Server.

Load Google Sheets to a Database Using Embulk

Use CData JDBC drivers with the open source ETL/ELT tool Embulk to load Google Sheets to a database.

DataBind Google Sheets to the DevExpress Data Grid

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

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.

Connect to Google Sheets from PowerBuilder

This article demonstrates how to use the CData ODBC Driver for Google Sheets to connect to Google Sheets and execute queries in PowerBuilder.

Create Reports with Google Sheets in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Google Sheets.

Connect to Google Sheets from a Connection Pool in Jetty

The Google Sheets JDBC Driver supports connection pooling: This article shows how to connect faster to Google Sheets from Web apps in Jetty.

Visualize Google Sheets in Sisense

Create an ElastiCube in Sisense app with access to Google Sheets.

Connect to Google Sheets in Google Apps Script

Use the ODBC Driver for Google Sheets and the SQL Gateway to access Google Sheets from Google Apps Script.

Connect to Google Sheets from PowerBuilder

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

Connect to and Visualize Live Google Sheets in Tableau Prep

Use CData Tableau Connectors and Tableau Prep Builder to visualize live Google Sheets.

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.

Connect to Google Sheets from Asprova with CData Software ODBC Driver for Google Sheets

This article shows how to connect faster to Google Sheets data from Asprova.

How to create Visio diagrams from Google Sheets

Automatically update Google Sheets with the changes you make to Visio master shapes.

Visualize Live Google Sheets in Tableau

Use CData Tableau Connectors and Tableau Desktop to visualize live Google Sheets.

Import Google Sheets into FileMaker Pro

Create reports that integrate Google Sheets in Filemaker Pro.

Publish Google Sheets-Connected Dashboards in Tableau Server

Use CData JDBC drivers and Tableau Server to visualize live Google Sheets.

Connect to Google Sheets as a Linked Server

Use the SQL Gateway and the ODBC Driver to set up a linked server for Google Sheets.

Create Apps from Google Sheets in Qlik Sense Cloud

Use CData Connect Cloud to connect to Google Sheets and build apps from live Google Sheets in Qlik Sense Cloud.

Connect to Google Sheets in RunMyProcess through Connect Cloud

Use CData Connect Cloud to create on OData API for Google Sheets and connect to Google Sheets in Akorbi Digital RunMyProcess.

Connect to Google Sheets in RazorSQL

Connect to Google Sheets from wizards and query Google Sheets from the GUI in the RazorSQL database management tool.

Working with Google Sheets in LINQPad

Execute LINQ queries to Google Sheets in LINQPad.

Visualize Google Sheets in TIBCO Spotfire through OData

Integrate Google Sheets into dashboards in TIBCO Spotfire.

Using AngularJS to Build Dynamic Web Pages with Google Sheets

Use the CData Connect Server to create Google Sheets OData feeds and build single-page applications with live Google Sheets.

Manage Google Sheets in DBArtisan as a JDBC Source

Use wizards in DBArtisan to create a JDBC data source for Google Sheets.

Visualize Google Sheets from Tableau

Use the Tableau Desktop business intelligence tool to connect to Google Sheets.

DataBind Wijmo Grid to Google Sheets

Provide real-time Google Sheets to interactive controls.

Use the CData ODBC Driver for Google Sheets in SAS JMP

You can use the CData ODBC Driver to integrate Google Sheets into the statistical analysis tools available in SAS JMP. This article shows how to use Google Sheets in the Graph Builder and Query Builder.

How to Connect DBeaver to Google Sheets via a JDBC Driver

Manage Google Sheets with visual tools in DBeaver like the query browser.

Publish Google Sheets-Connected Dashboards in Tableau Server

Use CData Tableau Connectors and Tableau Server to visualize live Google Sheets.

Design BIRT Reports on Google Sheets

Provide current Google Sheets to your embedded analytics.

Viewing Google Sheets in RAD Studio Data Explorer

How to view Google Sheets in RAD Studio Data Explorer using the CData ODBC Driver for Google Sheets.

PowerShell Scripting to Replicate Google Sheets to MySQL

Write a simple PowerShell script to replicate Google Sheets to a MySQL database.

Access Google Sheets in Mule Applications Using the CData JDBC Driver

Create a simple Mule Application that uses HTTP and SQL with CData JDBC drivers to create a JSON endpoint for Google Sheets.

Edit and Search External Google Sheets Objects in Salesforce Connect

Use CData Connect Cloud to securely provide OData feeds of Google Sheets to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Sheets objects that you can access from apps and the dashboard.

How to Build an ETL App for Google Sheets in Python with CData

Create ETL applications and real-time data pipelines for Google Sheets in Python with petl.

Explore Geographical Relationships in Google Sheets with Power Map

Create data visualizations with Google Sheets in Power Map.

Publish Reports with Google Sheets in SAP Crystal Reports

Use the Report Wizard to design a report based on up-to-date Google Sheets.

Connect to Google Sheets in Google Apps Script

Use CData Connect Cloud to access Google Sheets in Google Apps Script.

Natively Connect to Google Sheets in PHP

The CData ODBC driver for Google Sheets enables you to create PHP applications with connectivity to Google Sheets. Leverage the native support for ODBC in PHP.

Connect to Google Sheets through External Services in Salesforce

Use CData Connect Cloud to securely provide OData feeds of Google Sheets to smart devices and cloud-based applications. Use the CData Connect and Salesforce Connect to create Google Sheets objects that you can access from apps and the dashboard.

Integrating Google Sheets in Talend Cloud Data Management Platform

Connect Google Sheets with Talend Cloud Data Management Platform using the [product_name].

Integrate with Google Sheets in JReport Designer

Create charts and reports based on Google Sheets in JReport Designer.

Automate Google Sheets Integration Tasks from PowerShell

Are you in search of a quick and easy way to access Google Sheets from PowerShell? This article demonstrates how to utilize the Google Sheets Cmdlets for tasks like connecting to Google Sheets, automating operations, downloading data, and more.

Work with Google Sheets in FoxPro

Load Google Sheets into a FoxPro database. This article includes full code and a walk-through of the process.

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.

Build MVC Applications with Connectivity to Google Sheets

This article shows how to use only the Entity Framework and the CData ADO.NET provider to access Google Sheets from an ASP.NET MVC application.

Analyze Google Sheets in Infragistics Reveal

Use CData Connect Cloud to create on OData API on top of Google Sheets and visualize live Google Sheets in Infragistics Reveal.

Import Salesforce Data into Google Spreadsheets

The CData API Server offers standards-based Web service endpoints that allow a variety of applications to get data from Salesforce (plus 80+ other sources). These endpoints expose data as OData, RSS, HTML, CSV, ATOM, SOAP, JSON, JSONP, and TSV. In this article, we will use the CSV format to import Salesforce data into a Google Spreadsheet.

How to Visualize Google Sheets Data in Python with pandas

Use pandas and other modules to analyze and visualize live Google Sheets in Python.

Visualize Google Sheets in Tableau

The CData ODBC driver for Google Sheets enables you integrate Google Sheets into Tableau dashboards.