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

Informatica Intelligent Data Management Cloud (IDMC) vs Microsoft MDS comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Informatica Intelligent Dat...
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (10th), Business-to-Business Middleware (5th), API Management (7th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
Microsoft MDS
Average Rating
7.4
Reviews Sentiment
7.9
Number of Reviews
22
Ranking in other categories
Master Data Management (MDM) Software (3rd)
 

Mindshare comparison

While both are Data Integration and Access solutions, they serve different purposes. Informatica Intelligent Data Management Cloud (IDMC) is designed for Data Management Platforms (DMP) and holds a mindshare of 15.0%, up 14.0% compared to last year.
Microsoft MDS, on the other hand, focuses on Master Data Management (MDM) Software, holds 13.3% mindshare, up 13.0% since last year.
Data Management Platforms (DMP)
Master Data Management (MDM) Software
 

Featured Reviews

Saikat Ghosh - PeerSpot reviewer
Match and merge functionality is still the best but cloud version needs more functionality
There are various areas for improvement in IDMC. Enhancements on basic data management functionality and the UI front, such as multiple templates and improved grid views, would be beneficial. Bulk data management features could be improved from the UI perspective to get to the level of the on prem versions of Informatica MDM. The tool needs to mature but missing small but important features, like restricted dynamic attributes functionality, data inheritance rules in master hierachies, identifiers not being passed in jobs is a drawback.
Satyam Saxena - PeerSpot reviewer
Enhanced data management and cost effective with flexible integration capabilities
If Microsoft MDS were part of Azure, it would be significantly more helpful. Additionally, integrating fuzzy duplication within MDS itself, rather than relying on SSIS, would streamline operations. The current requirement to store data in Azure tables after processing it in MDS, due to its lack of direct Azure integration, is a drawback.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The best thing about Informatica Axon is that it integrates with the Electronic Data Capture and the Axon system."
"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 tool manually checks on applying business rules and helps to implement them."
"Informatica is good for integrating data and cloud applications. We have connectors for integrating cloud applications like Salesforce. You can quickly integrate anything with an exposed API or a REST API. The industry is increasingly shifting to the cloud, so we need more products that can connect to cloud-based applications. The integration is seamless and works in real time. It's also secure because you don't need to expose databases or tables."
"Data synchronization tasks."
"The solution's technical support is pretty good, especially since the turnaround time is good."
"I have rated the stability a ten out of ten due to a high level of satisfaction."
"The governance process was fully manual before, but Axon helped us configure those processes, giving us more visibility, transparency, and control over the data."
"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."
"More generic related things can be included in the services."
"Technical support is very good."
"It has been a long-standing tool in our organization since it was free."
"Compared to other databases, it is easier to manage and administer."
"The most valuable feature of Microsoft MDS is its compatibility with ETL tools like SSIS, which simplifies operations for end-users."
"It is very easy to deploy and provision a machine."
"One of the main features I have found useful is the integration with Azure active directory."
 

Cons

"Error reporting and debugging need improvement."
"It can be improved in terms of performance and execution. I'm expecting better performance. It currently has some restrictions in terms of execution. For example, if we want to run it in the command mode and execute it, there are some restrictions, and we are facing some issues with a huge volume of data. These restrictions are not there in Informatica PowerCenter because we are able to execute a huge volume of data, and there are more ways to execute it."
"There are a small number of UI bugs that occur on occasion."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"The cloud version of Axon is far behind the on-prem, and many of my clients want to go fully to the cloud. However, Axon has to be an on-prem installation. I would like to see their cloud products catch up with their on-prem capabilities."
"Informatica MDM has limitations with connectivity."
"Its pricing model can be improved. The response time from technical support can also be improved."
"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."
"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."
"The solution could be better integrated into Microsoft's other products."
"In the next version, I would like to see integration with Azure."
"It would be a better option to have an on-cloud version."
"The stability could be improved."
"The Microsoft license cost could be lower."
"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."
"Microsoft MDS isn't getting strong support because Microsoft is focusing more on cloud solutions."
 

Pricing and Cost Advice

"Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
"The price is very high and has become a big concern for our customers who require the solution in order for their business to function smoothly."
"The pricing is high compared to other tools on the market."
"The product is not very pocket-friendly for small and medium-sized businesses, and it is understandable because of the kind of features the tool gives."
"I rate the product's pricing a seven on a scale of one to ten, where one is the lowest price and ten is the highest price."
"The platform has a premium cost. I rate the pricing as seven out of ten."
"The solution's pricing model is easy, but it is very expensive."
"We saw an ROI. We have been able to get data from various sources and consolidate it into a data lake, which is helping us in data analytics."
"I would like to see better pricing."
"MDS is a part of the SQL Server enterprise license. I am not aware of any additional costs."
"The solution does require a license and we have enterprise licenses."
"Microsoft MDS is an expensive solution."
"Product licensing is very complicated. It would be helpful to have an online calculator to estimate the cost of a license."
"The pricing of this solution is good."
"SAP is more expensive than Microsoft."
"With Microsoft, we buy everything though an agreement, so we purchase volume licensing every year."
report
Use our free recommendation engine to learn which Data Management Platforms (DMP) solutions are best for your needs.
860,632 professionals have used our research since 2012.
 

Answers from the Community

RT
Feb 7, 2022
Feb 7, 2022
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 i...
2 out of 3 answers
InitZero - PeerSpot reviewer
Jan 14, 2022
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.
GM
Feb 4, 2022
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.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
9%
Insurance Company
6%
Computer Software Company
14%
Financial Services Firm
13%
Manufacturing Company
9%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Azure Data Factory compare with Informatica Cloud Data Integration?
Azure Data Factory is a solid product offering many transformation functions; It has pre-load and post-load transformations, allowing users to apply transformations either in code by using Power Q...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
What are the biggest benefits of using Informatica Cloud Data Integration?
When it comes to cloud data integration, this solution can provide you with multiple benefits, including: Overhead reduction by integrating data on any cloud in various ways Effective integration ...
What do you like most about Microsoft MDS?
More generic related things can be included in the services.
What is your experience regarding pricing and costs for Microsoft MDS?
Microsoft MDS is free. Currently, there is no pricing concern with the tool.
What needs improvement with Microsoft MDS?
Microsoft MDS is outdated and lacks modern capabilities. It is too slow and does not support automated mapping or AI-based functionalities. Although I created Python scripts for some machine learni...
 

Also Known As

ActiveVOS, Active Endpoints, BPM, Address Verification, Persistent Data Masking, Cloud Test Data Management, PIM, , Enterprise Data Catalog, Data Integration Hub, Cloud Data Integration, Data Quality, Cloud API and App Integration
Microsoft Master Data Services, Microsoft MDM, Microsoft SQL Server Master Data Services, MS MDS
 

Overview

 

Sample Customers

The Travel Company, Carbonite
ETA a.s., Apeejay Surrendra Group, Blue Star Infotech, Rotherham Doncaster and South Humber NHS Foundation, The Sydney Children's Hospitals Network, New Belgium Brewing
Find out what your peers are saying about Palantir, Informatica, Oracle and others in Data Management Platforms (DMP). Updated: June 2025.
860,632 professionals have used our research since 2012.