No more typing reviews! Try our Samantha, our new voice AI agent.

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

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 15, 2026

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 Management Platforms (DMP)
2nd
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
215
Ranking in other categories
Data Integration (1st), Data Quality (1st), Business Process Management (BPM) (6th), Business-to-Business Middleware (1st), API Management (5th), Cloud Data Integration (3rd), Data Governance (3rd), Test Data Management (2nd), Cloud Master Data Management (MDM) (1st), Data Masking (2nd), Metadata Management (2nd), Integration Platform as a Service (iPaaS) (3rd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (1st)
Microsoft Fabric
Ranking in Data Management Platforms (DMP)
9th
Average Rating
7.6
Number of Reviews
3
Ranking in other categories
No ranking in other categories
 

Featured Reviews

RC
Contractor at Sanlam
Cloud data catalog has streamlined lineage and quality while leaving more automation to improve
I have not explored IDMC's automation capabilities driven by AI and metadata too much at the moment, but it is on the cards. We are basically creating the foundation, as the whole migration has taken place recently and it is still early days. I think Informatica Intelligent Data Management Cloud (IDMC) is evolving, and as the vendors move forward, they pick up new concepts from each other. I have seen that products leapfrog each other, and from my experience over the years, the big players tend to copy features or add enhancements based on industry trends. I feel whatever the tool does not have now, there is a feedback loop allowing us to request new features, and we continually ask for different ways to do things as we have a pipeline into the product management team. It is difficult to say what additional features I would prefer to see in the next release of IDMC. I would appreciate more automation on the lineage front, with more AI to seamlessly join independent sources and create seamless lineage between different technologies, such as from file into database A into a different database and landing up in a reporting system such as Cognos, Qlik, Qlik Sense, QlikView, or Power BI.
Ankush-Singh - PeerSpot reviewer
Lead Software Engineer at Momentus
Unified analytics platform has simplified complex dashboards and supported secure data pipelines
One thing about Microsoft Fabric that I think could be improved is the potential confusion when working with real-time data versus normal batch loading. If you are dealing with real-time databases or data, you need to work with Event Hub and event streaming, but for normal batch processing, you can usually go ahead with the SQL warehouse or the data lakehouse. I recommend that Microsoft unify these processes, so using one source can meet both requirements. If I am working with real-time data and batched data, I should not have to manage two separate systems; instead of creating an Event Hub and a lakehouse, users could simply manage one house to handle both real-time analysis and batch processing, making it simpler and more user-friendly from both business and development perspectives.

Quotes from Members

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

Pros

"The ability to clean out data and improve the data quality is the best feature."
"We found that it is the most robust platform to integrate with our e-commerce platform."
"Informatica Cloud Data Quality was most valuable for our real-time data quality monitoring needs."
"I think that it's a good solution...It is stable because we have the experience to deploy this solution."
"There isn't any human touch involved. It's just an automated business process to build different applications and talking to various APIs using the client's ecosystems. We then build new functionalities out of it."
"Server maintenance, server hosting, backup, restoration, and DB capabilities are not needed in the cloud."
"It's probably one of the leading lights in ETL."
"Having access to PIM production, we get all the details of the supplier from here and we also get to update the information on the master catalog for urgent tasks."
"The best feature Microsoft Fabric offers in my experience is the Dataflow."
"The features and capabilities of Microsoft Fabric that I have found most useful include it being a uniform platform."
"The most valuable and useful feature I have found in Microsoft Fabric is data consistency, which is the top thing."
 

Cons

"In terms of data volume processing, Intelligent Cloud Services does not match the efficiency of Power Center."
"Considering internal data from legacy systems, it is quite difficult to know if Informatica Data Quality meets that high level of accuracy criteria."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"The user interface of the product needs to be improved"
"The error information provided is not informative, as compared to Power Center."
"We currently have issues with real-time integration."
"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."
"The stability and the integration of the solution have room for improvement."
"I think the Copilot usage in Microsoft Fabric can be improved."
"One thing about Microsoft Fabric that I think could be improved is the potential confusion when working with real-time data versus normal batch loading."
"In my experience, Microsoft Fabric is not stable."
 

Pricing and Cost Advice

"We pay for a yearly subscription."
"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 licensing costs attached to the solution are pretty high, but then, with the cloud model, the prices depend on what it provides for the value of money, which I feel was very high."
"The product is highly-priced."
"I have heard from customers that the product comes with a huge license cost."
"It's offers value for money. They're more competitive with respect to pricing and offerings."
"The platform has a premium cost. I rate the pricing as seven out of ten."
"The product is very expensive"
Information not available
report
Use our free recommendation engine to learn which Data Management Platforms (DMP) solutions are best for your needs.
912,788 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
12%
Manufacturing Company
10%
Outsourcing Company
9%
Construction Company
9%
Healthcare Company
18%
Outsourcing Company
14%
Construction Company
12%
Financial Services Firm
10%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business51
Midsize Enterprise27
Large Enterprise155
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 needs improvement with Microsoft Fabric?
I think Microsoft Fabric can be improved, but I feel that everything is adequate. Everything is acceptable regarding the needed improvements.
What is your primary use case for Microsoft Fabric?
My main use case for Microsoft Fabric is data engineering. A specific example of something my team has used Microsoft Fabric for is to collect information from many sources and put it in the data w...
What advice do you have for others considering Microsoft Fabric?
My advice to others looking into using Microsoft Fabric is that it is a good solution. I heard from the cloud infrastructure team about this product. I do not have any additional thoughts about Mic...
 

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking
No data available
 

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 Fabric and other solutions. Updated: August 2026.
912,788 professionals have used our research since 2012.