Output TDE File

Operation Name

Output TDE File

Function Overview

Output data input into a TDE file.

Data Model

Table Model type.

Properties

For information about using variables, refer to "Variable".
Basic settings
Item name Required/Optional Use of variables Description Remarks
Name Required Not available Enter the name to show on the script canvas.  
Input data Required Not available Select the component on the script canvas.  
Required settings
Item name Required/Optional Use of variables Description Remarks
File Required Available Enter file path of a TDE file.

Click [Browse] button to launch the file chooser and select the file.
Column list Required
-
 Specify columns.

Each column can be operated by following buttons.
  • [Add]:
    Adds a column.
  • [Up]:
    Moves the order of the selected column upwards by one.
  • [Down]:
    Moves the order of the selected column downwards by one.
  • [Delete]:
    Deletes the column.
  
Column list/Column name Required Available Enter column name of the TDE file specified in [File].  
Column list/Type Required Not available Select a type of [Column type].
  • [INTEGER (int)]: (default)
  • [DOUBLE (double)]:
  • [BOOLEAN (boolean)]:
  • [DATE (Date)]:
  • [DATETIME (Date)]:
  • [DURATION (BigDecimal)]:
  • [CHAR_STRING (String)]:
  • [UNICODE_STRING (String)]:
  • Displayed in the format of "<Native Type> (<Internal data type>)".
    • Native type:
      The data type of TDE file.
    • Internal data type:
      Data type used internally in DataSpider.
      For more datails, refer to "Internal data type".
  • Duration is entered as seconds into columns of [DURATION (BigDecimal)] type.
    For example, if 1 minute and 2.34 seconds would like to be entered, enter "62.34".
    • Values is rounded down to four decimal places.
      For exmaple, "1.23456" is dealt as 1.2345 seconds.
Column list/Collation Optional Not available Select collation of [Column name].
  • (Not specified): (default)
  • [BINARY]:
  • [AR]:
  • [CS]:
  • [CS_CI]:
  • [CS_CI_AI]:
  • [DA]:
  • [DE]:
  • [EN_GB]:
  • [EN_US]:
  • [EN_US_CI]:
  • [ES]:
  • [ES_CI_AI]:
  • [ET]:
  • [FI]:
  • [FR_CA]:
  • [FR_FR]:
  • [FR_FR_CI_AI]:
  • [HE]:
  • [HU]:
  • [IS]:
  • [IT]:
  • [JA_JIS]:
  • [KO]:
  • [LT]:
  • [LV]:
  • [NL_NL]:
  • [NN]:
  • [PL]:
  • [PT_BR]:
  • [PT_BR_CI_AI]:
  • [PT_PT]:
  • [ROOT]:
  • [RU]:
  • [SL]:
  • [SV_FI]:
  • [SV_SE]:
  • [TR]:
  • [UK]:
  • [VI]:
  • [ZH_HANS_CN]:
  • [ZH_HANT_TW]:
  • Select only when [CHAR_STRING (String)] or [UNICODE_STRING (String)] is selected in [Type].
    When other type is selected in [Type], the selected [Collation] is ignored.
  • When specifying new TDE file in [File], and not specifying [Collation], the collation will be [BINARY].
Property action
Item name Description Remarks
Update column list Gets the column names, types and collations from the TDE file specified in [File], and set them in [Column list].
  • Disabled if the specified file doesn't exist, the file is unwritable, or a variable is set in [File].
Setup column list simply (load from a global schema) Select a global schema, then transforms it into column list of this operaion and set it in [Column list].
  • In the global schema selection screen, global schemas of table model type are displayed in the list.
  • On loading global schema, the correspondence between column type of the schema and [Column list/Type] is as the following.
    Column type of the schemaColumn list/Type
    byteINTEGER (int)
    shortINTEGER (int)
    intINTEGER (int)
    longINTEGER (int)
    floatDOUBLE (double)
    doubleDOUBLE (double)
    BigDecimalDOUBLE (double)
    booleanBOOLEAN (boolean)
    StringUNICODE_STRING (String)
    DateDATETIME (Date)
    byte[]CHAR_STRING (String)
    If necessary, modify Column list/Type after loading schema.
    For details on column type of the schema, refer to "Data type".
  • Collation is not loaded. If necessary, set it after loading schema.
