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

Introduction


The method of extracting data from MDS will depend on the requirements of the system that is consuming the data. For Operational MDM, there may be a need to make master data available to an application in near real time. On the other hand, for Analytical MDM, the general requirement will probably be to feed data to a data warehouse on a daily basis, rather than in real time.

MDS provides two core methods of extracting data, namely:

  • Subscription Views

  • Application Programming Interface (API)

The Subscription Views are MDS objects, created in Master Data Manager or via the API, that allow the extraction of data by implementing physical views in the MDS database.

MDS provides a Web Service API that allows a developer to access all of the functionality of MDS via code. Anything that can be done in the Master Data Manager front-end can also be done via the Web Service API, including the ability to retrieve the members of an entity.

This chapter will focus on Subscription Views as we will...