Exporting Master Data White Paper Published

Exporting Master Data White Paper Published

Rate This
  • Comments 3

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.

--Jim van de Erve, Content and Community Experience Group, Microsoft

Leave a Comment
  • Please add 1 and 5 and type the answer here:
  • Post
  • Hi..I am quite new to MDS and trying to explore it. Can you suggest some tutorials which can help me to understand the concepts espcially the Business Rules in MDS...tutorial explaining with some practical scenarios would be quite helpful...

  • You might want to get the book called "Microsoft SQL Server 2012 Master Data Services " by Tyler Graham.  Though the book is talking about SQL12, it is mostly applicable for SQL14 as well.

    In addition, you can find MDS information from MDSN: technet.microsoft.com/.../ee633763.aspx

    Also if you search on internet, you can find plenty material for trainings and videos.

  • Could you share a comparison matrices between MDS and any other ETL tool like (oracle EDQ, IBM tool etc)?

Page 1 of 1 (3 items)