TDE Formatter [Deprecated]
In this Article
Overview
You can use this Snap to format tabular document data into Tableau data format (TDE extension) and writes this formatted data to a binary output view. The binary output view can be used to connect to the File Writer Snap to persist data as a file.  This file can then be used with Tableau products, including Tableau Desktop.
 This Snap Pack has been implemented against & verified with the 9.1 version of Tableau server.Â
Snap Type
TDE Formatter is a Format-type Snap that transforms Data into Tableau TDE format.
Prerequisites
For Linux Snaplexes
TDE Formatter Snap is compatible with Linux Snaplexes. You must do the following configurations before using this Snap on Linux Snaplexes:
Download the generic .tar .gz file for C++/Java. You can download the SDK from here.
Unpack locally and ensure that all the binaries are owned by the account running the JCC service. For example:
cp /opt/Snaplogic
tar xzvf Tableau-SDK-Linux-64Bit-9-3-4.tar.gzUpdate /opt/Snaplogic/bin/jcc.sh & the LD_LIBRARY_PATH definition to include the lib64 folder path that resides in the root folder created in the previous step. For example:
export LD_LIBRARY_PATH=${SL_ROOT}/ldlib:/opt/Snaplogic/tableausdk-linux64-9300.0.0.0/lib64/tableausdkRestart the JCC service for the recent changes to take effect.
Support for Ultra Pipelines
Works in Ultra Task Pipelines.
Limitations and Known Issues
None.
Snap Views
Type | Format | Number of Views | Examples of Upstream and Downstream Snaps | Description |
---|---|---|---|---|
Input | Document |
|
| This Snap has exactly one document input view. |
Output | Document |
|
| This Snap has exactly one document output view. |
Error | Error handling is a generic way to handle errors without losing data or failing the Snap execution. You can handle the errors that the Snap might encounter when running the Pipeline by choosing one of the following options from the When errors occur list under the Views tab:
Learn more about Error handling in Pipelines. |
Snap Settings
Asterisk (*): Indicates a mandatory field.
Suggestion icon (): Indicates a list that is dynamically populated based on the configuration.
Expression icon (): Indicates whether the value is an expression (if enabled) or a static value (if disabled). Learn more about Using Expressions in SnapLogic.
Add icon (): Indicates that you can add fields in the field set.
Remove icon (): Indicates that you can remove fields from the field set.
Field Name | Field Type | Description |
---|---|---|
Label* Â Default Value:Â TDE Formatter | String | Required. 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. |
Snap Execution  Default Value: Validate & Execute | Dropdown list | Select one of the three modes in which the Snap executes. Available options are:
|
Example
The following example pipeline shows how to convert document data to .tde using the Tableau TDE Formatter Snap. The Snap only formats the data as per Tableau TDE format specifications; to use the formatted data in Tableau, you create the .tde file using a File Writer Snap:
Â
In the pipeline execution:
JSON Generator Snap provides file data to the input view of the Tableau TDE Formatter Snap:
Â
ÂThe Tableau TDE Formatter Snap formats the data to .tde format:Â
Â
The TDE format data is then written to a test_simple_new.tde file using a File Writer Snap:Â
Â
Have feedback? Email documentation@snaplogic.com | Ask a question in the SnapLogic Community
© 2017-2024 SnapLogic, Inc.