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

Microsoft MDS pros and cons

Vendor: Microsoft
3.8 out of 5
Badge Leader
1,166 followers
Post review
 

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: December 2024.
824,053 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: December 2024.
824,053 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.