Tableau GUI is Tableau on Hermes

Tableau is no longer self hosted. We use Tableau Cloud now

Diagram.net overview

Tableau is divided into a number of sites. Tableau Manage Sites

Each site represents in our case a customer group. The current sites are

• ATC Prod
• ATC QA
• Default
• Demo
• ExteNet Prod
• ExteNet QA

Sites are limited as each site account requires a Tableau license.

Sites are constructed of two levels for permissions

• Group - A group is simply a collection of users
• Users - A user is logged in with a password to the tableau server.

We only have 1 user each for ExteNet and ATC.

• ExteNet - user reports@extenetsystems.com
• ATC - user reports@atc.com
• Demo - users are errigal_reports and demo

Schedules can be viewed under the Schedules option within each site. Note they are site specific so even if two sites use the same data set, two schedules one per site are required

Extracts available at Extract Refreshes

And can been seen here

The Tableau Cloud bridge is software that runs on a server in our private network, that establishes a private connection to databases within our network. Currently, the bridge runs on tableaubridge.err and is deployed and configured using the deploy-tableau-bridge.yml playbook in the deployment playbooks repo. The roles/tableau-bridge-setup/README.md file has all the details to deploy or reconfigure.

To allow a workbook to use a bridge extract, follow these steps.

• Settings > Bridge

• Open workbook > Server > Publish Data Source > Select data source used by workbook
• Activate extract
• Change name and location if necessary > Publish > Yes to embed the password
• Tableau Cloud will open in the browser once finished and offer to set up a refresh schedule which should be done. Once per day is good, after key stats is finished. I selected daily at 13:00 GMT

• Data > New Data Source > Tableau Server
• Select newly created bridge extract > Connect
• In the workbook, open up a sheet that uses the data
• Right click on the old datasource on the left > Replace Data Source
• Check the current one is being replaced with the new bridge > OK
• Delete the old connection > right click > Close
• Save current workbook

Remember to sudo su tableau user for all commands Get a list of active licenses tsm licenses list Get the available license key off the Tableau website Customer Portal Tableau To activate the above key, the command on the Hermes server is tsm licenses activate -k TS37-6BF5-DB00-473F-E5D8 The output is License key activated. Restart server to apply updated licensing details. The restart command will be **However this wasn't required tsm restart