Was this page helpful?
Yes No
Tableau Help > Tableau Server on Windows Help > 

Collect Data with the Tableau Server Repository

Before you start analyzing the resource usage data that Windows Performance Monitor (PerMon) collects, connect to the Tableau Server repository to get additional data about load times and background tasks. The Tableau Server repository is a PostgreSQL database that stores data about all user interactions, extract refreshes, and more.

After you enable access to the Tableau Server repository, you can create views with data from the repository. The views that you create with this data are sometimes called custom administrative views. In addition to being used for performance monitoring, custom admin views can be used for tracking user activity, workbook activity, and more. For more information on the type of data that you can use for these views, see Create Custom Administrative Views and Workgroups Database. Alternatively, if you are only interested in performance data, you can use the preselected database tables in the sample performance workbook. For more information about the sample performance workbook, see Analyze Data with the Sample Performance Workbook.

Enable access to the Tableau Server repository

To access the Tableau Server repository, you need to enable access to the database by using tabadmin commands.

  1. Open a command prompt as an administrator and type the following:

    cd "C:\Program Files\Tableau\Tableau Server\2018.1\bin"

  2. Enter the following command to enable external access to the database for the tableau user or the readonly user:

    tabadmin dbpass --username [tableau|readonly] password

    For example, to enable access for the readonly user with a password of p@ssword, use this command:

    tabadmin dbpass --username readonly p@ssword

    Note: If no user is specified, the dbpass command enables access for the tableau user.

  3. Restart Tableau Server by using this command:

    tabadmin restart

Note: If you later decide that you want to disable remote access to the Tableau Server repository, use the tabadmin dbpass --disable command. The --disable option disables external access to the repository. This will not disable access from localhost. For more information, see tabadmin Commands

Connect to the Tableau Server repository

This section describes how to connect to a custom set of tables from Tableau Server repository. If you want to use the sample performance workbook, see Analyze Data with the Sample Performance Workbook and follow the steps to edit the connection information. Alternatively, for more information on the tables that you can connect to, see Workgroups Database.

  1. In Tableau Desktop select Data > Connect to Data, and then select PostgreSQL as the database to connect to.

    Note: You might need to install the PostgreSQL database drivers. You can download drivers from www.tableau.com/support/drivers.

  2. In the PostgreSQL connection dialog box, enter the name or URL for Tableau Server in the Server box. If you have a distributed server installation, enter the name or IP address of the node where the repository is hosted.

    Connect using the port you have set up for the pgsql.port, which is 8060 by default.

    Note: The tabadmin dbpass command does not open any ports in the firewall. You may need to manually open the port in any firewall between your external client and the Tableau Server database.

  3. Specify workgroup as the database to connect to.

  4. Connect using the user and the password you specified.

  5. Click Connect.

  6. Select one or more tables to connect to.

    The tableau user has access to all of the tables that start with an underscore or with hist_. For example, you can connect to _background_tasks and _datasources. The hist_ tables include information about server users that isn't currently presented in the Actions by Specific User view. The readonly user has access to additional tables that can be used to query other information about server usage.

  7. Click Go to Worksheet.