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

Summary


We've covered a lot of ground in this chapter that can be summarized by the following key points:

  • Business rule in MDS are If/Then expressions that are made up of conditions and actions

  • The business rules are run on the following events:

    • Creating a member

    • Editing a member

    • Validating a version that can be carried out from the front-end using a stored procedure or using the API

  • Actions can change the value of member attributes, generate member values, and cause a member to be invalid

  • E-mail notifications are sent when a validation action is invoked

  • External actions can initiate a SharePoint workflow that can be used for complex approval processes

Looking ahead to the next chapter, we will cover using the Master Data Services API, and see how it can be used to create custom .Net solutions.