TableauWriter
| 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.
| Component | Data output | Input ports | Output ports | Transformation | Transf. required | Java | CTL | Auto-propagated metadata |
|---|---|---|---|---|---|---|---|---|
| TableauWriter | Tableau binary file | 1 | 0 |  | | | | |
Ports
| Port type | Number | Required | Description | Metadata |
|---|---|---|---|---|
| Input | 0 |  | For received data records | Not 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 CloverDX 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.
CloverDX 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
| Attribute | Req | Description | Possible values |
|---|---|---|---|
| Basic | |||
| File URL | yes |
An attribute specifying where received data will be written.
The file name must have the | e.g. file.tde |
| Table name | yes |
The prefilled value | 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.
Figure 56.26. 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, CloverDX
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.
Recommended Swap Size
On Linux, in case of a small swap size, an exception may occur:
com.tableausoftware.TableauException: Cannot allocate memory - fork()
To prevent this, you can either:
increase the size of swap to equal the RAM size, or
allow memory overcommit (see overcommit accounting).
In the latter case, make sure you understand the implications.
Concurrent run of TableauWriter components
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.
Compatibility
| Version | Compatibility Notice |
|---|---|
| 4.0 | TableauWriter component is available since 4.0.0. |