O'Reilly logo

Microsoft SQL Server 2008 R2 Master Data Services by Jeremy Kashel, Tim Kent, Martyn Bullerwell

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Workflow and SharePoint

So far in our examples, we've been changing our master data as and when we wish. In the real world, this would be much more controlled with security, and might even require approval from a business owner or stakeholder before the change is accepted.

MDS business rules can help with this scenario, as, with a bit of creativity, it's possible to use attributes, business rules, and notifications to create a simple workflow. Essentially we would create an additional attribute, called "MemberStatus", that relevant users can change to Approved or Rejected. If we check for a condition of "MemberStatus = Rejected", then we can have an Is Invalid validation action that we know from the previous section will cause a notification to ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required