As an administrator of Tableau Server, you’re granted access to six dashboards that show a variety of server activity/performance/utilization information. These dashboards are connected to Tableau’s internal PostgreSQL database. What if you’d like other server users to access these admin dashboards but you do not want to grant those users Administrative rights? There are four easy steps to accomplish this.
- Create a PostgreSQL password
- Find and copy the tabbed_admin_views workbook
- Open workbook and update database connections with your server and password
- Publish workbook
- Log onto your machine that runs Tableau Server and in Command Line navigate to the bin folder
- Type tabadmin db pass [password] (in version 9, “dbpass” is one word)
- For [password] input your desired password
- Type tabadmin configure
- Type tabadmin restart
You’ve now set a password to the internal PostgreSQL database. You’re free to connect to it from a new workbook and poke around. Note, if you have not done so, you’ll need to install PostgreSQL database drivers.
Thank you Adolph Barclift, DC-VA Tableau User Group Co-Chair for the assistance on this step.
While logged in to your machine running Tableau Server, open folder …Tableau\Tableau Server\[version]\wgserver\z5\WEB-INF\admin
Make a copy of the tabbed_admin_views.twb and save to desired location.
Open the workbook and click OK when prompted to log in, you’ll get an error and click Yes to edit the connection.
Complete the connection dialog with your credentials. Port, Database and Username should remain unchanged.
This workbook has eight separate connections so you’ll have to repeat the process seven more times.
Publish workbook, embedding credentials, and set your security as desire.
Congratulations! You now have your own administrative dashboards. What’s even better is that you can create custom admin dashboards! Check out Russell Christopher’s series on Tableau History Tables for more details on PostgreSQL schema.