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.

After you have installed your driver and defined it on the CLASSPATH, you can use the driver to access your data with Tableau. Tableau is a business intelligence software program that allows you to easily create reports and visualized representations of your data. By using the driver with Tableau, you can improve performance when retrieving data while leveraging the driver's relational mapping tools.

To use the driver to access data with Tableau:

  1. Navigate to the \lib\xx subdirectory of the Progress DataDirect installation directory; then, locate the jar file for your driver: 
    googleanalytics4.jar
  2. Copy the .jar file for your driver into the following directory:

    Windows: C:\Program Files\Tableau\Drivers

    Linux: /opt/tableau/tableau_driver/jdbc

  3. Open Tableau. From the Connect menu, select Other Databases (JDBC).
  4. In the Other Databases (JDBC) dialog, provide values for the following fields; then, click Sign In.
    • URL: Copy and paste your connection URL into this field. The following examples show how to connect using OAuth 2 authentication with a refresh token.
      jdbc:datadirect:googleanalytics4:AddTables='{myTableDefinitionString}';
ClientID=client_id.apps.googleusercontent.com;
ClientSecret=client_secret;RefreshToken=refresh_token;
      Note: See OAuth 2.0 Authentication for details.
    • Dialect: Select SQL92 (the default) from the drop-down box.
  5. The Data Source window appears. In the Schema field, select the schema for the service you want to use.
  6. In the Table field, the tables stored in the selected schema are now exposed and available for selection.
You have successfully accessed your data and are now ready to create reports with Tableau. For detailed information, refer to the Tableau product documentation at: https://www.tableau.com/support/help.