Tableau

Connection Type	Alteryx Tools. The latest version is available from the Alteryx Marketplace.
Type of Support	Read/Write/Publish
Validated On	Tableau SDK 10.3 (Spatial support)

Release Notes

Version	Description
v1.4.2	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 didn’t properly update or upsert data if workflow included more than 1 Tableau tool. (TPM-3725) Fixed issue where Tableau Output couldn’t properly write DateTime values. (TPM-3715) Fixed issue where Tableau Input duplicated data and overwrote columns. (TPM-3524) Improved the performance of Tableau Output. (TPM-3455) Fixed issue where the Tableau tools ignored proxy settings. (TPM-3353) Fixed issue where the Tableau tools couldn’t properly read or write Blob data. (TPM-2649)
v1.4.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. Removed usage of .shiv folder. Fixed issue where Tableau Output returned "'NoneType' object has no attribute 'dtypes'" error when writing date fields with a future year. (TPM-3246) Fixed issue where Tableau Output didn’t properly update the Project Name field when mapped to an interface tool in a macro or analytic app. (TPM-3245) Fixed issue where Tableau Output returned "Got an invalid value" error for a mix of data types. (TPM-2968) Fixed issue where Tableau Output failed to upsert data when it contained no new rows to insert. (TPM-2531) Fixed issue where Tableau Output showed blank configuration panel when the user’s Tableau instance didn’t contain any data sources. (TFLN-1881) Fixed the "Must pass at least one table" error on Tableau Output. (TDCE-302) Fixed issue where Tableau Input returned "'NoneType' object has no attribute ‘year’" error when reading Date or DateTime data types. (TDCE-293) Fixed issue where Tableau Output failed to create TDSX file when it was over certain size. (TDCE-186)
v1.4.0	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. Improved write performance of Tableau Output. Fixed issue where the refresh button in Project and Data Source browsers didn’t work. (TFLN-1436) Fixed issue where Tableau Output became unstable when uploading dataset larger than 3GB. (TPM-2121)
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. (TPM-2121) Refresh button is not working for either the Tableau Output or Tableau Input tool. (TFLN-1436)
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

Input Data Tool	Output Data Tool Output Data Tool
Tableau Input Tool	Tableau Output Tool
Publish to Tableau Server Tool

Important

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 Hyper data extract (HYPER) file. This tool supports only local files.
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 the Tableau Output tool

Data Connection Manager

The Tableau tools version 1.2.0 and later support Data Connection Manager for easier and 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.

API Access

The Tableau tools require API access to your Tableau instance. For the Tableau tools to work properly, check with your Tableau admin to ensure that CORS is enabled on your instance and the file:// value is added to the allowed hosts.

Limitations

Login Options

Tableau doesn’t support single sign-on or multi-factor authentication. Only sign in using a 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 a 'datasource name' instead of just a '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.

Limited Usage of Tableau Tools with a Personal Access Token

It's not possible to run multiple Tableau tools concurrently using the same Personal Access Token because of a Tableau limitation where users can't request concurrent Tableau Server sessions with a single Personal Access Token. Attempts to sign in to concurrent sessions using the same Personal Access Token will cause the previous session to be terminated and may result in authentication errors. For more information, see Tableau's Help documentation on Personal Access Tokens.

In this section: