Apex Code Development You need to sign in to do that
Don't have an account?
jd_06 Bulk API - Informatica
Hello - The company I work for has an integration with a .NET application that updates Account records on a nightly basis. The business wants the Account records updated on a more frequent basis. However when we try to update the records more frequently we run into the issue of getting locked records, particularly during business hours, which prevents the record updates.
Our integration uses Informatica to map the data and update records. Informatica allows us to use the Bulk API to update records (for those that know Informatica, it's a checkbox on the Session). The advantage of using the Bulk API is that it runs asynchronously. By running asynchronously, we would/should avoid our locked record issues.
My question is, is there any ill side effects of running Bulk API despite not having large record sets? Our record sets would probably be in the 5 to 10 range every time the job runs.
...or are there any other options for running a frequent integration asynchronously to avoid record locks?
Any advice or knowledge share would be greatly appreciated.
Thank you
Jason
Hi Jason,
Default batch size for bulk api is 10,000. Using a smaller batch size may cause an organization to use more of their alloted bulk api batches per day than is necessary.
May be you can go for Streaming API which is near real time and asynchronous.
Refer: https://help.salesforce.com/HTViewHelpDoc?id=integrate_what_is_api.htm&language=en_US
All Answers
Hi Jason,
Default batch size for bulk api is 10,000. Using a smaller batch size may cause an organization to use more of their alloted bulk api batches per day than is necessary.
May be you can go for Streaming API which is near real time and asynchronous.
Refer: https://help.salesforce.com/HTViewHelpDoc?id=integrate_what_is_api.htm&language=en_US
Jason
--
Lokesh