The driver includes a browser-based tool, Progress DataDirect Google Analytics 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 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 googleanalytics.jar

    The Google Analytics 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. Optionally, add a new table to the relational schema of your Google Analytics data, or customize a predefined custom table.

    For more information about custom tables, and how they can be used to write useful queries, see Introduction to the Google Analytics Data Model.

    1. Under the Schema Settings tab, click Configure Logical Schema.
    2. Select a custom table from the dropdown list, or click Create Table and type the name of a new table.
    3. Select the metrics and dimensions you want to expose with the table. You may specify up to ten metrics and seven dimensions per table.
    4. Click Save & Close.
    5. The Add Tables field is populated with the table definition in the form of a JSON string.
  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.