You can configure the session to write records in bulk mode. The PowerCenter Integration Service can write records to Microsoft Dynamics CRM by using the ExecuteMultipleRequest API. The Microsoft Dynamics CRM version must be a minimum of Microsoft Dynamics CRM 2011 Rollup 13.
Set the following target session properties to perform bulk loading:
Use Bulk
The PowerCenter Integration Service writes records in bulk mode during data load. PowerCenter Integration Service can process one bulk request for one session partition for on-premise deployment. For online deployment, the maximum partitions allowed for bulk load is two.
Maximum Batch Size
The number of records that PowerCenter Integration Service writes at a time during bulk load of data. The maximum bulk batch size you can configure for bulk load is 1000 records. The default is 50 records.
If the batch size is greater than 500, the session requires 512 MB minimum and 1024 MB maximum memory. If you do not increase the memory limits, the mapping might fail. Configure the
Java SDK Minimum Memory
limit to 512 MB and the
Java SDK Maximum Memory
limit to 1024 MB in the PowerCenter Integration Service in the Administrator tool.