Devart ODBC Driver for Google BigQuery provides a high-performance and
feature-rich connectivity solution for ODBC-compliant applications to
access BigQuery data from Windows, both 32-bit and 64-bit.
The driver processes standard ODBC function calls, submits SQL
statements to BigQuery, and returns results to the application. You can
work with BigQuery data warehouse like you would with a database –
execute SQL statements to read, write, update, and delete billions of
rows in very large tables.
Connection to BigQuery 
Our connectivity solution enables various ODBC-aware applications to connect
to BigQuery directly via HTTPS. If you have no direct access to
BigQuery via HTTPS, you have the option of establishing a connection
through a proxy server.
Extended SQL Syntax
Our ODBC driver provides an unrivalled opportunity to work with BigQuery objects just as with SQL tables. The extended SQL syntax allows you to use all the SQL benefits in SQL-92 compatible SELECT statements:
- Aggregate functions
- Array functions
- Datetime functions
- Geography functions
- JSON functions
- Navigation functions
- Net functions
- Hash functions
DML Operations
Devart ODBC Driver for Google BigQuery provides support for DML:
- INSERT
- UPDATE
- DELETE
Which allows you to modify data ini BigQuery data warehouse the same way as in SQL databases
Cost-Effective Deployment
Our ODBC driver is a standalone installation file that doesn't require
the user to deploy and configure any additional software such as a
database client or a vendor library. Deployment costs are reduced
drastically, especially when using the silent install method with an OEM license in large organizations that have hundreds of machines.
ODBC Conformance
- ODBC API Functions support
- ODBC Data Types support
In addition, we provide support for Advanced Connection String parameters, thus allowing
any desktop and web applications to connect to Google BigQuery from various
environments and platforms that support ODBC.
BigQuery Compability
Devart ODBC driver fully supports the Google BigQuery API, data types, and expressions, including functions and operators.
.
What are some reason to choose Devart
ODBC Driver for Google BigQuery?
Platform VarietyODBC Driver for Google BigQuery can be used with 32-bit and 64-bit applications on both x32 and
x64 platforms, so there is no need to additionally configure the driver, applications or
environment
IntegrationThe driver is compatible with 3rd-party tools for data analysis, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.
For the complete list of compatible tools and environments visit the Compatibility page
With our fully Unicode-compliant driver, you can properly retrieve and modify any data in multilingual BigQuery data warehouses, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.
We have implemented advanced Data Conversion mechanisms that provide bi-directional mapping between any Google BigQuery and ODBC data types.
High Performance
Every operation with Google BigQuery becomes significantly faster using such capabilities of our
driver as local data caching, connection pooling, and much more.
Support
Visit our Support page to get instant
support from experienced professionals, fast and detailed responses, user engagement
and interaction, frequent builds with bug fixes, and much more.
Buy at Tokopedia!
Buy Now!
Tags: ODBC Driver for Google BigQuery, ODBC Driver, ODBC, devart, Data Processing