Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Scenario: I have to push about 2000 records (10 Text Fields each) from an Enterprise Server into every night (a scheduled activity). I am planning the below approach.

Using the Enterprise API, wanted to understand the viability of implementing the above scenario? Can it handle the above volume? What other approach you suggest?

share|improve this question
you can also consider using scheduled data loader command-line, which can be configured to push data. it uses the soap api behind the scenes.… – techtrekker Feb 14 '13 at 18:18
This would be my first blush as well. Command line = easily scheduled. And since it is the data loader, it won't matter if that number is 100x more in a year. – joshbirk Feb 14 '13 at 18:53
Also take a look at the Jitterbit Data Loader. Really easy to use! – Daniel Hoechst Feb 14 '13 at 22:29

That volume can be easily handled by the Salesforce API. I've done integrations that push 100k records + a day. When you get to that level, it is better to use the Bulk API. At your volumes, you would be fine with the Enterprise WSDL.

share|improve this answer

2000 records update in a context salesforce easily allows .The limit of apex is 10000 rows .So even apex webservice will work for your data .Enterprise WSDL is also a good choice as far as your data volume is concerned .

One common best practice is always think about " worst case " scenario .If your Worst case maximum load is 2k records enterprise WSDL is good choice .If your data volumes are unpredictable and may exceed 100K go for the Bulk API.

share|improve this answer
Thanks, Is 2K records are the maximum an Enterprise WSDL can handle? I guess it is the maximum per call. In case if I have 10K records will I be able to use Enterprise WSDL approach? – sKaLiDhAsAn Feb 21 '13 at 8:51
Ya you may be able to use enterprise WSDL for sure . – Mohith Shrivastava Feb 21 '13 at 9:15

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.