Tableau Output Tool

Use Tableau Output to write data from Designer to Tableau. Go to Tableau to learn about known limitations. More information about Tableau can be found on the Tableau Help site.

Note

This tool is not automatically installed with Designer. To use this tool, download it from the Alteryx Analytics Gallery.

Sign In to Tableau

Tableau Output comes with standard authentication using Username and Password, and extended authentication using Personal Access Token.

To schedule your workflow, we recommend selecting the Personal Access Token authentication method and entering the details of your personal access token. Create personal access tokens in Tableau’s My Account Settings and enter the details when logging in to the Tableau Output.

Username and Password

  1. In Authentication Method, select Username/Password.

  2. Enter Server URL, Site, Username, and Password.

  3. Select Connect.

Personal Access Token

  1. In Authentication Method, select Personal Access Token.

  2. Enter Server URL, Site, Token Name, and Token Secret. If you are using Tableau Server On-Premise and you would like to use the default site, you have to leave Site blank.

Create Local Output

You can select Local Output to create output of the data on your machine in a Hyper file. This option doesn’t require any authentication. In Path, enter the full path of the destination file.

Select Data Source

  1. Select the Project. You can filter by Favorites or Owner. Selecting a project filters the data source to those available in the selected project. Due to the Tableau's API, Designer flattens the projects into a single list.

  2. Select the Data Source. You can filter by Favorites, Tags, or Owner.

Warning

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

Select Output Option

The following options define the operation for the whole data source. However, Designer performs the operation at the table level. For example, you can’t append data to one table and overwrite another table, but you can append data to one table and ignore the rest of the tables.

  • Create: Creates a new table.

  • Overwrite: Clears the existing table and populates the table with new data.

  • Append: Adds the data to the existing table.

  • Update: Modifies existing records with new data based on the columns selected in Select Primary Columns.

  • Upsert: Modifies existing records with new data based on the columns selected in Select Primary Columns. If a record is not found, adds the data to the table.

If the data source contains more than one table, you have to add Data Source Metainfo from a TDS file. For more information about the TDS files and how to obtain it, go to Save Data Sources.

You can select to Encrypt at Rest to secure Hyper extracts stored on Tableau Server. For more information, see Extract Encryption at Rest.

You can enter an SQL command in the Post SQL section. Designer applies this command to the created or updated Hyper file before uploading it to Tableau Server.

Select Spatial Columns

Select the columns containing spatial data in the Well Known Text format to transform them into spatial data type.