Note: The Configuration Manager is currently supported only on Windows platforms.

The driver includes an enhanced setup dialog, Progress DataDirect Google Analytics 4 Configuration Manager, that allows you to configure data sources, generate connection strings, test connections, and execute test queries. On Windows, data sources are stored in the Windows Registry. You can configure and modify data sources through the ODBC Administrator using a driver Setup dialog box, as described in this section.

Note: As you configure your data source, the Configuration Manager generates a corresponding connection string in the Connection String pane. To use your connection string, click the Copy button () and paste the string to a location that can be used by your application. See "Generating connection strings with the Configuration Manager" for details.
Note: Connection string attributes can be used to override the default values of the data source if you want to change these values at connection time.

To configure and test a data source:

  1. Open the Google Analytics 4 Configuration Manager by selecting ODBC Administrator from the Progress DataDirect program group.
  2. Select a tab:

    • User DSN: If you are configuring an existing user data source, select the data source name and click Configure to display the Configuration Manager dialog.

      If you are configuring a new user data source, click Add to display a list of installed drivers. Select the driver and click Finish to display the driver Setup dialog box.

    • System DSN: If you are configuring an existing system data source, select the data source name and click Configure to display the driver Setup dialog box.

      If you are configuring a new system data source, click Add to display a list of installed drivers. Select the driver and click Finish to display the driver Setup dialog box.

    • Note: Configuring an existing or new file data source using the File DSN tab is not currently supported with the configuration manager.
    The Google Analytics 4 Configuration Manager window opens.
  3. From the Configuration Manager window, provide values of the connection options you want to configure in the corresponding fields. To view more options, select the tabs at the top of the page. See "Connection option descriptions" for descriptions of the supported options.
    Note: See "Connection string examples" for a list of required options used for different configurations. The options and settings described in that section apply to all methods of configuration.
  4. Define the tables in the relational schema of your Google Analytics data.

    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. 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 Add Tables field 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 Default Query Options field is populated with parameters used for WHERE clause filtering.
  5. At any point during the process, you can click Test Connect to attempt to connect to the instance with your settings. In the Test Connection window:
    1. Provide values for any fields required by your instance. Note that the information you enter in the logon dialog box during a test connect is not saved.
    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.
  6. Click Save to apply your values as the default when connecting with the data source.