Note: Before you start, you will need to know the value of the AddTables property that is used to define your schema. You will still be able to connect without specifying a value, but you will not be able to query your data. You can generate a value for the property using the Configure Logical Schema tool in the Configuration Manager. See Generating connection URLs with the Configuration Manager for details.

To add a driver with DbVisualizer:

  1. Open DbVisualizer.
  2. From the menu, select Tools>Driver Manager. The Driver Manager window opens.
  3. From the Driver Manager menu, select Driver>Create Driver.
  4. Click the button to navigate to the location of the driver jar file; then, click OK. The following are the default locations for the driver:

    Windows

    C:\Program Files\Progress\DataDirect\JDBC\lib\60\googleanalytics4.jar

    Linux

    /opt/Progress/DataDirect/JDBC/lib/60/googleanalytics4.jar
  5. Provide values for the following fields; then, close the Driver Manager window.
    • Name: Type an alias for your driver. For example:
      Google Analytics 4
    • URL Format: Optionally, specify the format of the connection string for your driver. For example: 
      jdbc:datadirect:googleanalytics4:DefaultQueryOptions=startDate=20daysAgo;currencyCode:USD
    • Driver Class: From the drop-down menu, select the driver class for your driver:
      com.ddtek.jdbc.googleanalytics4.GoogleAnalytics4Driver
You can now use your driver with DbVisualizer. Proceed to "Connecting and executing SQL statements" for information on connecting and executing SQL statements.