Transaction
Item name Required/Optional Use of variables Description Remarks
Execute transaction processing Required Not available Select whether to perform transaction processing.
  • [Checked]:
    Performs transaction processing.
  • [Not checked]: (default)
    Does not perform transaction processing.
For more details, refer to "trancation of file system adapter". 		 
Comment
Item name Required/Optional Use of variables Description Remarks
Comment Optional Not available You can write a short description of this adapter.
The description will be reflected in the specifications.		  

Schema

Input Schema

Depending on the [Column list] setting, the number of columns may be different.
See "Schema of Table Model" for details regarding schema structure.

Output Schema

None.

Loading Schema on Mapper

Schema is loaded automatically.
For more details, refer to "Edit Schema".

Transaction

Transaction is supported.

Transaction is enabled only when [Execute transaction processing] in [Transaction] is checked.

PSP Usage

PSP is supported.
For details on PSP, refer to "Parallel Stream Processing".

Available Component Variables

Component variable name Description Remarks
count Stores the count of the data.
  • Default value is null.
result Stores the result code of Tableau Data Extract API corresponding to the occurred error.
  • Default value is null.
  • The value may vary depending on the DataSpider Servista version.
message_category Stores the category of message code corresponding to the occurred error.
  • Default value is null.
message_code Stores the code of message code corresponding to the occurred error.
  • Default value is null.
message_level Stores the severity of message code corresponding to the occurred error.
  • Default value is null.
error_type Stores the error type of occurred error.
  • Default value is null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The value may vary depending on the DataSpider Servista version.
error_message Stores the error message of occurred error.
  • Default value is null.
  • The value may vary depending on the DataSpider Servista version.
error_trace Stores the trace information of occurred error.
  • Default value is null.
  • The value may vary depending on the DataSpider Servista version or executing client application.

Log File

When setting or executing TDE File Output operation, log of Tableau Data Extract API used in the operation is output to a file.

Destination

$DATASPIDER_HOME/server/bin/DataExtract.log

Specification Limits

Main Exceptions

Exception name Cause Solution
InvalidPropertyConfigurationException
<Property name> is not specified.		 [<Property namegt;] is not specified. Specify [<Property name>].
InvalidPropertyConfigurationException
Specify TDE file (*.tde).		 The path entered in [File] is not TDE file. Enter TDE file (*.tde) in [File].
FileIsDirectoryException Path entered in [File] is directory. Enter file path in [File].
InvalidPropertyConfigurationException
Column list is not specified.		 [Column list] is not specified. Specify [Column list].
InvalidPropertyConfigurationException
Column name of line <The number> in column list is not entered.		 [Column list/Column name] is not entered. Enter [Column list/Column name].
InvalidPropertyConfigurationException
The number of columns of column list is different from that of the TDE file.		 The number of columns of [Column list] is different from that of the TDE file. Specify columns in [Column list] as that set in the TDE file to write in.
InvalidPropertyConfigurationException
Column name of line <The number> in column list is different from that of the TDE file.		 [Column list/Column name] is different from that of the TDE file. Specify column name in [Column list/Column name] as that set in the TDE file to write in.
InvalidPropertyConfigurationException
Type of line <The number> in column list is different from that of the TDE file.		 [Column list/Type] is different from that of the TDE file. Specify type in [Column list/Type] as that set in the TDE file to write in.
InvalidPropertyConfigurationException
Collation of line <The number> in column list is different from that of the TDE file.		 [Column list/Collation] is different from that of the TDE file. Specify type in [Column list/Collation] as that set in the TDE file to write in, or not specify it.
ProhibitedOperationException
Unauthorized operation: Write		 It is impossible to write in the path entered in [File]. Check authority to write in the path entered in [File].
java.io.FileNotFoundException It is impossible to write in the path entered in [File]. Check authority to write in the path entered in [File] in DataSpiderServer operation OS.
com.tableausoftware.TableauException An error occured in Tableau Data Extract API. Confirm the error message or the value of component varible [result].

Notes