Loading

Use Data Loader with the Bulk API

Fecha de publicación: Aug 29, 2024
Descripción

The Data Loader is flexible and designed to handle a large range of data as per the When to Use Data Loader documentation.

Depending on the exact nature of the operation being performed, it's generally recommended to use the Bulk API mode when working with records totaling in the hundreds of thousands. See the When to Use Bulk API section of the Bulk API Developer Guide for more details. Set the Data Loader to run using the Bulk API as outlined in the Configure the Data Loader to Use the Bulk API documentation.
 
Solución

Before using the Data Loader in Bulk API mode review General Guidelines for Data Loads, Data Loader Behavior with Bulk API Enabled and How are API calls consumed by Data Loader?

Once the "Use Bulk API" option is selected you can Insert, Update, or Delete Data Using Data Loader as you typically would under normal circumstances. However, with Bulk API enabled you'll find that a corresponding Job will be created server side (in Salesforce) which you can view by navigating to Setup and enter Bulk Data Load Jobs in the Quick Find box, then select Bulk Data Load Jobs.
 
It is recommended to leave the Data Loader application open and running until it has finished submitting all of the batches required for the Job. You can tell when the client side operations being performed via the Data Loader are complete when the corresponding job in the Bulk Data Load Jobs queue shows a status of Closed. See Work with Jobs for more details on different status definitions. Once the job status is closed you can exit and or close the Data Loader on your local machine or ignore any subsequent error messages received in the Data Loader's user interface.

If the Data Loader throws an error before the Job's status is set to Closed it is recommended to abort the job and retry the operation again. See BULK API Developer Guide - Errors, Common Data Loader error messages, and Handle Failed Records in Batches.

If the error persists and you have any questions or concerns contact Developer Support via a Support case.

Note: Developer Support is only available to customers and partners with Premier Success plans. Basic Support customers may leverage the community and forums where there is a wealth of information to assist you. The forums are located at https://developer.salesforce.com/.  The forum is the perfect place to have your technical questions answered, acquire links to technical documentation, receive advice on best practices, and acquire code samples from other dedicated Salesforce users.

Once the "Use Bulk API" option is selected in Settings for Data loader. Batch size is set default to 2000. Batch size can be increased upto 10,000 for faster and efficient processing. 


When contacting Support document the exact date/time, Bulk Job Id and error received with the Data Loader log files outlined in the View the Data Loader Log File article.
 
Número del artículo de conocimiento

000382601

 
Cargando
Salesforce Help | Article