Tuesday 4 March 2014

Enabling Bulk API option in Data Loader

The Bulk API is optimized to load or delete a large number of records asynchronously. It is faster than the SOAP-based API due to parallel processing and fewer network round-trips. By default, Data Loader uses the SOAP-based API to process records.
To configure Data Loader to use the Bulk API for inserting, updating, upserting, deleting, and hard deleting records:

  1. Start Data Loader by choosing Start | Programs | salesforce.com | Data Loader | Data Loader.
  2. Choose Settings | Settings.
  3. Select the Use Bulk API option.
  4. Click OK.

Note: You can also select the Enable serial mode for Bulk API option. Processing in parallel can cause database contention. When this is severe, the load may fail. Using serial mode guarantees that batches are processed one at a time. Note that using this option may significantly increase the processing time for a load.

1 comment:

  1. Also

    To maintain the format or special characters while uploading/extracting the data using dataloader need to enable two options in settings of an data loader:

    Read all CSVs with encoding & Write all CSVs with encoding.

    I have enabled this two fields while insertion/updating to maintain the "Chinese" chars in the production.

    ex:
    http://salesforce.stackexchange.com/questions/18124/issue-extracting-special-character-with-apex-data-loader-28-0-2

    Thanks!! Anu

    ReplyDelete