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."It has flexibility in extending the data model."
"Informatica MDM's most valuable feature is the interconnection between multiple Master Data domains."
"In the latest version, I like the outlay of the business roles creation. I like seeing that visualization as you're building it, as opposed to going through metatables or XML mappings. We liked that piece, and it makes it more intuitive for the business."
"The valuable feature is that we can automate the integration part...It is a stable solution."
"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."
"It has been leading the market with hierarchy management and all the different match concepts and algorithms. They're very robust."
"I think that it's a good solution...It is stable because we have the experience to deploy this solution."
"The ability to aggregate and put together data from around fifty sources into one environment allows us to have a preview of everything in a single place, which is something we did not have previously in our company."
"Technical support is very good."
"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."
"It's very easy to use."
"The most valuable feature of Microsoft MDS is its management."
"The ease of use is valuable."
"Enables non-technical people to directly interact with the BI system."
"What I like about Microsoft, is that it has a huge database with many users."
"The best thing about it is that it comes with the Microsoft package."
"We currently have issues with real-time integration."
"Pre-sales technical support is much better than post-sales technical support."
"Their support should be improved. We have had some trouble with their support from time to time. Its scalability should also be improved. I would also like to have a bit more modern and friendly UI for the end-users. There should definitely be a simplified way to configure and set it up."
"Informatica MDM could be improved by adding drag and drop options, business data insights, and visualization reporting."
"Informatica MDM can improve the data catalog and data marketplace."
"We promote our code changes from a lower to a higher environment, which is highly complex when working with a multi-domain MDM like Informatica. This is the biggest obstacle for Informatica MDM, and I think they should change it because that's very time consuming."
"The biggest pain point for us is the documentation. Typically, you have to go through knowledge forums and knowledge groups to find out about the syntax issues for interfacing with new products. Typically, you've got to deal with someone who has been through the pain before. Their documents are not really up to date with current innovations happening in the industry. As big as they are, you can't really expect it, but that's our pain point."
"The configurations could be better. It is a bit confusing because we must develop two tools when building a data model in Informatica MDM. Even though Informatica MDM is a single tool, we have our hub console plus the provisioning tool within that. Whatever data model we are building in the hub console, we have to develop it in the provisioning tool again. It is double the work to create a data model. We are also using external calls or the Java custom plans functions. This can be both positive and negative. Since MDM as a client does not support any complex validation, we have to depend on the external call or a Java call. Every time we deployed, the entire solution was impacted if something went wrong."
"Microsoft MDS' language should be simple so everyone can use it easily."
"JMD repositories have records that come in thousands and millions, which takes a long time to process."
"The stability could be improved."
"Stability can be fragile at times. If you are not attentive or make a mistake, it can cause problems."
"The solution could be better integrated into Microsoft's other products."
"There are occasions when the solution maintains SD and we get duplications of MDS."
"Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions."
"It would be a better option to have an on-cloud version."
Informatica MDM is ranked 1st in Cloud Master Data Management (MDM) Solutions with 43 reviews while Microsoft MDS is ranked 2nd in Master Data Management (MDM) Software with 18 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, IBM InfoSphere MDM and Stibo STEP MDM, whereas Microsoft MDS is most compared with Profisee, SAP Master Data Governance, TIBCO EBX, Reltio Cloud and Semarchy xDM. 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.