Skip to main content

Master Data Services in SQL Server 2012

Use the following resources to help understand, install, configure, manage, and troubleshoot Master Data Services (MDS) in SQL 2012.

 

What is MDS?

 

How Do I Use MDS?

 

MDS One-Day Course

Topic MaterialDuration
Master Data Services OverviewVideo | Slides45 min
Managing Data Warehousing Dimensions with MDS, Part 1Video | Slides15 min
Managing Data Warehousing Dimensions with MDS, Part 2Video15 min
Data Loading via Entity Based Staging (EBS)Video | Slides30 min
MDS Hierarchies and CollectionsVideo | Slides30 min
Business Rules and Workflow in MDSVideo | Slides30 min
MDS Model Migration and UpgradeVideo | Slides30 min
Security Features and Guidelines in MDSVideo | Slides30 min
Eliminate Duplicate Data with the MDS Add-In for ExcelVideo | Slides30 min

 

Featured Videos

Documentation

 

Resources for an MDS Deployment

 

Frequently Asked Questions

 

What is the SQL engine version that can be used with MDS deployment?

  • MDS in SQL Server 2012 can work against SQL Server 2008 R2 and SQL Server 2012 engine.

What Excel versions supported by the MDS Add-in for Excel?

  • Office 2007 & Office 2010

How do I integrate MDS with SharePoint?

  • Two new features have been introduced to contribute to SharePoint integration:
    • The Master Data Manager web UI can now be cropped for better display in SharePoint or other websites. By adding the query parameter &hosted=true to the website URL, you remove the header, the menu bar, and padding at the bottom of the page. For more information, go to Display the Master Data Services Web Application in SharePoint (en-US)
    • When using the MDS Add-in for Excel, you can create a shortcut query file to connect and load frequently-used data from the MDS repository into the Add-in. These query files are XML files that can be saved to SharePoint in order to be shared with users who want to access the same dataset. For more information, go to Shortcut Query Files (MDS Add-in for Excel)

Where do I find guidelines for deploying MDS?

How do I upgrade from SQL Server 2008 R2?

Where do I find capacity and performance information?

More...

 

Additional Resources

 

Books

Case Studies