[This post was created by Jim van de Erve of the Content and Community Experience Group, Microsoft.]
Microsoft SQL Server 2012 Master Data Services (MDS) enables you to build and manage master data for your operational or analytical needs. But how do you export that master data from MDS into your systems? The "Exporting Master Data from Master Data Services" white paper at http://msdn.microsoft.com/en-us/library/jj218341.aspx shows you how. It describes the subscription views that you can export your master data into, and shows how to use SQL Server Integration Services (SSIS) to import your master data from a subscription view into a SQL Server table. Included is a step-by-step procedure that demonstrates how to set the process up, with sample T-SQL.
© 2012 Microsoft Corporation. All rights reserved. This information is
provided “as-is”. Information and views expressed, including URL and other
Internet Web site references, may change without notice. You bear the risk of
using this information. Examples are provided for illustration only. Provision
of this information does not provide you with any legal rights to any
intellectual property in any Microsoft product. You may copy and use this
information for your internal, reference purposes only.