Boomi Platform has released a funtionality called ‘Find Changes’. So what does it do and how useful is it to build integration process?
- It is able to track the changes made to a document, and define whether this document is (newly created, updated or deleted). It will then sent this document to the path (Add, Update, Delete) accordingly.
- This is most useful when there are large amount of data (i.e. database tables, flat files) coming through the process. The ‘Find Changes’ step will parse each record (defined by key column(s)) for a specific profile down to the the appropriate path.
Here is an example of how it works:
- A flat file type Document 1 consists of three records (A, B, and C separated by colums).
- In the first execution, these three records will be split after the Find Changes step and sent down to the Add path as individual documents (we now have document A, B and C at the Add path).
- If there is no changes made to the Document 1, then no documents will be sent to any path.
- Record A has made some changes. On the next execution, document A will be sent down to the Update path.
- Record B has been removed from Document 1. On the next execution, document B will be sent down to the Delete path.
- A new record (record D) has been created in Document 1. On the next execution, document D will be sent down to the Add path.