We have been able to have one true copy of data with Master Data Services. It's improved our organization by removing redundancies. It has reduced the duplication across a number of different databases.
Data Architect at a government with 10,001+ employees
Excellent dynamic data masking, but needs to integrate better with Microsoft's other products
Pros and Cons
- "Technical support is very good."
- "The beauty with Master Data Services is that it's centralized in one place and the problem with other solutions is that most of them have been created in house."
- "The solution could be better integrated into Microsoft's other products."
How has it helped my organization?
What is most valuable?
The dynamic data masking, the row-level security, and the data quality business rules are the most valuable features of the solution.
What needs improvement?
The solution could be better integrated into Microsoft's other products.
One of the key features that it doesn't have is a data modeling feature. Everyone uses Microsoft, but not for modeling. They use IBM, SAP PowerDesigner, etc. It would be really good to combine this solution with a modeler. For me, that's what is missing.
In a future release, I would like to see a better link to SSIS, Microsoft's business intelligence product. I would also like to see improvements in the user interface.
For how long have I used the solution?
I've been using the solution for five years.
Buyer's Guide
Microsoft MDS
June 2026
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.
What do I think about the stability of the solution?
The solution is very stable.
What do I think about the scalability of the solution?
I believe the solution is easiest to scale when housed by Azure. In previous installations, we housed 20-50 people, max.
How are customer service and support?
Technical support is very good.
Which solution did I use previously and why did I switch?
Every installation that I previously worked on had some form of Microsoft MDS.
How was the initial setup?
I didn't handle the initial setup; it's dealt with by a different team. I believe it's very straightforward in terms of an installer having a model object package which contains all of the entities, attributes, groups, hierarchies, business rules, etc. And this is deployed as a package via an XML file. That's the standard way of doing it.
What other advice do I have?
We use the private cloud version of the solution.
The beauty with Master Data Services is that it's centralized in one place and the problem with other solutions is that most of them have been created in house. There is an overlap between them.
The big advantage of this solution is with regards to a data warehouse. What you can do is cleanse the data and make it consistent throughout the warehouse before it gets into it, so it guarantees consistency.
I'd recommend Microsoft MDS. It's the best MDM tool out there.
I would rate the solution seven out of ten.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Chief Data Officer at a tech company with 11-50 employees
Provides a secure way to manage master data. The business rules definition interface could be improved.
Pros and Cons
- "This product provides a robust, flexible, and secure way for my organization and our customers to manage master data without the need to write code."
- "The business rules definition interface could be improved."
What is most valuable?
- Web Service integration
- Customer Workflow Extensions
How has it helped my organization?
This product provides a robust, flexible, and secure way for my organization and our customers to manage master data without the need to write code. MDS provides excellent integration options and a range of features such as auditing, trace-ability, and change capture.
What needs improvement?
The business rules definition interface could be improved. It is not the most intuitive or easy to use GUI.
For how long have I used the solution?
We have used this for five years.
What do I think about the stability of the solution?
The product is very stable.
What do I think about the scalability of the solution?
No scalability issues. The product performs well and has good options in this regard.
How are customer service and technical support?
I would give technical support a rating of 9/10.
Which solution did I use previously and why did I switch?
This was the first MDM platform I had used.
How was the initial setup?
The setup was very straightforward. The installation wizard and the configuration manager are simple and intuitive.
What's my experience with pricing, setup cost, and licensing?
MDS is packaged as part of the Microsoft SQL Server platform and no additional license is required.
Which other solutions did I evaluate?
We evaluated Oracle and SAP.
What other advice do I have?
MDS can be setup and used very quickly to establish if it can bring value to your organization. Don't hesitate based on the perception that MDM software is complex to implement.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Microsoft MDS
June 2026
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.
Enterprise Architect - Information Management at a retailer with 1,001-5,000 employees
It was easy to deploy and configure in the cloud and to integrate with other Microsoft tools, but we've yet to see whether it will scale for millions of records.
Pros and Cons
- "We used Azure Cloud service to set it up, and it was very easy to setup and configure."
What is most valuable?
Its data quality, as well as integration with other Microsoft tools.
What was my experience with deployment of the solution?
No issues encountered.
What do I think about the stability of the solution?
No issues encountered.
What do I think about the scalability of the solution?
I have only used it for a small scale prototype, but I am looking to scale it for millions of records in the near future.
How are customer service and technical support?
Customer Service:
It's good.
Technical Support:It's good.
Which solution did I use previously and why did I switch?
We're using multiple solutions, and haven't actually switched it yet.
How was the initial setup?
We used Azure Cloud service to set it up, and it was very easy to setup and configure. Cloud setup is the way to go.
What about the implementation team?
We implemented it in-house.
Which other solutions did I evaluate?
We just looked at Gartner’s top leaders in this area.
What other advice do I have?
Start small and scale incrementally. Cloud would be the ideal deployment option.
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
What version are you on, please provide more details. Don't plan on millions of records unless on 2016 version - read my review. It starts to choke once you get anywhere near 100K records in an entity let alone millions. Its fine for small reference data - I used it extensively but just realize it does not scale well. The 2016 version is supposed to be much faster.
senior consultant at a tech vendor with 1,001-5,000 employees
The safety is good and it's pretty easy to generate queries
Pros and Cons
- "More generic related things can be included in the services."
What is most valuable?
The safety is good, and it's pretty easy to generate queries. Also, the GUI is friendly, with new features, like stored procedures. It is really easy to create a Microsoft service.
What needs improvement?
More generic related things can be included in the services.
For how long have I used the solution?
I have been using Microsoft MDS for three to four years.
What do I think about the stability of the solution?
The product is stable.
I rate the solution’s stability an eight out of ten.
What do I think about the scalability of the solution?
Ten people are using this solution daily in our project.
I rate the solution’s scalability an eight out of ten.
How was the initial setup?
The initial setup is easy because there is another procurement team in order to get it installed on our machines. In large organizations, everything is separated. There is a team for everything. We request a service, there is a procurement team which will analyze and install it on our servers.
What other advice do I have?
The data modeling capabilities are sufficient. We utilize it sparingly, primarily for generating a few schemas. Additionally, these schemas have remained unchanged.
I recommend the solution because GUI is good. it is very user-friendly. It doesn't require much knowledge to use the service directly, making it a pretty easy-to-use solution.
Overall, I rate the solution a seven out of ten.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company does not have a business relationship with this vendor other than being a customer.
Buyer's Guide
Download our free Microsoft MDS Report and get advice and tips from experienced pros
sharing their opinions.
Updated: June 2026
Product Categories
Master Data Management (MDM) SoftwarePopular Comparisons
Qlik Talend Cloud
Ataccama ONE Platform
SAP Master Data Governance
Semarchy xDM
TIBCO EBX
IBM InfoSphere MDM
Pimcore
Oracle Data Relationship Management
Riversand MDMCenter
SAS MDM
Enterworks Enable
Syniti Master Data Management
Infosys BPM
Buyer's Guide
Download our free Microsoft MDS Report and get advice and tips from experienced pros
sharing their opinions.
Quick Links
Learn More: Questions:
- How does Microsoft MDS (vs Informatica MDM) fit with Azure architecture?
- What are the strengths and weaknesses of using Informatica PIM as opposed to Stibo STEP?
- Reltio: Question about Master Data Management Capabilities
- Test Cases for MDM Implementation
- What are the biggest challenges in master data management implementation?
- What is the difference between master data management and data governance?
- Has anyone compared Informaticta to IBM to SAS for an MDM solution?
- Informatica MDM or Hybris PCM? Buy vs. Build?
- When evaluating Master Data Management, what aspect do you think is the most important to look for?
- Centralized Master Data Management (MDM) architecture: questions about out-of-the-box functionality and user-friendly environment















It is a lot better in 2016 Gary, not so much of a black art anymore.