TableauWriter

Not available in Community Designer

Short Description
Ports
Metadata
TableauWriter Attributes
Details
Compatibility
See also

Short Description

TableauWriter writes data in Tableau (.tde) files. The component depends on native libraries.

ComponentData outputInput portsOutput portsTransformationTransf. requiredJavaCTLAuto-propagated metadata
TableauWriterTableau binary file10
no
no
no
no
no

Ports

Port typeNumberRequiredDescriptionMetadata
Input0
yes
For received data recordsNot all data types

Metadata

Input metadata of TableauWriter cannot contain data types decimal, long, byte and cbyte. Tableau types do not have sufficient precision for Clover types decimal and long and the conversion would be lossy. A recommended alternative to decimal data type in TableauWriter is number (double), an alternative to long is integer. Clover data types byte and cbyte do not have a corresponding Tableau data type.

Metadata containers (list, map) are not supported.

To set up mapping of particular metadata fields on Tableau metadata, use the attribute Tableau Table Structure.

TableauWriter Attributes

AttributeReqDescriptionPossible values
Basic
File URLyes

An attribute specifying where received data will be written. The file name must have the .tde suffix.

e.g. file.tde
Table nameyes

The prefilled value Extract required by Tableau. The value cannot be changed.

Extract
Default table collation 

Value of the default collation used in the Tableau Table Structure dialog.

EN_US (default) | any from the list
Tableau table structure See Tableau Table Structure. 
Advanced
Action on existing output file Defines an action to be done if the output file already exists.Overwrite table (replace the file) | Append to table | Terminate processing

Details

Tableau Table Structure
Adding Libraries
Notes and Limitations

Tableau Table Structure

The Tableau Table Structure dialog serves to assign Tableau data types and collation to particular metadata fields.

The input field above the list of fields works as a filter to the displayed fields.

Tableau Table Structure

Figure 56.27. Tableau Table Structure


Adding Libraries

TableauWriter depends on native libraries. You need to download the libraries and set up your operating system to use it. OS X is not currently supported as there are currently no native Tableau libraries for OS X.

The libraries can be downloaded from Tableau - Data Extract API.

The usage of Tableau libraries with Eclipse is described at Using the Tableau SDK with Java and Eclipse

Linux

To use TableauWriter on Linux, add Tableau's bin directory to system PATH.

The Tableau's lib[32|64]/dataextract directory must be on LD_LIBRARY_PATH.

For more information, see the Linux documentation: Shared Libraries.

Windows

To be able to use TableauWriter on Windows, you should add the bin directory of Tableau to system PATH.

Notes and Limitations

More TableauWriters cannot write in the same phase as Tableau API is not threadsafe.

When a .tde file is open in Tableau application, CloverETL cannot write into it.

TableauWriter cannot write data directly to .zip files via URL (e.g. zip:(/path/file.zip)#file.tde) as the URL from the component is passed down to the Tableau library and the library cannot write zip files in this way.

TableauWriter on CloverETL Server

More TableauWriter components cannot run at the same time. If there is TableauWriter component already running, and the second TableauWriter component needs to run, the graph with the second component fails.

TableauWriter on JBoss 6

TableauWriter has an issue on default configuration of JBoss 6 on Linux. It is necessary to change HornetQ journal type (default value if libaio is installed) from ASYNCIO to NIO. Journal type can be changed in the hornetq-configuration.xml.

<journal-type>NIO</journal-type>

See JBoss - Persistence.

Compatibility

4.0

TableauWriter component is available since CloverETL 4.0.0.

See also

Common Properties of Components
Specific Attribute Types
Common Properties of Writers
Writers Comparison