Field Mappings for Salesforce Restores

Updated

A field map is generated for all organizations during a backup job. This map indicates a link between each object and a corresponding field that can be used as a mapping field, i.e., has the same value across sandbox and production organizations. Field mappings determine how data from a source corresponds to data in a destination.

This map is generated during the backup process, and eligible mapping fields are prioritized based on following criteria:

  • Field, which is an external Id, is unique and required

  • Field, which is unique and required

If no fields for the object matches this criterion, we may create a new field called CvExternalId. This generated map can be modified as needed from the restore screen with the pencil icon. The automatically generated field maps can be edited by clicking on the pencil icon for the corresponding source or destination organization. New fields can be added and existing fields modified. Any changes made this way are retained for subsequent jobs to or from the destination or source organization.

The source organization record ID is stored in the CvExternalId field as part of a restore job. Later, in subsequent jobs, this field is used to map the records with the source organization's ID. If a match is found, the record is updated. Otherwise, a new record is inserted. This is similar to an incremental restore job.

CvPermissionSet is used to create a new permission set for newly created CvExternalId fields on the restored objects. This permission set is then assigned to the logged in user of the destination organization, allowing that user account to access or insert values in this field later during the restore job.

The API name associated with CvExternalId is CvExternalId__c

Choose one of four options:

  • Skip mapping fields: Do not use a map and fallback to the system default fields for mapping. Examples include ID or default cloud-mapping fields.

  • Use CvExternalId to map all objects: CvExternalId is a custom field created by the Commvault restore process. With this option selected, the Salesforce metadata API is used to create the custom field.

    If Salesforce restricts creating new custom fields on certain objects, it may return a FIELD_INTEGRITY_EXCEPTION error.

  • Use destination field mappings: The field map of the destination organization used for restore jobs.

  • Use source field mappings: The field map of source organization is used for restore jobs.

Was this page helpful?