Available SQL actions
By default, Integrator INSERTS records into the destination table.
You can change this to
To change the action go to MAPPING/Parameters/Action.
Conditional actions require setting the lookup field(s).
Read about SQL action and Lookup field(s) parameters.
MERGE is natively supported for Oracle, MS SQL Server, PostgreSQL, MySQL, DB2, Informix and Sybase databases.
Read how to use MERGE.
The alternative to MERGE is the
IfExist action: Integrator will check to see if the record already exists, and if it does - will execute
UPDATE; otherwise it executes
Read how to use IfExists.
Read how to execute SQL action conditionally