Can we trigger a custom workflow once all data has been validated (not by record) RRS feed

  • Question

  • Hi,

    I'm looking for a way to start a custom workflow in SQL MDS (2019) once all records have been validated. Here's the business scenario:

    - a user updates master data records (hundreds or even thousands)

    - business rules are validated against each record to validate integrity of data; if any issue, user fixes the data until all business rules are satisfied

    - an approval workflow may be put in place (optional) to confirm that the data owner is ok with the changes

    - once all business rules are satisfied (and approval given if an approval workflow has been setup), run a custom workflow (or other mean) that sends a message to Azure Service Bus to notify other systems that new data has been updated and that they can come and get it

    I've been able to successfully implement a custom workflow in .Net that sends the message, but the workflow is ran for each record, resulting in hundreds or thousands of messages. What I really need is one single message once all data is validated and approved so that other systems can get notified and come fetch the data.

    Is there any way this can be achieved in MDS?



    Wednesday, August 12, 2020 2:18 PM