Devart ODBC Driver for Google Sheets

Reliable and easy to use data connector for Google Sheets.

Published by Devart
Distributed by ComponentSource since 2005

Prices from: $ 195.95 Version: 1.2.2 NEW Updated: Apr 17, 2024

Screenshot of Devart ODBC Driver for Google Sheets

About Devart ODBC Driver for Google Sheets

Reliable and easy to use data connector for Google Sheets.

Devart ODBC Driver for Google Sheets is a high-performance connectivity tool with enterprise-level features for accessing Google Sheets from ODBC-compliant reporting, analytics, BI, and ETL tools on both 32-bit and 64-bit Windows. The ODBC driver fully supports standard ODBC API functions and data types and enables easy access to live Google Sheets data from anywhere.

Features

  • Connection to Google Sheets - The driver enables various ODBC-aware applications to connect to Google Sheets directly via HTTPS. If you have no direct access to Google Sheets via HTTPS, you have the option of establishing a connection through a proxy server.
  • Extended SQL Syntax - The ODBC driver provides an unrivaled opportunity to work with Google Sheets objects just as with SQL tables. The extended SQL syntax allows you to use all the SQL benefits in SQL-92 compatible SELECT statements:
    • Complex JOINs.
    • WHERE conditions.
    • Subqueries.
    • GROUP statements.
    • Aggregation functions.
    • ORDER statements.
  • ODBC Conformance - ODBC driver for Google Sheets provides full support for common ODBC interface:
    • ODBC API Functions support.
    • ODBC Data Types support.
    • In addition, it provides support for Advanced Connection String parameters, which allows any desktop and web applications to connect to Google Sheets from various environments and platforms that support ODBC.
  • DML Operations - Devart ODBC Driver for Google Sheets provides support for DML which allows you to modify data in Google Sheets the same way as in SQL databases:
    • INSERT.
    • UPDATE.
    • DELETE.
  • Google Sheets Compatibility - The ODBC driver has full support for Google Sheets field data types and, moreover, the driver is compatible with the Google Sheets API itself.
    • Google Sheets API.
    • Google Sheets Data Types.
  • Advanced Data Conversion - Includes advanced Data Conversion mechanisms that provide bi-directional mapping to ODBC data types.