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.
      • Windows: PROGRESS_DATADIRECT_JDBC_INSTALL.exe
      • Non-Windows: PROGRESS_DATADIRECT_JDBC_INSTALL.jar
    3. Follow the prompts to complete installation.

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

  2. Set your system CLASSPATH to include the driver .jar file. The CLASSPATH is the search string your Java Virtual Machine (JVM) uses to locate JDBC drivers on your computer. The following examples demonstrate setting the CLASSPATH from a command line using the default installation directory.

    • Windows Example

      CLASSPATH=.;C:\Program Files\Progress\DataDirect\JDBC\lib\60\googlebigquery.jar

    • UNIX/LINUX Example

      CLASSPATH=.:/opt/Progress/DataDirect/JDBC/lib/60/googlebigquery.jar
  3. Configure your driver using one of the following methods:

    • Connection URL: You can begin using the driver immediately by passing a connection URL with your application or tool. For example:

      jdbc:datadirect:googlebigquery:Project=myproject;Dataset=mydataset;
AccessToken=abcdefghi12345678;RefreshToken=wxyz123456789;
ClientID=123abc.apps.googleusercontent.com;ClientSecret=ab123xy;
      Note: See Authentication to know more about user ID/password authentication and other authentication methods you can use to connect to the server.
    • Data sources: The driver also supports connecting using JDBC data sources. A JDBC data source is a Java object, specifically a DataSource object, that defines connection information required for a JDBC driver to connect to the database. See Connecting using data sources for more information.
    Note: For most connections, specifying the minimum required connection properties is sufficient to begin accessing data; however, you can provide values for optional properties to use additional supported features and improve performance.
  4. Set the values for any optional properties that you want to configure. For additional information on optional features and functionality, see the following resources:
  5. Connect to your service and begin accessing data with your applications, BI tools, database tools, and more. To help you get started, the following resources guide you through the processes for testing DriverManager and data source connections, and the SQL statements supported by the driver.

This completes the deployment of the driver.