Advanced setting of Mapping
The following detailed settings can be added during the mapping process.
1. Pre-processing and Post-processing before and after Data extraction, updating.
2. Set up data processing, notification, etc. for success, failure or no target data during mapping.
|1||Preprocessor of Extract||You can execute SQL before data extraction.If you want to set it, choose Yes and click the Detail button to set the details.|
|2||Postprocessor of Extract||You can execute SQL after data extraction.If you want to set it, choose Yes and click the Detail button to set the details.|
|3||Staging table name||Before updating the data, SDI once loads the target data into the Staging table. The staging table name is auto-generated by the system and can be configured. Please enter the table name directly if you want to change it.
If you want to use a table with a different schema than the target table, enter it in the following format.
schema name.table name
e.g : SCOTT.EMPTEMP
|4||Preprocessor of update||You can execute SQL before data update.If you want to set it, choose Yes and click the Detail button to set the details.|
|5||Data Update Mode||Select how to update the target table.
If the result is true, then updates the row with the corresponding data from the source table.
In case the result is false for any rows, then inserts the corresponding row from the source table into the target table.
*If the primary key is not defined on the target table, this method cannot be selected
|6||Delete Target Table Before Execute||Whether to delete the data in the target table before updating the data.|
|7||Postprocessor of update||You can execute SQL after data extraction.If you want to set it, choose Yes and click the Detail button to set the details.|
|8||Drop Staging table||Whether to drop the Staging table after mapping processing is complete|
|9||Processor on Success||You can define the treatment when the mapping process is successfully done. The treatment includes execute SQL, send an email, and if the source is a file, move, delete, backup, source file.|
|10||Processor on Failure||You can define the treatment when the mapping process is failed. The treatment includes execute SQL, send an email, and if the source is a file, move, delete, backup, source file.|
|11||Processor on Nodata||You can define the treatment when no extraction data exists. The treatment includes execute SQL, send an email, and if the source is a file, move, delete, backup, source file.|
Pre-processing, post-processing, data update content setting
|Preprocessor of Extract Postprocessor of ExtractPreprocessor of updateData update(Custom)、Postprocessor of update|
|12||SQL||Enter the SQL to execute|
Treatment after mapping process (On Success , On Failure and On Nodata)
|Processor on SuccessProcessor on FailureProcessor on Nodata|
SQL execution configuraion
|13||Execute SQL checkbox||If you would like to Execute SQL, select the Execute SQL checkbox. If the Execute SQL checkbox is checked, the Execute SQL tab appears.|
|14||Execute SQL Tab|
|15||Connection||Select the target database|
|16||SQL||Enter the SQL to execute|
Source File Operation configuraion
If the source is a file like CSV or Execl, you can delete or rename the source file when the import is complete.If you need to set it up, refer to the following manual.
* If the source is RDB, the checkbox will not be visible.
|17||Source File Operation checkbox||Check this checkbox if you want to remove or rename the source file when the mapping process is finished.|
|18||File Operation Tab|
|19||Source File||Source file information is displayed.|
|23||Local Backup||Check this checkbox if you want to make a backup of the source file when the mapping process is finished.|
Email notification configuration
|26||Send Mail checkbox||Check this checkbox if you would like to send an email notification when the mapping process is complete.|
|27||Send Mail tab|
|28||Use Template checkbox||Check this checkbox if you would like to use a predefined mail template.
If unchecked, set the email content on this screen.
|29||Template selection||Select the mail template while the
|30||Mail Template configuration||Open
|31||Mail information||Set the message to, CC, subject of the e-mail, body of the e-mail, and so on.
* When using an email template, it will be Read only.
|32||Mail attachments||It is possible to attach the following files when sending an email. Check the required files.
|33||AddInformation||You can set up to three additional information in the email title and body. The value