This section provides you with an overview of the steps required to install and set-up the driver. After completing this procedure, you will be able to begin accessing data with your application.

To begin accessing data with the driver:

  1. Install the driver:
    1. After downloading the product, unzip the installer files to a temporary directory.
    2. From the installer directory, run the appropriate installer file to start the installer. The installer file takes the following form:

      PROGRESS_DATADIRECT_ODBC_nn_WIN_xx_INSTALL.exe

    3. Follow the prompts to complete installation.
    Note:

    The installer program supports multiple installation methods, including command-line and silent installations. For detailed instructions, refer to the Progress DataDirect for ODBC Drivers Installation Guide.

  2. Before you can use your driver, you must set the PATH environment variable to include the path of the jvm.dll file of your Java™ Virtual Machine (JVM).
  3. To configure the driver using the ODBC Administrator (GUI), start the ODBC Administrator from the Progress DataDirect program group. The GUI dialog allows you to configure the data source definitions in the Windows Registry or generate connection strings.
    Note: The Windows driver also supports using connection strings to connect to your service. For more information, see Using a connection string.
  4. Select either the User DSN or System 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 your 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 your driver and click Finish to display the driver Setup dialog box.
  5. The Connection tab of the Configuration Manager opens in a window. Provide values for the following essential connection options; then, click Apply:

    For all connections:

    • Data Source Name: Type a string that identifies this data source configuration, such as Projects.
    • Description: Type an optional long description of a data source name, such as My Development Projects.
    • 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.
    For OAuth 2.0 refresh token grant:
    • Authentication Method: Determines which authentication method the driver uses during the course of a session. Set to OAuth2. This is the default authentication method.
    • Refresh Token: Enter the refresh token used to either request a new access token or renew an expired one.
      Important: The Refresh Token is a confidential value used to authenticate to the server. To prevent unauthorized access, this value must be securely maintained.
    • Client ID: Enter the consumer key to connect to your Google BigQuery instance.
    • Client Secret: Enter the client secret to connect to your Google BigQuery instance.
    For OAuth 2.0 access token flow:
    • Authentication Method: Determines which authentication method the driver uses during the course of a session. Set to OAuth2. This is the default authentication method.
    • Access Token: Enter the access token required to authenticate to your Google BigQuery instance.
      Important: The Access Token is a confidential value used to authenticate to the server. To prevent unauthorized access, this value must be securely maintained.
    • Client ID: Enter the consumer key to connect to your Google BigQuery instance.
    • Client Secret: Enter the client secret to connect to your Google BigQuery instance.
    Note: See Configuring OAuth 2.0 authentication for details
  6. Set the values for any additional connection options that you want to configure. To view more options, click on the tabs on the dialog. See the following resources for additional information on optional features and functionality:
    Note: For most connections, specifying the minimum required connection options is sufficient to begin accessing data; however, you can provide values for optional connection options to use additional supported features and improve performance.
  7. Click Test Connect to attempt to connect to the data source using the connection options.
  8. If you are using OAuth 2.0 authentication, the logon dialog appears. Update the following fields; then, click OK.
    • Client ID: Enter the consumer key that is used to connect to the instance.
    • Client Secret: Enter the client secret that is used to connect to the instance.

      Important: The client secret is a confidential value used to authenticate the application to the server. To prevent unauthorized access, this value must be securely maintained.

    • Access Token: Enter the access token required to authenticate to the instance.
    • Refresh Token: Enter the refresh token used to either request a new access token or renew an expired one.
    • Scope: Enter an OAuth scope or a space-separated list of OAuth scopes that limit the permissions granted by an access token.
    Note: The information you enter in the logon dialog box during a test connect is not saved.
  9. If the test was successful, the window displays a confirmation message.
  10. Click OK to close the setup dialog. The values you have specified are saved and are the defaults used when you connect to the data source. You can change these defaults by using the Configure Manager to modify your data source, or you can override these defaults by connecting to the data source using a connection string with alternate values.
  11. Connect to your Google BigQuery instance and begin accessing data with your applications, BI tools, database tools, and more. To help you get started, the following resources guide you through accessing data with some common tools:
    • Example application: The example application allows you to test connect, execute SQL statements, and practice using the ODBC API right out of the box.
    • Tableau: Tableau is a business intelligence software program that allows you to easily create reports and visualized representations of your data.
    • Microsoft Excel: Excel is a spreadsheet tool that allows you to connect, view tables, and execute SQL statements against your data.

This completes the deployment of the driver.