Tableau is another BI Tool which is used in the Council. Mostly by Public Health.
Who is this for?
This is for users of Tableau who to connect to Datasets within the Data Platform for Analysis, specifically through Redshift.
- Tableau Desktop does not connect directly with the Data Platform as it is downloaded to an individual device.
- The workaround for this is to create a data extract in Tableau Online as a Tableau Data Source (Hyper) and connect to that.
- The required data is available in Redshift.
- A Tableau Online account with a creator licence.
- You have access to your departments credentials consisting of
- Server Address: which comes as a Host Name or IP Port
- Port: A 4 digit number
- Database Name
Retrieving your Credentials
- Login to your AWS Account here and make sure you are on the correct account
- Using the search bar, search for
Secrets Managerand go to the
- In the Secrets Manager, you should be able to see a list of
description. In the search bar, search for
redshiftand select your department.
- Scroll down and look for a section called
Secret Value. On the right, click
[Retrieve Secret Value]
What should you do if you cannot see your relevant department
Contact somebody from the Data Platform to set up credentials to be used in Redshift for your department.
You can contact the Data Platform at
These are the credentials you will need to connect to Redshift in Tableau or any other BI Tool.
Connect to your data in Redshift using Tableau Online
- Navigate to the Data Tab of your
Flow, and select
Connect to Dataor
New Data Source.
- If you are creating a new Workbook or Flow from scratch, you will be taken there first
- You will be given the option of filling in the connection fields using values retrieved from the Secrets Manager:
- Server: use the Host Name or IP Value (e.g. 18.104.22.168)
- Port: 5440 (5439 for Staging)
- Database: data_platform
- Username: Use the username field (e.g. planning)
- Password: Copy from the password field (this will be a random alphanumeric string)
- Require SSL - Keep this box ticked
- Once these fields are filled in, click the sign-in box to make the connection
Connecting to Data with Tableau Desktop
Current security configurations do not allow live connections to the platform from individual devices.
If you prefer to develop dashboards locally using Tableau Desktop and require data from the platform, we recommend making the connection using Tableau Online and storing this as a Hyper Extract.
- Create the connection to Redshift as above
- On the Data Source page, change the Connection from
Extractand then select
- From the
Datamenu (top left), select the Data Source you’ve just created and
Save As Published Data Source. Check the
Embed Credentialsbox and save to a relevant folder within Tableau Online.
- (Optional) navigate to the location of your newly published data source and create a refresh schedule task.
Open Tableau Desktop on your local Machine.
- Use the
Tableau Serveroption in the
Connect to DataScreen
- Login and Authenticate with your Tableau Online credentials
- Browse for your published Data Source and Connect.