No more typing reviews! Try our Samantha, our new voice AI agent.

Pros & Cons summary

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Microsoft MDS is easy to deploy and provision, simplifying machine setup.
Integration with Azure Active Directory and compatibility with ETL tools like SSIS enhances its operational value.
The Excel plug-in allows direct connection to MDS, enabling efficient data maintenance and management.
Microsoft MDS supports comprehensive master data management without code requirements, making it accessible to non-technical users.
The zero incremental license cost and reduced errors provide excellent ROI and operational improvements.

CONS

Most Microsoft partners lack technical expertise, necessitating substantial training costs for companies.
Microsoft MDS is outdated, lacks modern capabilities, and might not be maintained going forward.
Integration into other Microsoft products and cloud solutions like Azure could be significantly improved.
True MDM implementation requires additional tools like DQS and SSIS, as Microsoft MDS lacks essential components.
Stability issues, such as duplications and processing delays, can disrupt operations if not properly managed.
 

Microsoft MDS Pros review quotes

NA
Data Management Consultant at a tech services company with 51-200 employees
Jun 8, 2026
The zero incremental license cost plus the operational improvements from having clean, consistent master data, reduced errors, faster reporting, and cleaner compliance provide a solid ROI.
AB
Senior Data Engineer at a insurance company with 5,001-10,000 employees
Feb 21, 2025
It has been a long-standing tool in our organization since it was free.
Satyam Saxena - PeerSpot reviewer
Technical Lead at a computer software company with 5,001-10,000 employees
Oct 2, 2024
The most valuable feature of Microsoft MDS is its compatibility with ETL tools like SSIS, which simplifies operations for end-users.
Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,644 professionals have used our research since 2012.
Pierre Godard - PeerSpot reviewer
Senior Data Manager at Clear Data Solutions
Sep 15, 2023
Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.
Ashu Singh - PeerSpot reviewer
Senior quality analyst at Lalli
Sep 21, 2023
The solution is easy to install.
Srinivas Nandula - PeerSpot reviewer
Lead Developer at Liberty Specialty Markets
Jan 26, 2023
The ease of use is valuable.
Pierre Godard - PeerSpot reviewer
Senior Data Manager at Clear Data Solutions
Jun 10, 2023
The tool is easy to use.
reviewer2131398 - PeerSpot reviewer
Senior Product Manager at a computer software company with 51-200 employees
Apr 6, 2023
The best thing about it is that it comes with the Microsoft package.
Fabian Pieterse - PeerSpot reviewer
Lead Developer at HaynesPro
Sep 6, 2022
The backup and restore functionality are the solution's most valuable aspects.
Satyam Saxena - PeerSpot reviewer
Technical Lead at a computer software company with 5,001-10,000 employees
Oct 12, 2021
Enables non-technical people to directly interact with the BI system.
 

Microsoft MDS Cons review quotes

NA
Data Management Consultant at a tech services company with 51-200 employees
Jun 8, 2026
The future of the product is genuinely uncertain, and that's something any organization evaluating it needs to factor in seriously.
AB
Senior Data Engineer at a insurance company with 5,001-10,000 employees
Feb 21, 2025
Microsoft MDS is outdated and lacks modern capabilities.
Satyam Saxena - PeerSpot reviewer
Technical Lead at a computer software company with 5,001-10,000 employees
Oct 2, 2024
If Microsoft MDS were part of Azure, it would be significantly more helpful.
Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: June 2026.
900,644 professionals have used our research since 2012.
Pierre Godard - PeerSpot reviewer
Senior Data Manager at Clear Data Solutions
Sep 15, 2023
Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions.
Ashu Singh - PeerSpot reviewer
Senior quality analyst at Lalli
Sep 21, 2023
Microsoft MDS' language should be simple so everyone can use it easily.
Srinivas Nandula - PeerSpot reviewer
Lead Developer at Liberty Specialty Markets
Jan 26, 2023
JMD repositories have records that come in thousands and millions, which takes a long time to process.
Pierre Godard - PeerSpot reviewer
Senior Data Manager at Clear Data Solutions
Jun 10, 2023
From my understanding, MS, as of 2021, will not maintain the product going forward.
reviewer2131398 - PeerSpot reviewer
Senior Product Manager at a computer software company with 51-200 employees
Apr 6, 2023
Stability can be fragile at times. If you are not attentive or make a mistake, it can cause problems.
Fabian Pieterse - PeerSpot reviewer
Lead Developer at HaynesPro
Sep 6, 2022
The Microsoft license cost could be lower.
Satyam Saxena - PeerSpot reviewer
Technical Lead at a computer software company with 5,001-10,000 employees
Oct 12, 2021
There are occasions when the solution maintains SD and we get duplications of MDS.