Enable your users to access, analyze and report on their BigQuery data with the SQL-based tool of their choice. The Simba ODBC and JDBC drivers with SQL Connector for Google BigQuery provide you full access to BigQuery’s Standard SQL. 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 ODBC & JDBC Driver Connectivity diagram | Simba Technologies
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 and JDBC connectors for Google BigQuery 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.8 and JDBC 4.2 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.8 and JDBC 4.2 data standard
  • Supports BigQuery’s Standard SQL
  • Provides full driver and query metadata

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, Tableau, Power BI and more
  • Supports BigQuery’s Standard SQL
  • Provides full driver and query metadata
  • Support for ODBC 3.8
  • Support for JDBC 4.2
  • Transfers data over secure connections with BigQuery via SSL

Specifications

  • Supports 32- and 64-bit applications
  • Complies with latest ODBC 3.8 specification
  • JDBC Driver compliant with the latest JDBC 4.2 specification
  • Supports Unicode
  • Optimized metadata retrieval for SQLTables and SQLColumns
  • Optimized support for Windows (Windows XP SP3 and newer, 32- and 64-bit editions)
  • Supports BigQuery’s Standard SQL
  • Supports all BigQuery data types (STRING, INTEGER, FLOAT, BOOLEAN, TIMESTAMP)

Get ODBC & JDBC Drivers with SQL Connector for Google BigQuery

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

Download Now 30 Days Free Trial

Contact us

Questions? Ready to Buy?
Let's talk.

We'll get back to you within the next business day.

Evaluation and Sales Support
If you are evaluating our drivers or our SimbaEngine X SDK, our Sales Engineers would be happy to assist you. If you are ready to buy or you require licensing information, please complete the form provided, or contact us by email or phone:
+1-604-633-0008 x2 or connectivity@magnitude.com

Customer Technical Support

If you are a customer, please use our Magnitude Customer Support Portal