In this article

Overview

You can use this Snap to write data files to the Tableau server.

  • This Snap Pack has been implemented against & verified with the 9.1 version of Tableau server. 
  • To use this Snap, the Tableau libraries must be available on the Windows-based Snaplex nodes. This means that the Tableau server must have been installed on the server and be available to the Snaplex process. Where the Tableau server has not been installed, any attempted use of the Snap will cause exceptions to be thrown, error messages will be generated.
  • This Snap is not compatible with Linux Snaplexes.

Prerequisites

None.

Support for Ultra Pipelines

Works in Ultra Task Pipelines. 

Limitations

None.

Snap Input and Output

Input/OutputType of ViewNumber of ViewsExamples of Upstream and Downstream Snaps
InputDocument
  • Min:1
  • Max:1
  • CSV Parser
  • Copy
OutputDocument
  • Min:0
  • Max:1
  • Mapper
  • Copy

Snap Settings

Field Name

Field Type

Description


Label*

String

Specify the name for the Snap. You can modify this to be more specific, especially if you have more than one of the same Snap in your Pipeline.

Default Value: Tableau Write
Example: Tableau_Write

Datasource

String

Specify the Tableau datasource name on the server. If left empty, the name defaults to the current date and time. 

Default Value: N/A
Example: Annual Sales

Project

String

Specify the name of the folder on the Tableau server where the data will be written/extracted. This field can also be set as an expression.

Default Value: N/A
Example: Sales Analytics Project

Overwrite
 		Checkbox

Select this checkbox to overwrite an existing datasource with the same name. See https://onlinehelp.tableau.com/current/server/en-us/tabcmd_cmd.htm for more information.

Default Value:  Not selected

Append


Checkbox

Select this checkbox to append the extract file to the existing data source.  See https://onlinehelp.tableau.com/current/server/en-us/tabcmd_cmd.htm for more information.

Default Value:  Not selected 

No Cert Check


Checkbox

Select this checkbox to ignore server-side certificate checks and bypass security while establishing connection to Tableau. 

Default Value:  Not selected 

Snap Execution

Dropdown list

Select one of the three modes in which the Snap executes. Available options are:

  • Validate & Execute: Performs limited execution of the Snap, and generates a data preview during Pipeline validation. Subsequently, performs full execution of the Snap (unlimited records) during Pipeline runtime.

  • Execute only: Performs full execution of the Snap during Pipeline execution without generating preview data.

  • Disabled: Disables the Snap and all Snaps that are downstream from it.

Default Value: Execute only
Example: Validate & Execute

Troubleshooting

ErrorReasonResolution
"tabcmd not found"The tabcmd file is not picked up by the JCC path.

Install tabcmd in one of the folders that is available in the JCC's PATH.

To view the available folders in the JCC PATH:

  1. Navigate to jetty.log; if it does not exist then navigate to jcc_output.log.
    The system launches the PATH variable; you can view the folders available in that path.

    You can provide an absolute path to tabcmd file in one of the folders available in the jcc’s path for a Linux machine.

  2. Install the tabcmd file in one of the folders.
  3. Accept the End User License agreement.

Example

The following example Pipeline shows how to write data in a Tableau data source using the Tableau Write Snap:

 

In the Pipeline execution:

  1. A File Reader Snap provides the Fielding.csv file data to a CSV Parser Snap, which is then provided as an input to the Tableau Write Snap:

     
  2. The Tableau Write Snap specifies the data source, TableauWrite, and the Project, Test, where the Fielding.csv file data is written: 

     

    Successful execution of the Snap shows the following preview. A successful execution in Tableau is notified with return_code: "0":