Google Sheets ODBC Driver | Easily Connect to Live Google Sheets Data (2024)

Windows

macOS

Unix

ODBC Driver Performance

With traditional approaches to remote access, performance bottlenecks can spell disasterfor applications. Regardless if an application is created for internal use, a commercial project, web, or mobileapplication, slow performance can rapidly lead to project failure. Accessing data from any remote source has the potentialto create these problems. Common issues include:

1. Network Connections - Slow network connections and latency issues are common in mobile applications.
2. Service Delays - Delays due to service interruptions, resulting in server hardware or software updates.
3. Large Data - Intentional or unintentional requests for large amounts of data.
4. Disconnects - Complete loss of network connectivity.

The CData ODBC Driver for Google Spreadsheets solves these issues by supporting powerful smart caching technology that can greatlyimprove the performance and dramatically reduce application bottlenecks.

Smart Caching

Smart caching is a configurable option that works by storing queried data into a local database. Enabling smartcaching creates a persistent local cache database that contains a replica of data retrieved from the remote source.The cache database is small, lightweight, blazing-fast, and it can be shared by multipleconnections as persistent storage.

Caching with our ODBC Drivers is highly configurable, including options for:

• Auto Cache - Maintain an automatic local cache of data on all requests. The provider will automaticallyload data into the cache database each time you execute a SELECT query. Each row returned by the query willbe inserted or updated as necessary into the corresponding table in the cache database.
• Explicit Cache - Cache only on demand. Developers decide exactly what data gets stored in the cacheand when it is updated. Explicit caching provides full control over the cache contents by using explicitexecution of CACHE statements.
• No Cache - All requests access only live data and no local cache file is created.

This powerful caching functionality increases application performance and allows applications to disconnectand continue limited functioning without writing code for additional local storage and/ordata serialization/deserialization.

More information about ODBC Driver caching and best caching practices is available in the includedhelp files.

Enterprise-Class Remoting

MySQL/SQL Database entry points for Google Sheets Data

The CData ODBC drivers include powerful fully-integrated remote access capabilities that makes Google Sheets data accessible from virtually anywhere. The drivers include the CData SQL Gateway, which can the optional ability to accept incoming SQL and MySQL client connections and service standard database requests.

With the CData SQL Gateway, users can interact with Google Sheets data from any client that supports SQL Server or MySQL: from Web & mobile applications, to CRM and CMS systems, BI tools like SQL Server Analysis Services, and even through popular management applications like MySQL Workbench.Access Google Sheets data from virtually any application that can access external data. Applications that can access SQL Server or MySQL data can now connect to Google Sheets with this driver.

• Connect Google Sheets data with popular BI tools like SQL Server Analysis Services.
• Enable enterprise Google Sheets data integration through SQL Linked Server connectivity
• Includes support for the MySQL and SQL (TDS) remote access protocols, with advanced wire-protocol SSL security - industry standards for remote database connectivity.
• Easily connect to Google Sheets from code (PHP, Python, Ruby, Objective-C, etc.) using one of the standard client libraries for accessing SQL/MySQL.
• * Available exclusively in ODBC Server Licenses.

learn more