Smarter ideas worth writing about.

Tableau Server Audit Database Configuration

As a Tableau server administrator, it is always necessary to have some sort of auditing system put in place to keep track of performance, user activity, storage, etc. When acquiring Tableau server you also obtain the back-end PostgreSQL database. This database is used specifically for auditing purposes as well as auditing dashboards that live on the Tableau Server admin page. Tableau Server comes with an auditing dashboard but also allows for the creation of customized dashboards. 

Configuring Access to PostgreSQL Database

In order to access the auditing database, configurations via Tabadmin will have to be set up. Tabadmin is Tableau’s command line utility used for administrative tasks and altering configurations in Tableau Server. To initiate this process, navigate to the bin folder in your Tableau Server folder or wherever it was installed using command prompt. 

Example
cd C:\Program Files\Tableau\Tableau Server\9.0\bin

After navigating to the bin folder, tabadmin can be used by prefixing scripts with “tabadmin." This is where configuration to the Postgres database will be set up using the following script:

tabadmin dbpass –-username tableau @password

The only two available usernames that can be used to access the database are tableau and readonly. In the script above, a password to the tableau username will need to be assigned using dbpass command. Once the command has successfully ran, access will now be available to the auditing database. The connection screen to the auditing database will look like the screenshot below. Since it’s on the server the user can just key in localhost while leaving the port at 8060 which is the PostgreSQL database port. The views will reside in the “workgroup” database. Lastly, type in the credentials that was created using tabadmin dbpass.

Auditing Database

By default, Tableau Server will come with 18 pre-defined views in PostgreSQL used for analysis on your server. Analysis can be done by putting Tableau on top of the PostgreSQL database and pulling in the pre-defined views. 

There are options available to track storage, allocate space, or examine user activity among the various workbooks. In my experience, I have found that tracking all of this information is extremely helpful. This information has led to administrators being able to pinpoint issues with extracts including, failed extracts or processes taking too long. Tableau Administrators can use this to their advantage as it will increase visibility within the Tableau Server realm. 

Share:

About The Author

BI Developer

Justin is an experienced Business Intelligence Developer who has a focus on data visualization and back-end data development.