Skip to main content

Tableau

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)

Version

Description

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

Input Data Tool Icon

Link

Output Data Tool

Output Data Tool Icon

Link

Tableau Input Tool

Tableau Output Tool

Link

Tableau Output Tool

Tableau Output Tool

Link

Publish to Tableau Server Tool

Publish to Tableau Server Tool Icon

Link

Important

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.

Limitations

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.

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

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.