Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Book Image

Microsoft SQL Server 2008 R2 Master Data Services

Overview of this book

Table of Contents (18 chapters)
Microsoft SQL Server 2008 R2 Master Data Services
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Notifications


As we saw when we covered versions in Chapter 5, MDS has the ability to send e-mail notifications. Business rules in MDS also have the ability to send notifications that can be useful to flag up issues in data quality, for example, to relevant users.

There is only one category of action that can cause the business rules to send notifications, namely the validation actions. When a validation action is invoked, if the rule has a notification user assigned, then a notification e-mail will be sent.

We will now walk through how to configure one of our existing rules to send a notification:

  1. Navigate to the MDS home page and click on the System Administration function.

  2. Hover over the Manage menu and select the Business Rules option.

  3. We originally set up a business rule called Required Fields, which enforces that the Name and City attributes cannot be missing. If a user is adding a member in the front-end, then we probably don't need a notification. On the other hand, if we're receiving...