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.
Last updated on 29th Jan 2023