• biinterfaceuser1.3918051298026816E12
  • NEWBIE
  • 0 Points
  • Member since 2014

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 0
    Questions
  • 1
    Replies

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

  • September 23, 2013
  • Like
  • 0