Advanced Property | Description |
---|---|
Start Date | Start date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ. To perform a full read, do not use the Start Date and End Date properties. |
End Date | End date and time to capture the changed data. Use the following format: YYYY-MM-DD'T'hh:mm:ss.SSSSZ. To perform a full read, do not use the Start Date and End Date properties. |
Page Size | Number of rows that the Secure Agent fetches per page. Default is 100 rows. The maximum value is 1000. |
Get Deleted | Includes records that were deleted between the start date and end date for changed data capture. |
Advanced Property | Description |
---|---|
Replace All | Removes existing data from the child object before writing new data to the target. |
Batch Size | Number of rows that the Secure Agent writes in a batch to the target. When the batch size is 0, the Secure Agent writes data to the target one row at a time. When the batch size is greater than 0, the Secure Agent writes data to the target in batches of the specified size. The default value is 100. For insert and delete operations, the maximum value is 200. For upsert and update operations, the maximum value is 100. |
Success File | Name of the file that contains rows successfully written to the target. |
Reject File | Name of the file that contains rows that were not written to the target. |
Success File Directory | Directory for the success log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the success log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\success |
Error File Directory | Directory for the error log files. Specify a directory path that is available on each agent machine in the runtime environment. By default, the agent writes the error log files to the following directory: <Secure Agent installation directory>\apps\Data_Integration_Server\data\error |