Quick Start: Progress DataDirect for ODBC for Google BigQuery Driver for UNIX/Linux : Configuring a data source

Configuring a data source

The default odbc.ini file installed in the installation directory is a template in which you create data source definitions. You enter your site-specific database connection information using a text editor. Each data source definition must include the keyword Driver=, which is the full path to the driver.

The following examples show the minimum connection string options that must be set to complete a test connection, where xx represents iv for 32-bit or dd for 64-bit drivers, and yy represents the extension. The values for the options are samples and are not necessarily the ones you would use.

[ODBC Data Sources]
Google BigQuery=DataDirect 8.0 Google BigQuery

[Google BigQuery]
Driver=ODBCHOME/lib/xxgbq28.yy
Project=myproject
Dataset=mydataset
AccessToken=abcdefghi12345678
RefreshToken=wxyz123456789
ClientID=123abc.apps.googleusercontent.com
ClientSecret=ab123xy

Connection Option Descriptions:

Project: Specifies the name of the project that you want the driver to connect to. The projects in Google BigQuery are equivalent to catalogs in ODBC.

Dataset: Specifies the name of the dataset that you want the driver to connect to. The datasets in Google BigQuery are equivalent to schemas in ODBC.

AccessToken: Specifies the access token required to authenticate to a Google BigQuery instance.

RefreshToken: Specifies the refresh token used to either request a new access token or renew an expired access token.

ClientID: Specifies the consumer key for your application.

ClientSecret: Specifies the consumer secret for your application.