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 mapping. |
Operation | Target operation. Select Insert, Update, Upsert, or Delete. |
Advanced Property | Description |
---|---|
Maximum Batch Size | Determines the maximum number of records the Secure Agent can write at a time during bulk load of data. Maximum value is 1000. Default value is 50. |
Thread Count | Number of parallel threads for data load. Set the appropriate value based on the hardware capabilities of the machine on which the Secure Agent runs. Default is 8. Thread count is not applicable for bulk. |
Use Bulk | Writes records in bulk mode during data load. By default, the Secure Agent does not write records in bulk mode during data load. |
Alternate Key Name | Indicates whether the column is an alternate key for an entity. Specify the name of the alternate key. You can use alternate key in update, upsert, and delete operations. Note: You must specify the name of the alternate key and not the field name. If you map both primary key and alternate key attributes in a mapping, the primary key takes precedence over the alternate key. |
Add Row Reject Reason | Select to add the reason for rejecting the rows in the reject file. Default is disabled. |
Row Timeout | Indicates the time taken in milliseconds to get a response from the CRM target when you write data to a CRM target. The request times out if a response is not received in the specified amount of time. Default is -1. By default, the write request does not time out. |
Enhanced Error File Format | Select to add the detailed reason for rejecting the rows in the reject file. For example, you can retrieve the timestamp, column name, target information using the enhanced error file format. Default is disabled. |
Success File Directory | Directory where the Secure Agent stores the success log files. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, the Secure Agent writes the success log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\success |
Error File Directory | Directory where the Secure Agent stores the error log files. Specify a directory path that is available on each Secure Agent machine in the runtime environment. By default, the Secure Agent writes the error log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\error |
Forward Rejected Rows | Forwards rejected rows to the next transformation. |