User Tools
toolsandtechnologies:tableau
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| toolsandtechnologies:tableau [2023/06/17 21:05] – [Tableau Reporting] - added architecture overview aryan | toolsandtechnologies:tableau [2025/02/25 11:19] (current) – 10.91.120.100 | ||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ====== Tableau Reporting ====== | ====== Tableau Reporting ====== | ||
| - | Tableau GUI is [[http:// | + | <del>Tableau GUI is [[http:// |
| + | |||
| + | Tableau is no longer self hosted. We use [[https:// | ||
| Line 11: | Line 13: | ||
| ===== Sites ===== | ===== Sites ===== | ||
| - | Tableau is divided into a number of sites. [[http://hermes.err/#/server/ | + | Tableau is divided into a number of sites. [[https://eu-west-1a.online.tableau.com/#/site| Tableau Manage Sites]] |
| Each site represents in our case a customer group. The current sites are | Each site represents in our case a customer group. The current sites are | ||
| Line 22: | Line 24: | ||
| * ExteNet QA | * ExteNet QA | ||
| - | Legacy Sites exist with no users other than the Admin user, which must be a member of every site | ||
| - | |||
| - | * CCQA | ||
| Sites are limited as each site account requires a Tableau license. | Sites are limited as each site account requires a Tableau license. | ||
| Line 51: | Line 50: | ||
| 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 | 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 | ||
| - | eg Extenet' | + | Extracts |
| And can been seen here | And can been seen here | ||
| {{: | {{: | ||
| + | ===== Bridge Extracts ===== | ||
| + | |||
| + | 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/ | ||
| + | |||
| + | To allow a workbook to use a bridge extract, follow these steps. | ||
| + | |||
| + | ==== Make sure bridge is up ==== | ||
| + | * Settings > Bridge | ||
| + | {{: | ||
| + | |||
| + | ==== Publish datasource from Tableau desktop to cloud to extract through the Tableau 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 | ||
| + | ==== Add newly published extract source to the workbook as a live connect ==== | ||
| + | * 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 | ||
| ===== Licenses ===== | ===== Licenses ===== | ||
| + | <del> | ||
| **Remember** to sudo su tableau user for all commands | **Remember** to sudo su tableau user for all commands | ||
| Line 65: | Line 88: | ||
| Get a list of active licenses | Get a list of active licenses | ||
| - | <wrap em>tsm licenses list </ | + | tsm licenses list |
| Get the available license key off the Tableau website [[https:// | Get the available license key off the Tableau website [[https:// | ||
| Line 72: | Line 95: | ||
| To activate the above key, the command on the Hermes server is | To activate the above key, the command on the Hermes server is | ||
| - | <wrap em>tsm licenses activate -k TS37-6BF5-DB00-473F-E5D8</ | + | tsm licenses activate -k TS37-6BF5-DB00-473F-E5D8 |
| The output is | The output is | ||
| - | <WRAP center round box 60%> | ||
| License key activated. | License key activated. | ||
| Restart server to apply updated licensing details. | Restart server to apply updated licensing details. | ||
| - | </ | ||
| The restart command will be **However this wasn't required | The restart command will be **However this wasn't required | ||
| - | <wrap em>tsm restart</ | + | tsm restart |
| + | </del> | ||
toolsandtechnologies/tableau.1687032327.txt.gz · Last modified: 2023/06/17 21:05 by aryan
Page Tools
