TDE Formatter

On this Page

Snap type:

Format

Description:

This Snap formats 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
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:

  1. Download the generic .tar .gz file for C++/Java. You can download the SDK from here.
  2. 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.gz
  3. Update /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/tableausdk
  4. Restart the JCC service for the recent changes to take effect.


Support and limitations:Works in Ultra Task Pipelines.
Account: 

Accounts are not used with this Snap.


Views:
InputThis Snap has exactly one document input view.
OutputThis Snap has exactly one document output view.
ErrorThis Snap has at most one document error view and produces zero or more documents in the view.

Settings

Label


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.

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:


  1. JSON Generator Snap provides file data to the input view of the Tableau TDE Formatter Snap:

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

     

Snap Pack History

 Click to view/expand
ReleaseSnap Pack VersionDateTypeUpdates
August 2022main17386 StableUpgraded with the latest SnapLogic Platform release.

4.29

main15993

 

Stable

Upgraded with the latest SnapLogic Platform release.

4.28main14627 StableUpgraded with the latest SnapLogic Platform release.

4.27

main12833

 

Stable

Upgraded with the latest SnapLogic Platform release.
4.26main11181 Stable

Added the following Tableau Snaps to support hyper extract files for Tableau 10.25 and later versions.

  • Hyper Formatter: Converts the incoming documents to Tableau hyper extract format and sends the output (extract) to the binary output view. 
  • Hyper Parser: Parses Tableau hyper extract files and converts them to a document format.
  • Hyper Write: Creates a hyper file in a temporary location (local disk) for incoming documents and publishes it to Tableau Server/Online without packaging it into a data source.
4.25425patches10994 Latest

Fixed an issue with Tableau REST Snap where the Snap was not able to filter or route the output data shows either duplicate records or incorrect results.

4.25main9554 StableUpgraded with the latest SnapLogic Platform release.
4.24main8556
 
Stable

Fixed an issue when updating user information in the Tableau REST Snap by not overwriting the site ID or user ID if the entries already exist.

Behavioral Change

In the 4.23 release, the Tableau REST Snap had a defect where it used site ID and user ID from the Tableau Account even if the selected REST operation required a site ID and/or user ID from the input document. This issue is fixed in the 4.24 release, so that the Snap uses values for the said IDs from the input document when available. Since this fix changes the Snap behavior, it is possible for production Pipelines to fail after the 4.24 release. Hence, you need to reconfigure the Tableau REST Snap using the site ID and user ID values from the input document.

4.23main7430
 
StableUpgraded with the latest SnapLogic Platform release.
4.22main6403
 
StableUpgraded with the latest SnapLogic Platform release.
4.21snapsmrc542
 
StableUpgraded with the latest SnapLogic Platform release.
4.20snapsmrc535
 
StableUpgraded with the latest SnapLogic Platform release.
4.19snaprsmrc528
 
StableUpgraded with the latest SnapLogic Platform release.
4.18snapsmrc523
 
StableUpgraded with the latest SnapLogic Platform release.
4.17ALL7402
 
Latest

Pushed automatic rebuild of the latest version of each Snap Pack to SnapLogic UAT and Elastic servers.

4.17snapsmrc515
 
Latest

Added the Snap Execution field to all Standard-mode Snaps. In some Snaps, this field replaces the existing Execute during preview check box.

4.16snapsmrc508
 
StableUpgraded with the latest SnapLogic Platform release.
4.15snapsmrc500
 
StableUpgraded with the latest SnapLogic Platform release.
4.14snapsmrc490
 
StableUpgraded with the latest SnapLogic Platform release.
4.13

snapsmrc486

 
Stable

Enhanced Tableau Snap Pack to support Tableau version 10.5 (Server version), this includes support for refresh task related REST API calls in the Tableau REST Snap.

4.12

snapsmrc480

 
StableUpgraded with the latest SnapLogic Platform release.
4.11snapsmrc465
 
StableUpgraded with the latest SnapLogic Platform release.
4.10

snapsmrc414

 
StableUpgraded with the latest SnapLogic Platform release.
4.9

snapsmrc405

 
Stable
  • Extended the support for Tableau 9 and 10 REST Snap to access the TDE files on S3 (using the IAM role on the Snap Account).
  • Support extended for Tableau 10.1 server version.
  • Updated the Snap account with the properties, XML Schema URL and API version (other).
  • Updated the Snap account with Access Key ID, Secret Key and IAM role to support access to files on S3.
  • Tableau REST Snap extended support to access the TDE files on S3.
4.8

tableau92770

 
Latest

Addressed an issue where the TDE Formatter threw a Field conversion failed error.

4.8

snapsmrc398

 
StableUpgraded with the latest SnapLogic Platform release.
4.7

snapsmrc382

 
StableUpgraded with the latest SnapLogic Platform release.
4.6

snapsmrc362

 
Stable
  • Enhanced to support chunking when publishing large files for the Tableau 9&10 REST Snap. 
  • Enhanced error reporting when fields are improperly mapped from input Tableau 9&10 REST Snap. 
  • Enhanced error handling to appropriately route errors in the Tableau 9&10 Write Snap. 
  • Enhanced error handling to appropriately route errors in the Snap for the TDE Formatter Snap.
  • Extended the TDE Formatter Snap support for Linux Snaplexes. 
  • Doc Enhancement: Examples added to Tableau 9 Snap documentation.
  • Resolved an issue in Tableau REST Snap that caused failures when publishing workbook and datasources. 
  • Resolved an issue in TDE Formatter and Tableau REST Snap that cause errors on Windows Groundplex.
  • Resolved an issue in Tableau REST Snap that only made available 100 entries of datasource.
4.5.1

tableau91634

 
Latest
  • Initial release of the Snap Pack with Tableau 9&10 REST, Write and the TDE Formatter Snaps.

  • Supports Tableau 9.1 version of Tableau server.