We performed a comparison between Informatica MDM and Microsoft MDS based on real PeerSpot user reviews.
Find out in this report how the two Cloud Master Data Management (MDM) Solutions solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The Provisioning tool is something that is really handy for everyone. It is my pick as the best feature."
"It is easy to create REST-based interfaces of the master data objects."
"The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation."
"Informatica MDM's most valuable feature is the interconnection between multiple Master Data domains."
"This is where I think MDM shines - with its strong fuzzy matching algorithm. This is the essence of Informatica MDM. Based on these results, I can write our match conditions and then perform the corresponding data management activities."
"I like the number of options that are presented with Informatica, fuzzy matching, and your screen."
"The most valuable features of Informatica MDM are its reliability, match functions, and integration capabilities. The out-of-box functionality of deduplication and built-in data models ensure faster implementation."
"It has flexibility in extending the data model."
"Unlike specialized tools, MDS is adaptable for various industries, making it a versatile choice for master data management."
"Compared to other databases, it is easier to manage and administer."
"More generic related things can be included in the services."
"It is very easy to deploy and provision a machine."
"The best thing about it is that it comes with the Microsoft package."
"The solution is easy to install."
"Technical support is very good."
"The most valuable feature of Microsoft MDS is its management."
"Pre-sales technical support is much better than post-sales technical support."
"The on-prem solution is harder to learn than the cloud-based versions."
"The solution doesn't directly connect to any of the analytical tools."
"This is a costly solution. We have several customers who evaluate it but then look for other solutions because of the cost. At present, Informatica MDM comes as an on-premises or cloud-based solution. I would like to see them offer a SaaS-based MDM model. I think they are working on it."
"From multiple masters that are there in Informatica MDM, we can improve the financials."
"It could be a bit more intuitive, rather than technically complex."
"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."
"We currently have issues with real-time integration."
"From my understanding, MS, as of 2021, will not maintain the product going forward."
"Microsoft MDS' language should be simple so everyone can use it easily."
"Stability can be fragile at times. If you are not attentive or make a mistake, it can cause problems."
"JMD repositories have records that come in thousands and millions, which takes a long time to process."
"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."
"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."
"More generic related things can be included in the services."
"There are occasions when the solution maintains SD and we get duplications of MDS."
Informatica MDM is ranked 1st in Cloud Master Data Management (MDM) Solutions with 45 reviews while Microsoft MDS is ranked 2nd in Master Data Management (MDM) Software with 20 reviews. Informatica MDM is rated 8.0, while Microsoft MDS is rated 7.6. The top reviewer of Informatica MDM writes "Optimize business processes while ensuring that users see a return on their investment from the use of the product". On the other hand, the top reviewer of Microsoft MDS writes "Useful Excel plug-in, good scalability, and good integration with SQL Server and other Microsoft products". Informatica MDM is most compared with Reltio Cloud, SAP Master Data Governance, Profisee, TIBCO EBX and Stibo STEP MDM, whereas Microsoft MDS is most compared with SAP Master Data Governance, Profisee, Reltio Cloud, TIBCO EBX and Oracle Data Relationship Management. See our Informatica MDM vs. Microsoft MDS report.
We monitor all Cloud Master Data Management (MDM) Solutions reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.
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.
It's probably worth to add the Microsoft promotes using CluedIn as MDM solution on Azure stack. Please have a look at the Microsoft documentation:
https://docs.microsoft.com/en-...
Last week Microsoft and CluedIn had a joined demo seesion. Perhaps you can ask for a link to a recording: https://www.linkedin.com/posts...
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.