2

Scenario: I have to push about 2000 records (10 Text Fields each) from an Enterprise Server into Force.com 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?

Improve this question
3
  • 2
    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. wiki.developerforce.com/page/…
    – techtrekker
    Commented Feb 14, 2013 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
    Commented Feb 14, 2013 at 18:53
  • 1
    Also take a look at the Jitterbit Data Loader. Really easy to use!
    – Daniel Hoechst
    Commented Feb 14, 2013 at 22:29

2 Answers 2

Reset to default
2

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.

Improve this answer
2

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.

Improve this answer
2
  • 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?
    – KaLi
    Commented Feb 21, 2013 at 8:51
  • Ya you may be able to use enterprise WSDL for sure .
    – Mohith Shrivastava
    Commented Feb 21, 2013 at 9:15

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .