IMPORT DATA TO TABLEAU
1. In Datatap
- Go to stream which should be visualised in Tableau
- Click on Passive Destination
- Choose the time range that you want to see visualised
- Copy access link
Please note: The time range refers to the scheduled date of an extract.
The scheduled date refers to the earliest date contained within an extract, e.g. for an extract which contains 30 days, it will indicate the first day as in the example below.
To find the scheduled date, look into the meta data section of the extract.
2. In Tableau
- Go to Connect menu, select Web Data Connector, paste access link, press enter
- Use Datatap credentials to login and access the data through Tableau
- Use option update data automatically within Tableau to make sure that refreshes happen automatically as soon as new is fetched. If this is not used, then you would need to refresh the table when returning to Tableau as needed.
- Tableau is considered a passive destination.
- Tableau will only consider extracts with Status:Collected or Status: Imported for data retrieval.
- Schema Mapping is necessary for each datastream so that Tableau can recognise column names and data types correctly.
- Current limit of extracts that can be visible in Tableau is 100 (effective from 07 AUG 2019)