The driver includes a browser-based tool, Progress DataDirect Google Analytics 4 Configuration Manager, that allows you to generate connection URLs, test connections, and execute test queries. This section will guide you through generating and testing a connection URL that can be used by your application.

To generate a connection URL:

  1. Open the Google Analytics 4 Configuration Manager by double-clicking the driver jar file. Or, in a command line, navigate to the directory containing your driver jar file; then, execute the following command: 
    java -jar googleanalytics4.jar

    The Google Analytics 4 Configuration Manager opens in your default web browser.

  2. From the browser window, provide values of the connection properties you want to configure in the corresponding fields. A connection URL will generate in the Connection String field as you provide settings. To view more properties, select the tabs at the top of the page. See "Connection URL examples" for a list of required properties and properties used for different configurations.
    Note: If you do not specify a value for an optional property, the property will be omitted from the string and the default value will be used.
  3. Define the tables in the relational schema of your Google Analytics data.

    For more information about custom tables, see Introduction to the Google Analytics Data Model.

    1. On the Schema Settings tab, click Configure Logical Schema.
    2. Select values for the following drop-down fields:
      • Account ID: The account ID used to filter the contents of the table.
      • Property ID: The property ID used to filter the contents of the table.
    3. Click the Create Table button. In the Create Table window, specify the name of table you want to create in the Table Name field; then, click Create
      Note: If you are editing an existing table that is specified by the AddTables property in the connection string, select the table from the Select Table drop-down field.
    4. Select the metrics and dimensions you want to expose with the table. You may specify up to ten metrics and seven dimensions per table.
    5. Click Save & Close.
      Result: The Add Tables field is populated with a table definition in the form of a JSON string, and the DefaultQueryOptions field is populated with parameters used for WHERE clause filtering.
  4. Optionally, you can manually edit your string by clicking the Edit button ().
  5. At any point during the process, you can click Test Connect to attempt to connect to the service using the string generated in the Connection String field. In the Test Connection window:
    1. Provide values for any fields required by your service.
    2. Optionally, in the Test Query field, enter any SQL queries you want to execute during the test. For example: 
      SELECT * FROM INFORMATION_SCHEMA.SYSTEM_TABLES
    3. Click Execute.
      If successful, the window displays a confirmation message and, if a query was specified, the results of the query.
    Note: The information you enter in the logon dialog box during a test connect is not saved.
  6. To use your string, click the Copy button () and paste the string to a location that can be used by your application.
  7. Optionally, click Save to store your connection string for later use.