Tableau

Version:

2023.1

Last modified: July 19, 2023

Connection Type	Alteryx Tools (older versions available from the Alteryx Community)
Type of Support	Read/Write/Publish
Validated On	Tableau SDK 10.3 (Spatial support)

Release Notes

Version	Description
v1.3.1	Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later. Requires AMP engine. Alteryx Server requires stored credentials in DCM to run workflows. Fixed issue where Tableau Output wrote Null values as “nan” for float data types. (TPM-2210) Known Issues The tool becomes unstable when uploading dataset larger than 3GB. (TPM-2121) The refresh button isn’t working for either the Tableau Output or Tableau Input tool. (TFLN-1436)
v1.3.0	Compatible with Alteryx Designer and Server 2021.4.2 Patch 6, 2022.1 Patch 4 and later. Added new Tableau Input tool to read data from HYPER data sources. Live data sources aren’t supported. Only data sources created with the Tableau Output tool are supported for reading. Requires AMP engine. Alteryx Server requires stored credentials in DCM to run workflows. Fixed issue where NULL numeric values were converted to 0. (TPM-1546) Tableau shows NULL numeric values as 0 by default on dashboards. Fixed issue where NULL string values were converted to empty string. (TPM-1528) Fixed issue where DATE was converted into STRING. (TPM-2138) Fixed issue where Designer ran indefinitely or crashed when DCM was used. (TPM-1986) Fixed issue with error “The system could not find the path specified” when multiple Tableau Output tools were used on canvas. (TPM-1915) Known Issues Tool becomes unstable when uploading dataset larger than 3GB. Refresh button is not working for either the Tableau Output or Tableau Input tool.
v1.2.0	Compatible with Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later. Requires AMP engine. Added support for DCM. DCM is required for running this connector on Alteryx Server. Added support for SpatialObj. SSL/TLS validation is now performed against Windows Certificate Store. FIPS capable. Known Issues Alteryx Server requires the AllowAll value of the SDK Access Mode settings. NULL values are converted to 0.
v1.1.1	Fixed issue with conversion of boolean and datetime fields.
v1.1.0	Added support for Tableau Server On-Premise (Tableau Server 2019.2 or later required).
v1.0.1	Compatible with Alteryx Designer version 2021.3 and later. Initial release. Username and Password and Personal Access Token are supported authentication methods. Create, Overwrite, Append, Update or Upsert multiple tables in a dataset. Post SQL support. Proxy support. Conversion from WKT to Spatial object support. Known limitation: v1.0.1 does not support Tableau Server On-Premise. When working with multiple tables, a .tds file has to be provided (can be obtained from Tableau Desktop)

Alteryx Tools Used to Connect

Link

Input Data Tool

Link

Output Data Tool

Link

Tableau Input Tool

Link

Tableau Output Tool

Link

Publish to Tableau Server Tool

Input Data tool reads data as a Tableau Hyper data extract (HYPER) file. This tool supports only local files.
Output Data tool saves data as a Tableau data extract (TDE) or Tableau Hyper data extract (HYPER) file. This tool supports only local files.
Tableau Input Tool reads data from a Tableau Hyper dataset created with the Tableau Output tool.
Tableau Output tool creates a Tableau Hyper dataset and uploads it to the Tableau server or saves it locally as a Tableau Hyper data extract (HYPER) file.
Publish to Tableau Server tool is deprecated. Functionality was replaced by Tableau Output tool.

Data Connection Manager

The Tableau tools version 1.2.0 and later support Data Connection Manager for an easier and a safer storage of your credentials. Create a connection to Tableau and easily reuse the stored credentials in workflows that include the Tableau tools. Alteryx Server requires stored credentials to successfully run the published workflows.

Enable AMP Engine

Make sure you have the AMP engine enabled for the workflows which contain the Tableau tools version 1.2.0 and later.

Limitations

Tableau doesn’t support single sign-on or multi-factor authentication. Only sign in using username and password or personal access tokens is supported. Personal access tokens are long-lived authentication tokens that allow you to run automation with Tableau REST APIs without requiring hard-coded credentials or interactive login.

Tableau Output Tool Search

You can only search in full names, so you need to provide 'datasource name' instead of just 'name'.

Text Fields Read in as V_WString with the Maximum Size

Since Designer version 2021.2, text fields read in .hyper files as V_WString with the max size to avoid data loss. To work around, you can use the Auto Field or Select tool before writing the data to any other format.