How to update the target field with a constant value?
Question.
I have to set the owner for the inserted or updated records to the specific constant user in the Target org, instead of the running user that performs the data migration.
How can I do that ?
Answer.
This can be done using the Values Mapping feature
This configuration should work to update the target OwnerId with constant value.
ObjectName | FieldName | RawValue | Value |
---|---|---|---|
Account | OwnerId | /(.+)/ | [You target OwnerId value, e.g. 00530000003xqAb] |
This regex will match all source owner ids and will put the target owner id value instead.
Notes:
- In this configuration the target OwnerId value is not dynamic. Remember to set it per target org.