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
183
Ranking in other categories
Data Integration (3rd), Business Process Management (BPM) (13th), Business-to-Business Middleware (4th), API Management (8th), 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 May 2025, in the Data Quality category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 19.2%, down from 25.3% compared to the previous year. The mindshare of Microsoft Data Quality Services is 1.2%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Quality
 

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
Offers profiling and address standardization but can be complicated
Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.
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 interface is really good."
"The mass ingestion functionality and the elasticity of the solution are great."
"The features that I have found most valuable are, first of all, that it comes as part of this whole bundle of Informatica tools. So if you've been implementing Informatica MDM across a business, you'd often find it comes with it. It's been thrown in as a sweetener. The adoption of it is often the challenge because as part of your MDM project, governance is seen as something beyond the MDM and is often restrictive. So this tool actually, for the first time, when you talk to data governance teams, gives a holistic view of what a data governance team can do with this tool."
"It is quite easy to use and flexible."
"I like the connectivity and richness of features for the technical team, the maturity of the product, and that it had a cloud version. There is Informatica Cloud, and it is part of the Informatica Cloud platform."
"The way that the solution scans is very useful."
"The profiling feature in Informatica Data Quality is incredibly effective for data governance."
"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."
"The primary advantage of Microsoft Data Quality Services is its capability to automate certain tasks, which are otherwise achieved through SQL queries."
"This solution is particularly useful for data enrichment."
 

Cons

"There's no direct way to connect to Amazon APIs from Informatica Cloud."
"While my company operates on the cloud, we have seen that Informatica Cloud Data Integration has some performance issues causing it to lag."
"IEDC can improve the comparison of lineages."
"One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities."
"I would rate my experience with the initial setup a two out of ten, with one being difficult and ten being easy."
"I would like to see support for more data sources."
"I have received feedback from certain teams and there is a steep learning curve to use this solution."
"The regions in which the data resides are still limited. This could be an issue in terms of the data residency laws of some of the countries. They should get more regions."
"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 pricetag should come down. They have to cut some costs."
"It's a very expensive solution"
"I'm not sure about the most recent pricing trends, but I don't believe it's significantly different from PowerCenter. I believe it is nearly the same."
"The price is neither too high nor too low."
"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."
"It is cost effective and an easily accessible tool."
"The product is highly-priced."
"It is an expensive solution. I would say it is the most expensive solution in the market."
"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.
851,451 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.
851,451 professionals have used our research since 2012.