Property | Description |
---|---|
Connection | Name of the target connection. |
Target Object | Name of the target object. |
Display technical names instead of labels | Displays technical names instead of business names. |
Display target fields in alphabetical order | Displays target fields in alphabetical order instead of the order returned by the source system. |
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 | Determines the 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:
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. |