Coming October 25: PeerSpot Awards will be announced! Learn more
Julia Frohwein - PeerSpot reviewer
Senior Director of Delivery at PeerSpot (formerly IT Central Station)
  • 1
  • 4

What advice do you have for others considering Microsoft MDS?

If you were talking to someone whose organization is considering Microsoft MDS, what would you say?

How would you rate it and why? Any other tips or advice?

PeerSpot user
8 Answers
Ariful Mondal - PeerSpot reviewer
Consulting Practice Partner - Data, Analytics & AI at FH
Real User
01 April 21

In my current organization, I'm recommending reviewing all of the product cataloging master data management. This is what I would recommend for anybody who wants to do master data management, they use this product. I would rate Microsoft MDS an eight out of ten.

Suman Jupudi - PeerSpot reviewer
Sr. Database Developer at Hill Physicians Medical Group
Real User
Top 5Leaderboard
04 March 21

I would highly recommend this solution. It is a very good tool. You don't need to implement a true MDM in order to implement MDS. You can automate a digital transformation where you can migrate your Excel and Access databases that are lying in silos to MDS. This way you would have true data governance, security, change tracking (CDC), and security versioning. There are a lot of features that are very beneficial. We'll be staying with MDS. I would rate Microsoft MDS an eight out of ten.

NipunaMaliga - PeerSpot reviewer
Systems Specialist at Zillione Technology
Real User
04 February 20

On a scale of one to ten, I would rate Microsoft MDS an eight. I'd give it an 8 and not a 10 because it lacks some features, such as machine learning.

PaulOhuche - PeerSpot reviewer
12 January 20

If I have to rate this program from one to ten, I will give it an eight. My advice to others would be to use an activity log. They should have a user account and they should keep track of every user that logs on, and the platform should keep track of it.

GaryM - PeerSpot reviewer
Data Architect at World Vision
Real User
Top 5Popular
02 September 20

Note tThere is some level of logging - you can look in the security area and some level of access although limited.  Also you can write your own extensions in the triggers so you could customize the logging yourself.

PeerSpot user
System Engineer at a university with 1,001-5,000 employees
Real User
15 December 19

I am an information security analyst and I research to stay up on the trends and to see what is happing on the market now because we run our Firewalls. I would recommend getting the correct licenses. From the article, they should get to know which licenses, because there are different agents of licensing. Ensure they get the right size servers. Ensure that they have the best technical expertise, to help with the implementation. Microsoft products are quite good. We run innovation Microsoft 2017 and it's pretty impressive. I would rate this solution a seven out of ten.

Decision Consultant at a consultancy with 1-10 employees
06 October 19

I would rate this solution a seven out of ten.

Learn what your peers think about Microsoft MDS. Get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
633,952 professionals have used our research since 2012.
Data Architect at a government with 10,001+ employees
Real User
31 July 19

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.

GaryM - PeerSpot reviewer
Data Architect at World Vision
Real User
Top 5Popular
20 April 15

Please see my review on itcentralstation.  I have used this product since beta for most of the last decade.

Bottom line:  Its sweet spot is reference data. Attempting to use it for large scale customer data or products will likely be very problematic.

The tool is integrated into Dynamics AX but there is not clear direction by Microsoft for improving and supporting the product as a stand alone long term. Use it with that knowledge and look for any indication from Microsoft that it will continue to support it or deprecate it. 

I would not recommend using any version prior to 2016.  

Curious people rate it 8 out of 10, but then what are they comparing it against?  No MDM solution?  It's really not going to compare to most MDM tools out there today but then...expect to pay a lot of $$ for other tools and this tool is usually free for most MSFT customers and may work totally fine - just depends on your needs. It has served my shop well for many years.  I've used many MDM tools and used worse as well as expensive like Oracle's tool that they got from Hyperion.  That said, this tool's future is uncertain and it has a LOT of bugs and no significant enhancement for a number of years. And it is very limited in what it does well as well as the volume of data it can handle.  But if it meets your needs then it makes a lot more sense than many overly complicated MDM tools if those are overkill for your situation.

Related Questions
Richard Tibbetts - PeerSpot reviewer
Information Architect at Canadian Food Inspection Agency
Feb 07, 2022 community, I work as an Information Architect at a Government company with 5000+ employees. I need a solution to manage client data across multiple systems: 4000 users 500,000 records Federal Government regulatory agency How does Microsoft Master Data Services (MDS) compare to Informatica MDM (or even Profisee) for integration with Azure? Which of...
2 out of 3 answers
Enterprise MDM Architect / Solution Arch at a energy/utilities company with 10,001+ employees
14 January 22
Hi @Richard Tibbetts, There's no short answer to your question. Nearly all existing MDM solutions on the market offer a broad range of patterns to ingest master data from various sources and distribute cleanse and consolidated information, also to the Azure stack. Many vendors offer prebuilt connectors for the most common sources (databases, various file types, storages, business applications including MS Dynamics, Salesforce, etc.), but also support a generic way of ingesting/exposing data via Rest APIs, file drops, etc. MS MDS is an extension of the MS SQL server 2016. I don't know Microsoft plans to extend it, but I know that Profisee and CluedIn are very active in promoting their solutions as-built having Azure in mind and being a part of the stack. Informatica MDM has three types of offerings these days: on-prem, hosted MDM, and cloud-native option - they differ in the functionality and integration options. Obviously, there are many more MDM tools on the market particularly good in various data domains (products, customers/suppliers - so yours, multi-domain, etc). I think that you should start your MDM journey by answering which current challenges you try to solve or what new capabilities you need to enable to the organisation. Once these questions are answered and based on your organization's Enterprise Architecture principles, look for the best fitting tool. It may (or may not) be the one that fits the best into the Azure Reference Architecture. I hope this helped.
GaryM - PeerSpot reviewer
Data Architect at World Vision
04 February 22
I agree with @InitZero...  I would add that there's no future roadmap for MDS and they don't have an Azure solution for it.  Since it's a free product with an SQL license, don't expect Microsoft to invest in it.   Even though we are highly dependent upon it currently I'm starting to look towards the future where we need to find a replacement - hopefully, a PaaS solution. It would be great if Microsoft came out with something in Azure but I'm not hopeful at this point.
Avigail Sugarman - PeerSpot reviewer
Community Manager at PeerSpot (formerly IT Central Station)
Feb 10, 2015
I am looking for a detailed comparison between Informatica vs. Dataflux vs. Oracle from an MDM perspective on the following parameters:CostEase of use / Learning curvePerformanceReliabilityUsabilityReusabilityArchitecture consistencyFeature supportScalabilityPortabilitySupport from vendorDebugging consoleExtendibility Ability to notify Change look & feel Customize Screens/UI/Rul...
See 2 answers
it_user152100 - PeerSpot reviewer
MDM Project Designer at a non-profit with 1,001-5,000 employees
30 January 15
Hi, We did not take an “off-the-shelf” MDM solution but we developed our own projects. For that reason unfortunately I cannot provide you with comparison of MDM solutions. Best regards, Sanja Zore’
PeerSpot user
CEO at Loschiavo Enterprises
10 February 15
Hey Russell, I saw your email asking about *Informatica vs. Dataflux vs. Oracle.* *What about Riversand Technologies and their product MDMCenter? * * * *[image: Inline image 1]*
Related Solutions
Download Free Report
Download our free Microsoft MDS Report and get advice and tips from experienced pros sharing their opinions. Updated: September 2022.
633,952 professionals have used our research since 2012.