Skip to main content

[en] Tableau

[en] Connection Type

[en] Alteryx Tools (older versions available from the Alteryx Community)

[en] Type of Support

[en] Read/Write/Publish

[en] Validated On

[en] Tableau SDK 10.3 (Spatial support)

[en] Version

[en] Description

[en] v1.2.0

  • [en] Compatible with Alteryx Designer and Server 2021.4.2 Patch 4, 2022.1 Patch 2 and later.

  • [en] Requires AMP engine.

  • [en] Added support for DCM.

    • [en] DCM is required for running this connector on Alteryx Server.

  • [en] Added support for SpatialObj.

  • [en] SSL/TLS validation is now performed against Windows Certificate Store.

  • [en] FIPS capable.

[en] Known Issues

  • [en] Alteryx Server requires the AllowAll value of the SDK Access Mode settings.

  • [en] NULL values are converted to 0.

[en] v1.1.1

  • [en] Fixed issue with conversion of boolean and DateTime fields.

[en] v1.1.0

  • [en] Added support for Tableau Server On-Premise (Tableau Server 2019.2 or later required).

[en] v1.0.1

  • [en] Compatible with Alteryx Designer version 2021.3 and later.

  • [en] Initial release.

  • [en] Username and Password and Personal Access Token are supported authentication methods.

  • [en] Create, Overwrite, Append, Update, or Upsert multiple tables in a dataset.

  • [en] Post SQL support.

  • [en] Proxy support.

  • [en] Conversion from WKT to Spatial object support.

[en] Known limitation:

  • [en] v1.0.1 does not support Tableau Server On-Premise.

  • [en] When working with multiple tables, a .tds file has to be provided (can be obtained from Tableau Desktop)

[en] Alteryx Tools Used to Connect

[en] Input Data Tool

Input Data Tool Icon

[en] Link

[en] Output Data Tool

Output Data Tool Icon

[en] Link

[en] Tableau Output Tool

Tableau Output Tool

[en] Link

[en] Publish to Tableau Server Tool

Publish to Tableau Server Tool Icon

[en] Link

重要

  • [en] Input Data tool reads data as a Tableau Hyper data extract (HYPER) file. This tool supports only local files.

  • [en] Output Data tool saves data as a Tableau data extract (TDE) or Tableau Hyper data extract (HYPER) file. This tool supports only local files.

  • [en] 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.

  • [en] Publish to Tableau Server tool is deprecated. Functionality was replaced by the Tableau Output tool.

[en] Data Connection Manager

[en] 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.

[en] Enable AMP Engine

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

[en] Limitations

[en] 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.

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

[en] 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.