[SalesForce] Bulk data update in Salesforce from External System

I have got a requirement to update 6k records in Salesforce from external system in every 4 hours. Can you please suggest what would be best way for this .

1) Should I use the standard Bulk API ? How to handle all batch process that will be created ?

2) Is SOAP a good option too? I know , it's not in much use nowadays.

3) Can I think of REST in HTTP Post as well for this much of data ?

Please advice the best approach.

P.S. I can't use a middleware integration tool.

Best Answer

Since 6k is not a big data volume, you can go for either bulk API or SOAP API. But please give first preference to Bulk API. Details regarding how to implement Bulk API can be found in below link,

https://developer.salesforce.com/page/Loading_Large_Data_Sets_with_the_Force.com_Bulk_API

SOAP API also can be used. For connecting with SOAP API also there is lot of examples in developerforce. Checkout below link to get details regarding all APIs

https://help.salesforce.com/HTViewHelpDoc?id=integrate_what_is_api.htm

Related Topic