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


In this chapter, we have covered the methods available for extracting data from Master Data Services. In particular, we have learnt:

  • BizTalk and SSIS can be used to deliver master data to downstream systems

  • Subscription Views result in a physical SQL Server view being created in the MDS database

  • Leaf and Consolidated Members, Collections, Explicit Hierarchies, and Derived Hierarchies can all be extracted from MDS using Subscription Views

  • Existing Subscription Views do not get updated automatically if a referenced object, such as an entity, has changed

Looking ahead to the next chapter, we will see how the MDS API can be used to extract and update data in MDS.