Collect Data with the Tableau Server Repository
Before you start analyzing the resource usage data that Windows Performance Monitor (PerfMon) 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 Workgroup Database. Alternatively, if you are only interested in performance data, you can use the preselected database tables in the sample performance workbook.
To access the Tableau Server repository, you need to enable access to the database by using tabadmin commands.
- Open a command prompt as an administrator
and type the following:
cd "C:\Program Files\Tableau\Tableau Server\10.5\bin"
Enter the following command to enable external access to the database for the
tableauuser or the
tabadmin dbpass --username [tableau|readonly] password
For example, to enable access for the
readonlyuser with a password of
p@ssword, use this command:
tabadmin dbpass --username readonly p@ssword
Note: If no user is specified, the
dbpasscommand enables access for the
Restart Tableau Server by using this command:
Note: If you later decide that you want to disable access to the Tableau Server repository, use the
tabadmin dbpass --disable command. For more information, see tabadmin Commands
This section describes how to connect to a custom set of tables from Tableau Server repository.
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.
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
dbpasscommand 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.
workgroupas the database to connect to.
Connect using the user and the password you specified.
Select one or more tables to connect to.
tableauuser has access to all of the tables that start with an underscore or with
hist_. For example, you can connect to
hist_tables include information about server users that isn't currently presented in the Actions by Specific User view. The
readonlyuser has access to additional tables that can be used to query other information about server usage.
Click Go to Worksheet.