Tableau

Version:
2023.1
Last modified: June 06, 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.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 Icon

Input Data Tool

Link
Output Data Tool Icon

Output Data Tool

Link
Tableau Output Tool

Tableau Output Tool

Link
Publish to Tableau Server Tool Icon

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 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.

     

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

Login Options

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.

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.