The PowerCenter Integration Service can use the Salesforce Bulk API to write data to Salesforce targets. Use the Bulk API to write large amounts of data to Salesforce with a minimal number of API calls. You can use the Bulk API to write data to Salesforce targets with Salesforce API version 20.0 or higher. With a Bulk API write, each batch of data can contain up to 10,000 records or one million characters of data in CSV format.

You can configure a Bulk API target session to load batches at the same time or serially. You can also monitor the progress of batches in the session log, and create success and error logs for row-level information.

To configure a session to use the Bulk API for Salesforce targets, select the Use SFDC Bulk API session property. When you select this property, the PowerCenter Integration Service ignores the Max Batch Size session property.

The PowerCenter Integration Service ignores the Stop on Error session property for Bulk API target sessions.

When you configure error logging for a relational database, the PowerCenter Integration Service does not load the error messages to PMERR tables for the Salesforce target.

Before you run a Bulk API target session, configure the Java temporary directory on the PowerCenter Integration Service machine.