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

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

 

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 (6th), 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) (2nd), 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 tool does give a good ROI."
"MDM is very stable - it can handle millions of hits daily and still run 24/7."
"It comes with lot of features and is a one-stop-shop solution for integration, data modeling, and data governance."
"The most valuable features of Informatica MDM are the IDQ and RDM data management."
"The data integration and synchronization features in IICS improve the data handling processes."
"The use case is embedding the data or the business glossary into the day-to-day workflow, for example, integrating it with Tableau so when people are looking at a Tableau report, they understand exactly what the data lineage is, where this data is coming from, and exactly what those business glossary terms mean so they can more accurately interpret and analyze the report."
"We have a lot of integrations, and it's very easy to create integrations. They have a lot of connectors."
"Informatica provides a comprehensive solution for on-the-fly or real-time data masking."
"The best feature Microsoft Fabric offers in my experience is the Dataflow."
"The most valuable and useful feature I have found in Microsoft Fabric is data consistency, which is the top thing."
"The features and capabilities of Microsoft Fabric that I have found most useful include it being a uniform platform."
 

Cons

"Some capabilities from the cloud version are not included in the on-premises version, such as the ability to create dashboards that show the whole of the metrics and the metrics of quality of the information you are analyzing."
"The on-prem version's functionalities may not be available on the cloud version."
"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."
"Complex to adapt data model provided using web service and e-commerce one."
"With limited data it's fine, but with a large volume the scalability is questionable, the threshold of data transaction is different."
"This is a costly solution."
"Informatica Enterprise Data Lake's setup process was complex since it doesn't support a lot of real-time systems."
"We currently have issues with real-time integration."
"In my experience, Microsoft Fabric is not stable."
"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."
 

Pricing and Cost Advice

"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"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's pricing model is easy, but it is very expensive."
"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."
"It's a very expensive solution"
"I rate the licensing cost of Informatica MDM a five out of ten."
"I have no idea what the price actually is. It is probably not going to be the cheapest, but it is a pretty stable and robust platform from the backend standpoint."
"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."
Information not available
report
Use our free recommendation engine to learn which Data Management Platforms (DMP) solutions are best for your needs.
904,973 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
13%
Manufacturing Company
11%
Construction Company
7%
Computer Software Company
6%
No data available
 

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: June 2026.
904,973 professionals have used our research since 2012.