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\googleanalytics4.jar

    • UNIX/LINUX Example

      CLASSPATH=.:/opt/Progress/DataDirect/JDBC/lib/60/googleanalytics4.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. The following example shows you the minimum properties required to connect using OAuth 2.0 authentication with a refresh token.

      jdbc:datadirect:googleanalytics4:AddTables='{myTableDefinitionString}';
ClientID=ab123c45-def6-7g89-gh1i-m2345no67891.apps.googleusercontent.com;
ClientSecret=12a3=bCD/EfGh4Ijk+Lm5P67qR8s=//TuV+WXy1Zabcd;
RefreshToken=1//12a3=bCD/EfGh4Ijk+Lgd8g-44tk3c527831;
      You can also generate a connection string using the Progress DataDirect Google Analytics 4 Configuration Manager. For details, see Generating connection URLs with the Configuration Manager.
      Important: Although you can still connect to Google Analytics, you cannot query your data without defining the tables in your schema using the AddTables property. You can generate a value for this property using the Configure Logical Schema button in the Configuration Manager and copy it into your string. See Generating connection URLs with the Configuration Manager for details.
      Note: You can fetch tokens using the Configuration Manager. See OAuth 2.0 Authentication for more information.
    • 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:
    • Connection URL Examples provides connection string examples that can be used to configure common functionality and features. You can modify and combine these examples to create a string that best suites your environment.
    • Connection property descriptions provides a complete list of supported properties by functionality.
    • Performance considerations describes connection properties that affect performance, along with recommended settings.
  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 accessing data with some common tools:
    • Progress DataDirect Google Analytics 4 Configuration Manager: The Google Analytics 4 Configuration Manager is a browser-based tool that allows you to quickly generate connection URLs, test connections, and execute test queries.
    • DataDirect Test: DataDirect Test allows you to test connect, execute SQL statements, and practice using the JDBC 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.
    • DbVisualizer: DB Visualizer is a database tool that allows you to connect and execute SQL statements against your data.
    • Supported SQL statements and extensions: This section describes the syntax used for SQL statements supported by the driver. You can modify and use the provided examples for your application or tool.

This completes the deployment of the driver.