To configure a basic data source to test your connection:
1. From the Progress DataDirect program group, start the ODBC Administrator.
2. Click either the User DSN, System DSN, or File DSN tab to display a list of data sources.
User DSN: If you installed a default DataDirect ODBC user data source as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.
If you are configuring a new user data source, click Add to display a list of installed drivers. Select the Google BigQuery driver and click Finish to display the driver Setup dialog box.
System DSN: To configure a new system data source, click Add to display a list of installed drivers. Select the Google BigQuery driver and click Finish to display the driver Setup dialog box.
File DSN: To configure a new file data source, click Add to display a list of installed drivers. Select the Google BigQuery driver and click Advanced to specify attributes; otherwise, click Next to proceed. Specify a name for the data source and click Next. Verify the data source information; then, click Finish to display the driver Setup dialog box.
3. The General tab of the Setup dialog box appears by default.
Note: The General tab displays only fields that are required for creating a data source. The fields on all other tabs are optional.
On the General tab, provide the following information; then, click Apply.
Data Source Name: Type a string that identifies this data source configuration, such as Accounting.
Description: Type an optional long description of a data source name, such as My Accounting Database.
Project: 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: The name of the dataset that you want the driver to connect to. The datasets in Google BigQuery are equivalent to schemas in ODBC.
Access Token: The access token used to connect to your Google BigQuery instance.
Refresh Token: The refresh token used to either request a new access token or renew an expired access token.
Client ID:The consumer key used to connect to your Google BigQuery instance.
Client Secret: The consumer secret used to connect to your Google BigQuery instance.
4. Your driver is now configured with the basic settings necessary to connect your driver. Choose from the following:
If you would like to test the connection, proceed to "Testing the Connection."
If you would like to tune your driver for performance, proceed to "Tuning for Performance."
If you would like to save the values you have specified and close the setup dialog, click OK. These values will be used as the default settings when you connect to a data source.
User DSN: If you installed a default DataDirect ODBC user data source as part of the installation, select the appropriate data source name and click Configure to display the driver Setup dialog box.
