Modifying Salesforce Data
Modifying Salesforce Data
Introduction
There are two ways to modify Salesforce data:
-
SQL
INSERT
,UPSERT
,UPDATE
, andDELETE
statements, which are processed one at a time. They are not sent in batches to Salesforce.com. -
SF_TableLoader
, which supports bulk data operations
Choosing Between SQL Statements and SF_TableLoader
The SF_Tableloader
stored procedure has significant advantages over using SQL statements:
-
support for batch operations—a single API call can handle up to 200 rows with the SOAP API and 10000 with the BulkAPI. In contrast, SQL statements require an API call for each row of the query, so
SF_TableLoader
drastically reduces the number of API calls. -
error handling—errors are reported on a row-by-row basis, meaning you can quickly identify operations that failed on particular rows. This is not possible using SQL queries.
-
better performance—given its support for batch operations,
SF_TableLoader
is much more efficient.