Write(DataLoader)

Operation Name

Write(DataLoader)

Function overview

By using the update loader function of Dr.Sum EA Dataloader, write input data to the table in Dr. Sum EA.
Update rows identical to key columns. If not, insert rows instead.
Processing wide range of operation results in high-speed writing.
This is an operation available in Dr.Sum EA 3.0 SP2 or later.

Data Model

Data model of this type of component is table model type.

Properties

For information about using variables, refer to "variables".
Basic settings
Item name Required/Optional Use of Variables Description Remarks
Name Required Not available Enter the name 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
Destination Required Not available Select Global Resources.
Refer to "Global Resource Properties"for global resource settings .
  • [Add]:
    Adds new global resource.
  • [Edit list]:
    Global resource settings can be managed from "Edit Resource list".
  
Table name Required Available Select or enter the name of the database table.
  • View, multi-table, link table are not shown.
Schema definition Required - Specify the schema definition of database.
  • Column name shown in [Schema definition] is displayed in schema of Mapper.
  • Schema definition cannot be viewed in the following cases.
    • If do not have read permissions to the specified table
    • If the specified table does not exist
    • If [Table name] is specified by variable
    • If [Table name] is not entered
    • If error occurs in [Table name]
Schema definition / Column name Required Not available Shows the column name of the table name specified in [Table name].  
Schema definition / Type Required Not available Select [Column name] type.
  • Displayed in the format of "Native type (Internal data type)" .
    • Native type:
      Dr.Sum EA specific data type.
    • Internal data type
      Data type used internally in DataSpider.Refer to here for details .
Key Column Name Required Available Select or enter a key column.
  • You can select columns with the NOT NULL UNIQUE restriction.
  • An error occurs if columns without the NOT NULL UNIQUE restriction are selected.
  • Multiple columns cannot be used as keys.
Property Action
Item name Description Remarks
DataLoader connection test Conduct a test to verify if Write(DataLoader) operation is executable to Dr.Sum EA specified in [Destination].
The test will be succeeded if DataLoader has the appropriate version and the update loader function is enabled.
  • Enabled when Dr.Sum EA, which can connect to [Destination], is selected.
Show table information Displays the structure, content and related information of tables of the database specified in [Destination].
{0 /} Refer to "Table Information" for table information .
  • Enabled when the below conditions are all fulfilled.
    • Dr.Sum EA which can connect to [Destination] is specified
    • The Write(DataLoader) process is executable to Dr.Sum EA, specified in [Destination].
  • View, multi-table and link table cannot be selected.
  • Distributors are not shown in [Table name].
Update schema definition Update [Schema definition] as well as [Key Column Name].
  • Enabled when the below conditions are all fulfilled.
    • Dr.Sum EA which can connect to [Destination] is specified
    • The Write(DataLoader) process is executable to Dr.Sum EA, specified in [Destination].
    • [Table name] is specified.
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 settings for the [Schema definition] the number of columns may vary.
See "Schema of Table Model" for details regarding schema structure .

Output Schema

None.

Loading schema in Mapper

Schema is loaded automatically.
See "Edit Schema"for any details .

Transaction

Transaction is not supported.

PSP Usage

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

Available Component variables

Component variable name Description Remarks
count Returns the total number of written data.
  • The value defaults to null.
error_code When an error occurs, Dr.SumEA returns the error status in decimal value. If no error occurred, returns null.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
message_category Stroes the category to which corresponding message code belongs to, when an error occurs.
  • The value defaults to null.
message_code Stores its corresponding message code of occured error.
  • The value defaults to null.
message_level Stores the severity of the corresponding message code of the occured error.
  • The value defaults to null.
error_type Stores the type of the occured error.
  • The value defaults to null.
  • Error is represented in the format depicted below.
    Example:java.io.FileNotFoundException
  • The message may vary depending on DataSpider Servista version.
error_message Stores the error message for the occured error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version.
error_trace Stores stack trace of the occurred error.
  • The value defaults to null.
  • The message may vary depending on DataSpider Servista version or the client application used.

Specification Limits

About specifications, please refer to the following page.

Main exceptions

Exception name Cause Solution
InputDataNotFoundException [Input data] is not specified. Specify the [Input data], or draw the data flow.
ResourceNotFoundException
Resource definition could not be found.Name: []		 [Destination] is not specified. Specify [Destination].
ResourceNotFoundException
Resource definition could not be found.Name: [<name of Global Resources>]		 Resource definition selected in [Destination] is not found. Check the global resource specified in [Destination].
InvalidPropertyConfigurationException
Table name is not defined.		 [Table name] is not set. Specify the [Table name].
InvalidPropertyConfigurationException
Key column is not defined.		 [Key Column Name] is not set. Specify a column name with the NOT NULL UNIQUE restriction to [Key Column Name].
DataLoaderUpdateNotSupportedException
The update loader function is invalid or not supported.		 The Write(DataLoader) operation cannot be executed as the update loader function of Dr.Sum EA, which is specified in [Destination], is invalid or the version is not supported. Confirm if the update loader function of Dr.Sum EA specified in [Destination] is activated, as well as the version is 3.0 SP2 or later.
jp.co.dw_sapporo.drsum_ea.DWException
A column name which does not exist is specified.		 A column name which does not exist in the target table is specified to [Key Column Name]. Specify a column name which exists in the target table to [Key Column Name].
jp.co.dw_sapporo.drsum_ea.DWException
Field Type Error		 A column without the NOT NULL UNIQUE restriction is specified to [Key Column Name]. Specify a column name with the NOT NULL UNIQUE restriction to [Key Column Name].
jp.co.dw_sapporo.drsum_ea.DWException
Unique restriction violated.		 Unique restriction violation has been recognized when writing to a table. Check [Input data], as well as the target table schema information.
jp.co.dw_sapporo.drsum_ea.DWException
NOT NULL restriction is violated.		 There has been NOT NULL restriction violation occurring especially when writing to a table. Check [Input data], as well as the target table schema information./td>

Notes

About specifications, please refer to the following page.