locked
Approval In Master Data Services RRS feed

  • Question

  • We have requirement that if one subscriber has change the data which is maintained in master data service,

    So when we will move data to warehouse of master services db before that we want to have approval process. 

    if changes are approved by approver then changed should moved to MDM warehouse database. 

    Wednesday, January 6, 2016 7:46 AM

Answers

  • Hi Am89,

    According to your description, you need to approval setting before the data can be move to warehouse, right?

    there is a new feature in SQL Server 2016 Master Data Services, you can save pending changes to an entity into a change set. You can apply an existing change set to view and modify the pending changes, and you can commit an existing change set. If the entity requires approval for changes, you must save the pending changes into a change set and submit for approval. Please refer to the link below to see the details.
    https://msdn.microsoft.com/en-us/library/mt607159.aspx

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, January 8, 2016 2:25 AM

All replies

  • Hi Am89,

    According to your description, you need to approval setting before the data can be move to warehouse, right?

    there is a new feature in SQL Server 2016 Master Data Services, you can save pending changes to an entity into a change set. You can apply an existing change set to view and modify the pending changes, and you can commit an existing change set. If the entity requires approval for changes, you must save the pending changes into a change set and submit for approval. Please refer to the link below to see the details.
    https://msdn.microsoft.com/en-us/library/mt607159.aspx

    Regards,


    Charlie Liao
    TechNet Community Support

    Friday, January 8, 2016 2:25 AM
  • Hi Charlie,

    We were able to explore the approval functionality and it is working very well. 

    We have one question. Kindly suggest how we can identify who approved the changes. This is required for audit purpose. 

    Thanks,

    Nagendra.S

    Wednesday, March 15, 2017 9:38 AM