Property | Definition |
|---|---|
Transfer mode | Update or insert: If a record with the same primary key already exists in the target table, it is updated. Otherwise, a new record is inserted. Replace all content: All existing data in the table will be deleted before importing the data. |
Force transfer | Specifies that all triggers and constraints are disabled when this option is activated. Otherwise, all triggers and constraints are enabled. |
Include computed values | Specifies whether computed values must be included in the transfer. |
Ignore the empty or null values | By default, the existing record is not updated with null and empty values from the source table. |
Check empty or null primary keys | The add-on verifies that all primary keys are mapped and validates the data before transferring. If you disable this option, the add-on does not perform this verification. |
| Stop and rollback on error | Enabling this option causes the add-on to stop the data transfer in progress when errors occur and rollback all data. If disabled, the add-on skips transfers where errors occur and executes remaining transfers. Take as an example a transfer from table A to tables B, C, and D. If errors occur only during transfer to B, the add-on rolls back data for B, but completes transfer to C and D. |
| Transfer data | Based on this data model: Specify the datasets that have the same data model as the current dataset. Based on a different data model (mapping required): Specify the datasets that don't have the same data model as the current dataset. |
| Target dataspace | List of relevant target dataspaces is obtained by the system after selecting the 'Transfer data' option. |
| Target dataset | List of relevant target datasets are obtained by the system after selecting the 'Transfer data' option. |