dci-transparent-bg

Powerful Connectivity to Google BigQuery

Versatile

Offers full CRUD support for standard and legacy SQL

Secure

Supports authentication mechanisms like OAUTH2.0 and Service account authentication

Seamless

Integrates seamlessly with the leading analytic and reporting applications

google_analytics

Connect to Google BigQuery via

Features

Secure

The Progress DataDirect connector for Google BigQuery supports authentication mechanisms like OAUTH2.0 and Service account authentication

Flexible

The Progress DataDirect connector for Google BigQuery supports both standard and legacy SQL dialects

Powerful

The Progress DataDirect connector for Google BigQuery returns data for complex data types, such as Array, Struct and JSON strings. It also supports result sets with configurable paging options, FetchSize and WSFetchSize

Efficient

Progress DataDirect connectors use 76% less CPU capacity and 70% less memory than our competition without sacrificing performance


Have other Cloud Data Warehouse applications?

Learn more how Progress DataDirect supports your needs.

Specification ODBC

Progress DataDirect for ODBC for Google BigQuery Version 8.0.0
(32- and 64-bit drivers are available for all supported databases and platforms unless otherwise noted.)

ODBC Version Support

  • Compatible with ODBC 3.8 applications

Version Support

  • Google BigQuery

Operating System Support

AIX (32- and 64-bit)

  • AIX, version 5.3, 6.1, 7.1 and higher

HP

  • HP-UX IPF (32- and 64-bit), 11i version 2.0 (B.11.23) and higher

Linux x86 (32- and 64-bit for AMD and Intel processors)

  • CentOS Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
  • Debian Linux x86, version 7.0, 8.0 and higher
  • Oracle Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
  • Red Hat Enterprise Linux x86, version 4.0, 5.0, 6.0, 7.0, 8.0 and higher
  • SUSE Linux Enterprise Server Linux x86, version 10, 11, 12, 15 and higher
  • Ubuntu Linux x86, version 14.04, 16.04, 18.04 and higher

Solaris (64-bit)

  • Solaris x86, version 10 (Solaris 5.10), 11 and higher
  • Solaris on SPARC, version 8 (Solaris 5.8), 9, 10, 11 and higher

Windows (32- and 64-bit)

  • Windows (x86), version 7, 8.1, 10 and higher
  • Windows Server (x86), version 2008, 2012, 2016 and higher

Driver/Client Software Requirements

  • Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

Specification JDBC

Progress DataDirect for JDBC for Google BigQuery
Version 6.0.0

Supported Versions

  • Google BigQuery

Platform Support

  • 32- and 64-bit platforms

Software Requirements

  • Java Virtual Machine (JVM): Java SE 8 or higher (LTS version), including Oracle JDK, OpenJDK, and IBM SDK (Java) distributions.

Security Vulnerability Response Policy

Upon identification of any security vulnerability, Progress will exercise commercially reasonable efforts to address the vulnerability in accordance with the following policy:

Priority* Time Guideline Version(s)
High Risk
(CVSS 8+ or industry equivalent)
30 days Active (i.e. latest shipping version) and all Supported versions
Medium Risk
(CVSS 5-to-8 or industry equivalent)
180 days Active (i.e. latest shipping version)
Low Risk
(CVSS 0-to-5 or industry equivalent)
Next major release or best effort Active (i.e. latest shipping version)

* Priority is established based on the current version of the Common Vulnerability Scoring System (CVSS), an open industry standard for assessing the severity of computer system security vulnerabilities. For additional information on this scoring system, refer to https://en.wikipedia.org/wiki/CVSS.

Learning & Support

Blog

5 Takeaways from the Progress DataDirect Data Connectivity Report

Learn what 1,800 people who live and breathe data said matters most about the cloud, regulations, databases, analytics and reporting, and data connectivity.

Read More

Video

DataDirect Hybrid Data Pipeline: Overview

The Progress DataDirect Hybrid Data Pipeline is a lightweight data access platform that you can install either in the cloud or behind your firewall. It provides simple, secure access to your cloud and on-premises data sources for your business intelligence tools and applications. You maintain complete control over the platform and its connectivity to the data sources and applications in your specific business environment.

This video takes a brief look at the connectivity challenges created when a wide variety of data types and applications reside in different environments, then demonstrates how the Data Pipeline addresses those challenges.

Watch Video

Success Story

Nationwide

Rebuilt its business-critical analytics system, moving from the Windows operating system to Unix, and upgrading its version of SAS, among other significant changes. Progress DataDirect provided a critical link to Nationwide’s SQL databases, reliably keeping its analytics apps up and running.

Learn More

Success Story

BOARD embeds Hybrid Connectivity service to access on-premises data sources

A major supplier of business intelligence and corporate performance management software with more than 3,000 customers, BOARD needed a flexible and scalable connectivity solution to meet customer demands for cloud-based deployment options. 

Learn More

Tutorial

Connect and Query Google BigQuery using JDBC Connector

In this tutorial, we will walk through how to connect to Google BigQuery from SQL/BI/ETL tools using Progress DataDirect's JDBC Connector for Google BigQuery.

Read More

Webinar

Progress DataDirect + Google BigQuery – Accelerate Your Data Warehousing and BI Initiatives

Increasingly, businesses need a data warehouse environment that can scale while requiring little-to-no additional infrastructure investment. Google BigQuery answers this demand, and our new Google BigQuery connectors enables you to easily connect your apps to this cloud data warehouse. Watch this webinar to see our new connector in action.

Watch Webinar

Paper

Accelerate Your Cloud Data Warehouse Productivity

Enterprises are increasingly migrating to cloud data warehouses but the value of these cloud data warehouses is ultimately limited by how quickly you can access the data within them. See how Progress DataDirect connectors for cloud data warehouses solve that challenge and provide you with secure data access at the speed of business.

Download Paper

Customer Success Stories

toyota-min

When Toyota Motor Sales introduced Progress DataDirect for ODBC to their intricate data architecture, they saved $100,000 in 24 hours. Learn more in this case study from Progress Software.

Read the whole story
microstrategy-min

MicroStrategy, a leading worldwide provider of enterprise software platforms, needs to sustain its market leadership as customers demand direct access to new types of data sources, such as Salesforce.com and Hive.

Read the whole story

Connect any application to any data source anywhere

A product specialist will be glad to get in
touch with you