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

Informatica Intelligent Data Management Cloud (IDMC) vs Microsoft Data Quality Services 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...
Ranking in Data Quality
1st
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Integration (3rd), 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 Data Quality Serv...
Ranking in Data Quality
13th
Average Rating
7.6
Reviews Sentiment
4.4
Number of Reviews
2
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of July 2025, in the Data Quality category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 17.9%, down from 24.8% compared to the previous year. The mindshare of Microsoft Data Quality Services is 1.4%, up from 0.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Quality
 

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
Automation in data management improves with built-in error rejection but technical support needs enhancement
Multiple areas in Microsoft Data Quality Services could be improved, such as its ability to perform changes automatically, as it currently identifies but does not correct data issues. Regular expression processing is complicated and slow. Technical support from Microsoft is poor, as they do not provide adequate assistance with issues encountered in integration or forming automation. Sometimes solutions to problems take several weeks due to a lack of support, relying instead on personal networks and experience.

Quotes from Members

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

Pros

"The profiling feature in Informatica Data Quality is incredibly effective for data governance."
"I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
"I like the number of options that are presented with Informatica, fuzzy matching, and your screen."
"The governance process was fully manual before, but Axon helped us configure those processes, giving us more visibility, transparency, and control over the data."
"Their new licensing is very flexible. With Informatica Cloud, you have plenty of items under the same umbrella, such as services, offerings, data quality, and data masking. You have also got master data management and API management. What I really like about them is that you don't need to go to Informatica and say that you need a data integration module. You would say that you need iPaaS or Informatica Cloud. They'll then try to understand your needs and give you IPUs, which are the processing units. If I purchased a hundred IPUs from Informatica as a customer, I can use 70 IPUs for data integration. I would also need data quality, so I can use 10 IPUs for data quality. I can use the remaining 20 IPUs for API management. Down the line, if I see that my initial data integration needs for the development phase are met, then out of the 70 IPUs assigned for data integration, I can use 30 IPUs for data masking. I can shuffle these numbers in any way within the Informatica Cloud umbrella for the tenure for which I have subscribed to these IPUs. I can use all services the way I want. This flexibility is what I really love about Informatica. It also has got good connectors."
"Axon has a marketplace that allows you to showcase all the assets the data owner has, so they can request access. That's one feature we use extensively. Axon also offers great visibility and intuitive searchability, allowing you to easily search data assets. You can check the lineage and see the work EDC does. EDC handles all the classification, cataloging, and lineage. It's integrated with Axon, and anyone can see that."
"Informatica Persistent Data Masking can mask production data for different users, ensuring that only authorized individuals can access sensitive information."
"It allows the creation of identical tasks that can be applied across multiple tables, ranging from 100 to even 1,000 tables."
"This solution is particularly useful for data enrichment."
"The primary advantage of Microsoft Data Quality Services is its capability to automate certain tasks, which are otherwise achieved through SQL queries."
 

Cons

"It could be a bit more intuitive, rather than technically complex."
"There are a small number of UI bugs that occur on occasion."
"It could be improved by including a buffer that saves data when there is a connectivity issue."
"I would like to see more API integration to have the capability to build a report using other third party reporting tools to streamline the operation."
"From multiple masters that are there in Informatica MDM, we can improve the financials."
"If I compare it with other MDM solutions in the market, one thing that can definitely be improved is automation to help with the configuration. Currently, when we are creating any staging of base object tables, all the columns have to be configured manually in the Informatica Hub Console. A lot of tables and different kinds of business columns have to be configured manually. There should be an automated process for this, especially in the Dev environment. When people are creating tables and columns from scratch, if there is a backend automated process for that, it would be really helpful. In Stibo, a similar feature is there wherein you can tag attributes to certain objects. It would be helpful if Informatica also provides a similar option. It would reduce the manual effort. It could be that such a feature is already there, but I am not aware of it."
"There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another."
"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."
"I would rate my experience with the initial setup a six out of ten, with one being very easy and ten being extremely challenging. So, there is room for improvement in the setup process."
"Technical support from Microsoft is poor, as they do not provide adequate assistance with issues encountered in integration or forming automation."
 

Pricing and Cost Advice

"Informatica MDM's price could be lower."
"The platform has a premium cost. I rate the pricing as seven out of ten."
"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 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."
"The solution is very expensive."
"Informatica MDM's pricetag should come down. They have to cut some costs."
"You pay for this solution based on IPUs, Informatica Processing Units. This depends on how much data you process and how much memory you consume from the cloud provider, and you pay as you go."
"The pricing is in the midrange. It's not cheap, but it depends on the licenses you require."
report
Use our free recommendation engine to learn which Data Quality solutions are best for your needs.
859,687 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
9%
Insurance Company
6%
No data available
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

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 Data Quality Services?
This solution is particularly useful for data enrichment.
What is your experience regarding pricing and costs for Microsoft Data Quality Services?
Microsoft Data Quality Services comes as part of SQL Server without additional costs, making it a competitive solution.
What needs improvement with Microsoft Data Quality Services?
Multiple areas in Microsoft Data Quality Services could be improved, such as its ability to perform changes automatically, as it currently identifies but does not correct data issues. Regular expre...
 

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
MS Data Quality Services
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Information Not Available
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Microsoft Data Quality Services and other solutions. Updated: May 2025.
859,687 professionals have used our research since 2012.