Features

• Connection to Google BigQuery - Establish a connection to BigQuery data through HTTPS. You also have the ability to connect through a proxy using the following connection options: Host, Port, Username and Password.
• BigQuery Standard SQL - Supports all BigQuery standard SQL expressions, including functions and operations and all data types:
  • Aggregate functions
  • Array functions
  • Datetime functions
  • Geography functions
  • JSON functions
  • Navigation functions
  • Net functions
  • Hash functions
• Integration - The driver is compatible with 3rd-party data analysis tools, such as Microsoft Excel, and integrates with various IDEs and systems like Visual Studio, etc.
• Cost-Effective Deployment - 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.
• Platforms Variety - The driver can be used with 32-bit and 64-bit applications on both platforms, so there is no need to configure the driver, applications or environment.
• Fully Unicode-Compliant Driver - You can retrieve and modify any data in multilingual BigQuery databases, regardless of their character set: Latin, Cyrillic, Hebrew, Chinese, etc., and in any language environment.
• ODBC Conformance
  • ODBC API Functions support
  • ODBC Data Types support
  • In addition, it provides support for Advanced Connection String parameters, allowing any desktop and web applications to connect to Google BigQuery from various environments and platforms that support ODBC.
• DML Operations - Devart ODBC Driver for Google BigQuery provides support for DML which allows you to modify data in Google BigQuery the same way as in SQL databases:
  • INSERT
  • UPDATE
  • DELETE
• Google BigQuery Compatibility - The ODBC driver has full support for Google BigQuery field data types and, moreover, the driver is compatible with the Google BigQuery API itself.
  • Google BigQuery API.
  • Google BigQuery Data Types.
• Advanced Data Conversion - Advanced Data Conversion mechanisms have been implemented that provide bi-directional mapping between any Google BigQuery and ODBC data types.
• High Performance - Every operation with Google BigQuery becomes significantly faster using features such as local data caching, connection pooling, and much more.
• Verified Compatibility With Data Integration Tools - Devart ODBC drivers are verified to be compatible with leading analytics and reporting tools, various IDEs, and programming languages. Get fast and secure access to your data in any application:
  • Database Management Software
    • SQL Server Management Studio (SSMS)
    • Microsoft Access
    • DBeaver
    • RazorSQL
    • and others
  • Business Intelligence & Analytics Software
    • Power BI
    • Tableau
    • QlikView
    • TIBCO Spotfire
    • and others
  • Document Management Software
    • Microsoft Excel
    • LibreOffice
    • OpenOffice
    • StarOffice
    • and others
  • Application Development Tools
    • Microsoft Visual Studio
    • Python, PHP
    • FileMaker
    • C++ Builder
    • and others