Field Mappings in Salesforce Data Synchronization Tasks
You can map source columns to target columns on the Field Mapping page of the Data Synchronization Task wizard. You must map at least one source column to a target column. You can map columns with compatible data types or create field expressions to convert data types appropriately.
Based on the operation, the Data Synchronization task requires certain fields in the field mapping. By default, the Data Synchronization task maps the fields with similar names. When you configure the field mapping, ensure that the required fields remain mapped. If you do not map the required fields, the Data Synchronization task fails.
The following table shows the required fields for each task operation and target type:
Required Field | Task Operations | Description |
|---|
ID | Delete Update | Map the ID column to enable the Data Synchronization task to identify records to delete or update in a Salesforce target. |
Upsert Field | Upsert | Configure and map the upsert field to enable the Data Synchronization task to identify records to upsert in a Salesforce target. The upsert field can be an external ID field or a field with the idLookup field property enabled. |
Non-null fields | Insert Update Upsert | Map all fields that cannot be null in Salesforce. |
Note: When you configure field mappings, you can also perform the following tasks:
- •Map a column with similar name.
- •Edit field data types.
- •Add a mapplet to the field mapping.
- •Create field expressions to transform data.
- •Create lookups.
- •Validate expressions defined in the field mapping section.