Google BigQuery ODBC Driver

No other solution is as advanced or BI ready
Overview
Features
Specifications
Documentation

Enable your users to access, analyze and report on their BigQuery data with the SQL-based tool of their choice.

Google BigQuery ODBC Driver Connector DiagramGoogle BigQueryThe Simba Google BigQuery ODBC driver powers the translation from standard SQL to BigQuerySQL and configures to pass the query through if an application is BigQuery-aware. Allow users full application functionality and real-time analytic capabilities. Light up features in BI clients by connecting to your BigQuery data in a powerful, effective way.

Google BigQuery allows you to run SQL-like queries against very large datasets, with potentially billions of rows using a small number of very large, append-only tables. Interrogating BigQuery to obtain schema information to present to the connected SQL-based applications, queries, including joins, are translated as necessary to work on BigQuery. Simba’s ODBC connector allows you to make quick analytic insights and to leverage back end data source high performance calculation capabilities for your favorite BI client. Complies with the latest ODBC 3.52 data standard and adds important functionality such as Unicode and 32- and 64-bit support for high-performance and cloud computing environments.

Product Highlights

  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps
  • Complies with the latest ODBC 3.52 data standard
  • Maps SQL-92 to BigQuery’s SQL subset
  • Supports query pass-through for BigQuery-aware applications
  • Provides full driver and query metadata

Product Features

  • Powerful SQL Connector allows users to define schemas on the fly on schema-less data
  • Direct BI connectivity to data without extraction
  • Full compatibility with leading analytic/reporting apps, including Microsoft Excel & Access, SAP Crystal Reports, Tableau and more
  • Maps ANSI SQL-92 to BigQuery's SQL subset
  • Supports query pass-through for BigQuery-aware applications
  • Provides full driver and query metadata

Product Specifications

  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.52 specification
  • Supports Unicode
  • Optimized support for Windows (Windows XP SP3 and newer, 32- and 64-bit editions)
  • Supports ANSI SQL-92: SELECT, JOIN, WHERE, HAVING, GROUP BY, ORDER BY, TOP and most SQL-92 scalar and aggregate functions
  • Supports BigQuery's SQL subset: SELECT, HAVING, WHERE, GROUP BY, ORDER BY, LIMIT, CASE and all functions
  • Supports all BigQuery data types (STRING, INTEGER, FLOAT, BOOLEAN, TIMESTAMP)

Product FAQ

FREE Trial

A password will be emailed to you.

Contact Sales

+1.604.633.0008 ext. 2
solutions@simba.com

Webinar

How to Build an ODBC Driver in Just 5 Days!

Play Webinar