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

Informatica Intelligent Data Management Cloud (IDMC) vs Pentaho Data Catalog 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 Metadata Management
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) (7th), Business-to-Business Middleware (2nd), API Management (5th), Cloud Data Integration (2nd), Data Governance (3rd), Test Data Management (2nd), Cloud Master Data Management (MDM) (1st), Data Management Platforms (DMP) (2nd), Data Masking (2nd), Integration Platform as a Service (iPaaS) (4th), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd), AI Data Analysis (1st)
Pentaho Data Catalog
Ranking in Metadata Management
15th
Average Rating
9.0
Reviews Sentiment
7.1
Number of Reviews
1
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2026, in the Metadata Management category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 13.2%, down from 23.5% compared to the previous year. The mindshare of Pentaho Data Catalog is 1.7%, up from 0.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Metadata Management Mindshare Distribution
ProductMindshare (%)
Informatica Intelligent Data Management Cloud (IDMC)13.2%
Pentaho Data Catalog1.7%
Other85.1%
Metadata Management
 

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.
Lisa Williams - PeerSpot reviewer
Manager, Office of Enterprise Data Management at State of Arizona
Helps make metadata available from our transactional databases, data warehouse, document management system, and GIS
As I've said, we've tagged a lot of fields that are related to specific processes, like the driller's log or, for example, if you want to get a license to be a well driller. Now, what I'm having to do for the consultants is create an Excel spreadsheet that has the name of the tag and a description of it. I'm now creating a data silo. What would be helpful is a place, inside Lumada Data Catalog, where you can describe the tags that you're using. Otherwise, anybody coming into the system, or seeing the tag from the outside in one of the reports, is going to say, "What is that tag really referring to?" and has to know where my spreadsheet is.

Quotes from Members

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

Pros

"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"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."
"I definitely would recommend the Informatica solution to other people."
"It comes with lot of features and is a one-stop-shop solution for integration, data modeling, and data governance. Everything can be built under one particular umbrella. If any issues come up, then there won't be any blame game saying that it could be an integration issue or an MDM hub issue because it's wholly owned by Informatica. That's the biggest advantage of Informatica MDM over that of any other tools that are available on the market."
"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."
"The interface is really good."
"The most important features are the mastering of the data and the UI intuitiveness."
"The solution's most valuable features are its data quality, match-merge engine, and CLAIRE AI engine, which helps with AI automation."
"But overall, we spend a lot of time tagging data and working on data quality rules."
"The ability to easily and quickly ingest new data sources is the most valuable feature... I'm not an especially technical IT person, but my data governance lead and I are able to ingest the data, quickly profile it, and do data identification and tagging."
 

Cons

"Once the data is masked, we won't be able to reverse it back to its original value."
"The initial setup is complex. It isn't easy because it needs a separate server of its own."
"Informatica MDM can improve the data catalog and data marketplace."
"Their UI needs improvement. Their scorecards and reporting also need improvement. Their data quality reporting, especially their dashboards and scorecards, is lackluster at best. Its reporting capabilities are limited. If you want to do anything beyond its limited reporting capabilities, then you're going to have to use an external reporting tool such as Power BI or something like that."
"The cost of Informatica MDM is expensive and has room for improvement."
"Informatica Axon's response times and certain aspects of the admin panel could be enhanced for better usability."
"The licenses are too expensive compared to before, which is why customers are now preferring other data metadata management tools like OneTrust, Collibra, and Azure Purview."
"For products Master Data Management or related to MDM or Data Governance, there is no way by which we can directly practice, and my team struggles at that point."
"As I've said, we've tagged a lot of fields that are related to specific processes, like the driller's log or, for example, if you want to get a license to be a well driller."
"We've tagged a lot of fields that are related to specific processes... What would be helpful is a place, inside Lumada Data Catalog, where you can describe the tags that you're using. Otherwise, anybody coming into the system, or seeing the tag from the outside in one of the reports, is going to say, "What is that tag really referring to?" and has to know where my spreadsheet is."
 

Pricing and Cost Advice

"It's a very expensive solution"
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"The price is comparable."
"Informatica MDM's pricing is not cheap but comparable to other vendors."
"There is no doubt that it is very expensive, but the brand value comes at a cost. Other MDM solutions in the market that haven't proven themselves like Informatica are also pretty expensive. We need to understand that MDM itself is very expensive to implement. So, Informatica is also pretty expensive. I would rate it a two out of five for being pretty expensive."
"The pricing is quite flexible."
"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing nine and a half out of ten."
"The licenses attached to the solution are highly priced."
"We can afford it. We got a three-year contract... If it were to go up and price a lot, I don't know if I would be able to keep it."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
900,747 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 ...
Ask a question
Earn 20 points
 

Also Known As

ActiveVOS, Active Endpoints, Address Verification, Persistent Data Masking
Hitachi Lumada DataOps - Data Catalog
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Information Not Available
Find out what your peers are saying about Collibra, Informatica, Alation and others in Metadata Management. Updated: May 2026.
900,747 professionals have used our research since 2012.