Tableau is a data visualization tool used for data analysis and business intelligence
Limit of Data Records
When sending your data to Tableau, be aware that although it can handle a large amount of data, it has a limit of how much data it can connect at once. If you see the error or notice a significant decrease in performance and load time, it usually means that you have too much data in the source you are trying to connect and the connection timeouts due to the size.
You can see how much data is in the source by clicking Data Preview (three dots next to the source under Sources) and the total number of records is shown in the top left.
- you can either limit the amount of data (it is possible the amount is this huge because of incorrect snapshotting settings)
- or connect the data to a data warehouse instead and then to Tableau. One option is to use Google Sheets.
How to Connect Tableau
Step 1 - Create Tableau Data Destination
- Sign in to your Dataddo account and click on Destinations at the top of the page.
- Click on Create Destination in the top right corner.
- From the list of destinations, choose Tableau. You can type the name of the connector into the search bar to find it faster.
You will be redirected to the New Flow configuration.
Step 2 - Create a New Data Flow
- Click on Flows at the top of the page.
- Click on Create Flow in the top right corner.
- Click on Add Source and choose, which from your sources you want to connect. You can type the connector's name into the search bar to find it faster.
NOTE: You can add more sources or blend two of the sources. Read more about Data Blending here.
Once you select your data source, click on Add Destination. If you continued from the source creation, Tableau has been selected as a destination automatically.
- You can Name your flow by typing the name into the top.
- You can see a Data Preview to make sure of your configuration.
- Click on Save flow.
How to Configure the Data Flow
- Click on the three dots next to the flow and choose Config.
- A configuration window will appear.
Log into Tableau Desktop app, go to the Web Data Connector and copy/paste the URL into the address bar.
- Close the window in Dataddo.
Using Tableau Bridge
According to Tableau's official documentation, only Web Data Connectors with a standard username and password authorization are supported for the automatic sync via Tableau Bridge. This, however, does not comply with our extensive security policy (using OAuth mechanism), therefore you have to use one of the following workarounds to archive data refresh:
- Use the Tableau Desktop Refresh From Source command, or run a manual refresh from Tableau Desktop.
- Use intermediate data storage that can Tableau Bridge directly connects to (e.g. Google Sheets, BigQuery, or MySQL).
- Use Tableau Server and whitelist Dataddo WDC.
Using Tableau Server
You might be experiencing the error "Unknown Failure (status Code = 11000 Web data connector is not whitelisted)" when refreshing Web Data Connector via Tableau Web Server. To address this issue, please add Dataddo WDC to your safe list and secondary safe list. To add a connector to the safe list and secondary safe list, use the tsm data-access web-data-connectors add command, providing the name, safe list URL, and secondary safe list URLs. You can also manage WDCs using the web-data-connector-settings Entity. After running this command, you need to apply your pending changes using the tsm pending-changes apply command. A prompt will warn you that the command will restart the Tableau Server. If Tableau Server is currently running it will be restarted, and if it is stopped it will be left in a stopped state with no restart.
tsm data-access web-data-connectors add --name "DATADDO WDC" --url https://app.dataddo.com/utils/tableau/ --secondary https://app.dataddo.com/(.*)
Find more details on Tableau's official documentation.