Boomi Last Successful Run Date
Updated: Nov 2, 2022
✍️Points to keep in mind about Boomi’s “Last Successful Run Date” Process Property
Data synchronization is crucial to business as it ensures data across systems is accurate and consistent. One of the ways to sync incremental records is to retrieve those that are either created or modified since the last time the integration ran and Boomi’s “Last Successful Run Date” (aka LSRD) parameter is one convenient feature to achieve this objective.
🔺 LSRD is a date time value of a given process when it last completed successfully. LSRD is set automatically by the process when “Capture Run Dates” is enabled in the Process Options.
🔺 This value is set to the start time of the process execution and updated only when the process finishes without an error.
🔺 Remember to initialize the LSRD value when the process first executes in a new atom/environment. If not initialized, a default value of January 1, 1970 is taken.
🔺 Ensure to adjust LSRD if there are time differences between Boomi server and the source application from which records are retrieved.
🔺 The other more robust strategy is to capture the most recent last modified date from the records themselves, and persist that value upon successful completion.
🔺 Design process intelligently so that if the process fails midway because of an error record, the rerun should not create duplicate records. Leverage Upsert in the destination application or perform record existence check before insert to avoid duplicates.
👉 Use cases: Orders/Invoices/Accounts Sync between NetSuite and Salesforce, PIM integration with ERP/CRM applications.
Should you have anything more about LSRD, please write in comments.