Try our new research platform with insights from 80,000+ expert users
Microsoft MDS Logo

Microsoft MDS pros and cons

Vendor: Microsoft
3.7 out of 5
Badge Leader
1,169 followers
Start review

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 offers excellent technical support.
The administration console is a highly valuable feature.
It integrates seamlessly with SQL Server and SSIS for ETL processes.
Its compatibility with ETL tools like SSIS simplifies operations for end-users.
It is an adaptable choice for master data management across various industries.

CONS

Microsoft MDS lacks integration with other Microsoft products and a true MDM component, requiring additional tools like DQS and SSIS.
The lack of an on-cloud version limits users seeking more flexible deployment options.
Support and updates for Microsoft MDS are diminishing as Microsoft focuses more on cloud solutions.
The stability of Microsoft MDS can be fragile, with potential issues arising if not properly managed.
Microsoft MDS is considered outdated, lacking modern capabilities and ease of use.
 

Microsoft MDS Pros review quotes

SJ
Mar 4, 2021
It has a very good feature called Excel plug-in. You just have to install the plug-in, and then it directly connects to the MDS instance where you can maintain and manage your data and publish it right through Excel. You don't need to go to the front end to make any changes. It has easy integration with SQL Server, and you can use SSIS to do the ETLs. It is a part of the Microsoft stack. It works with most of the Microsoft stuff.
Pierre Godard - PeerSpot reviewer
Jun 10, 2023
The tool is easy to use.
Pierre Godard - PeerSpot reviewer
Sep 15, 2023
Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management.
Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
842,388 professionals have used our research since 2012.
Satyam Saxena - PeerSpot reviewer
Oct 12, 2021
Enables non-technical people to directly interact with the BI system.
Satyam Saxena - PeerSpot reviewer
Oct 2, 2024
The most valuable feature of Microsoft MDS is its compatibility with ETL tools like SSIS, which simplifies operations for end-users.
reviewer1222620 - PeerSpot reviewer
Dec 15, 2019
It is very easy to deploy and provision a machine.
reviewer2131398 - PeerSpot reviewer
Apr 6, 2023
The best thing about it is that it comes with the Microsoft package.
Fabian Pieterse - PeerSpot reviewer
Sep 6, 2022
The backup and restore functionality are the solution's most valuable aspects.
Archidata67 - PeerSpot reviewer
Jul 31, 2019
Technical support is very good.
AM
Apr 1, 2021
It's very easy to use.
 

Microsoft MDS Cons review quotes

SJ
Mar 4, 2021
The only drawback is that it does not have the matching, merging, and all true MDM components. For these, you have to use another competent called Data Quality Services (DQS). You need to plug it in and use it along with MDS for true MDM. Both of these are integrated together, but you have to do them separately, whereas, in Profisee, there are a couple of screens where you can configure the matching process, create matching rules, and other things, and everything is in one product, which is not the case with MDS. In order to implement a true MDM, you need MDS, DQS, and SSIS. You have to use MDS to store your golden records, DQS to configure and standardize all your rules and matching percentages, and SSIS to load the data to DQS and MDS. At the same time, you also need Melissa Data to clean up your addresses to validate and standardize the addresses. That's the main component of true MDM. It would be good if they can create a true matching component inside MDS and merge MDS and DQS.
Pierre Godard - PeerSpot reviewer
Jun 10, 2023
From my understanding, MS, as of 2021, will not maintain the product going forward.
Pierre Godard - PeerSpot reviewer
Sep 15, 2023
Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions.
Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: March 2025.
842,388 professionals have used our research since 2012.
Satyam Saxena - PeerSpot reviewer
Oct 12, 2021
There are occasions when the solution maintains SD and we get duplications of MDS.
Satyam Saxena - PeerSpot reviewer
Oct 2, 2024
If Microsoft MDS were part of Azure, it would be significantly more helpful.
reviewer1222620 - PeerSpot reviewer
Dec 15, 2019
Most of the Microsoft partners, especially digitally, are separate. Personnel are business people, and they do not have technical expertise, so you end up as a company spending a lot of money training your staff and your engineers.
reviewer2131398 - PeerSpot reviewer
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
Sep 6, 2022
The Microsoft license cost could be lower.
Archidata67 - PeerSpot reviewer
Jul 31, 2019
The solution could be better integrated into Microsoft's other products.
AM
Apr 1, 2021
It would be a better option to have an on-cloud version.