Microsoft Dynamics 365 for Sales Connector > Mappings and mapping tasks with Microsoft Dynamics 365 for Sales Connector > Microsoft Dynamics 365 for Sales targets in mappings
  

Microsoft Dynamics 365 for Sales targets in mappings

In a mapping, you can configure a Target transformation to represent a single Microsoft Dynamics CRM target or Microsoft Dynamics CRM parameter. When the source is partitioned and you write data to Microsoft Dynamics CRM, the Secure Agent uses the pass-through partitioning.
The following table describes the Microsoft Dynamics CRM target properties:
Property
Description
Connection
Name of the target connection.
Target Type
Type of the target object. Select Single Object or Parameter.
Object
Name of the target object for the mapping.
Operation
Target operation. Select Insert, Update, Upsert, or Delete.
The following table describes the Microsoft Dynamics CRM advanced target properties that you can configure in a Target transformation:
Advanced Property
Description
Ignore Null Values
If you select the check box, the update operation ignores the null value for the column.
By default, the Ignore Null Values check box is not selected, and the update operation updates the column with the null value.
Alternate Key Name
Specifies the name of the key created in Microsoft Dynamics 365 for Sales. You can use alternate key in update, delete, and upsert operations.
Alternate key contains one or more fields. Map all the fields or attributes that are part of the alternate key.
If you map both primary key and alternate key attributes in a mapping, the primary key takes precedence over the alternate key.
Write Picklist Values
Writes string values for picklist fields.
By default, the check box is not selected.
Write to Collection Values
Writes to the collection valued fields of the entity. You can use insert operation to add an association. You can use delete operation to delete an association.
By default, the check box is not selected.
Run as Batch
Writes records in batch mode during data load. In batch mode, you can write multiple records in a batch.
By default, the Run as Batch check box is not selected and the Secure Agent does not write records in batch mode.
Batch size
Maximum number of records that the Secure Agent can write in a batch.
The default value is 10. The maximum value is 1000.
Transactional Write
Writes each record in a single transaction. The transactional write mode supports the following operations:
  • - Insert.
  • - Update/Upsert.
  • - Delete.
By default, the Transactional Write check box is not selected.
Batch Retry
Indicates whether the Secure Agent must attempt connection retries in the event of a connection failure while writing data in batch mode.
By default, the Batch Retry check box is not selected.
Batch Error File Path
The location and file name where the Secure Agent stores the error log. Applicable only if the Run as Batch check box is selected.
Success File Directory
Not applicable.
Error File Directory
Not applicable.
Forward Rejected Rows
Not applicable.