Triggers
Overview
- Triggers in Rapidi are useful when it is necessary to perform data manipulation before or after data transfer.
- This is especially useful if it is not possible to perform the data manipulation in Rapidi, or if, in terms of performance, it is better to use the Data Source itself to perform the manipulation.
- Rapidi supports the execution of Triggers before (pre Trigger) it starts to transfer data, and after data has been transferred (post Trigger). There is no support for a per record Trigger.
- Most of the Data Sources that support external programs calling code in the database use Stored Procedure code.
- If you wish to have Rapidi execute a Trigger, you apply the name of the stored procedure in one of the four fields (i.e., Source Pre Execution, Source Post Execution, Destination Pre Execution, or Destination Post Execution) concerning triggers in the requested Transfer.
The order of execution is as follows:
- Source Pre-Execution: It is running.
- Source Post-Execution: It is running.
- Destination Pre-Execution: It is running.
- Destination Post-Execution: It is running.
Note:
When Pre and Post Triggers are used, the performance of the Transfer is difficult to measure, since it depends on how much time the Triggers spend on the execution.