Skip to main content The new Salesforce certifications experience is live! Visit Trailhead Academy to explore your new certifications homepage.
Topics#Desktop IntegrationJason Driscoll's Question
Jason Driscoll asked in #Desktop Integration
Sep 23, 2013, 5:10 PM

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
9 answers
Loading
  1. Gnana Silaparasetti (Salesforce)
    Feb 19, 2018, 6:28 PM
    Yup Yury! In informatica you should see the serial mode from advanced salesforce options sections from schedule main tab. Screen shot here.

     

    Yup Yury! In informatica you should see the serial mode from advanced salesforce options sections from schedule main tab. Screen shot here.
Write an answer...
0/9000