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

ETL Solutions Transformation Manager vs Informatica Intelligent Data Management Cloud (IDMC) comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 19, 2024

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

ETL Solutions Transformatio...
Ranking in Data Integration
36th
Average Rating
9.0
Reviews Sentiment
6.8
Number of Reviews
3
Ranking in other categories
No ranking in other categories
Informatica Intelligent Dat...
Ranking in Data Integration
4th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (9th), 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)
 

Mindshare comparison

As of August 2025, in the Data Integration category, the mindshare of ETL Solutions Transformation Manager is 0.4%, up from 0.2% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 4.3%, down from 6.5% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Vijayraj Amin - PeerSpot reviewer
User-friendly and accessible for anyone with computer knowledge and logical thinking
There is room for improvement in the solution's visualization tool. Currently, it provides basic reports and the ability to create graphs and dashboards, but I'm looking forward to more robust analytics. The plan is to enhance this feature in 2024, around Q2 or Q3, which would save us from relying on external tools like Power BI for insights.
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.

Quotes from Members

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

Pros

"It is a reliable solution."
"Back in the day, we could only get reports and analyze what happened after the fact, but today now we can generate real-time insights. Transformation Manager feeds your data science projects. We generate models and then give them to the clients, so they can come up with real-time predictions and recommendations in addition to reporting."
"It is among the best, even if not widely known."
"The solution is stable."
"One of the most valuable features is that I don't need to buy a subscription for any functionality. With Informatica Cloud Data Management, I have all the functionality and features available. If I need to make an integration, I can go to that integration service. If I need to mask, provide, or clean some information, I can easily just pick up that feature and use it. It's very simple, and I have all the functions and capabilities I need to work with data."
"The tool's most valuable feature is bulk upload. We upload files in CSV or Excel format."
"Data integration is the most valuable feature. The ability to connect to any of the sources and enterprise applications makes our lives easier."
"The governance process was fully manual before, but Axon helped us configure those processes, giving us more visibility, transparency, and control over the data."
"It allows the creation of identical tasks that can be applied across multiple tables, ranging from 100 to even 1,000 tables."
"The support is very good."
"Its data cleansing capabilities are very valuable. The match and merge and the audit trail functionalities are very good."
 

Cons

"There is room for improvement in the solution's visualization tool."
"They should build a functional architecture based on queuing."
"Transformation Manager reporting could be better. There are better options for reporting tools these days. We use Microsoft BI sometimes, but Tableau is becoming too expensive. Microsoft BI's visualization features are maturing."
"They could provide more robust performance for data integration processes. It would help in improving the data quality more efficiently."
"Performance also needs to be significantly improved, especially when connecting to SFDC for read and write operations."
"The vendor should have more training resources: online classes, free tutorial videos, etc."
"It would be great if the cloud version could match the full range of capabilities available on-premise."
"New machine learning could be added to Informatica MDM because the solution is outdated and is not moving with the current trends. The solution is good, but it definitely needs a lot of improvement and needs to speed up as per the market."
"When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."
"There are some limitations with Informatica Axon when one tries to connect or integrate it with Jira."
"The product isn't mature enough to provide suitable connectors to various data engines."
 

Pricing and Cost Advice

"It is an expensive solution."
"A yearly subscription is paid based on the number of people using the solution. Price-wise, it falls under the medium range since it is neither very costly nor too cheap."
"Informatica Axon is a costly solution. I rate Informatica Axon a four out of ten for its pricing."
"Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
"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."
"It is expensive. That's probably the biggest drawback. The business has heartache paying the license, but that's mainly because they don't realize what value it brings. The key thing about the MDM solution is that it is in the backend, and no one sees what it is actually doing. You don't know it is a problem until it is not there."
"Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful."
"Informatica MDM's pricetag should come down. They have to cut some costs."
"You can purchase licenses for this solution at different intervals. For example, annually or every three years. They recently changed their terms for licensing and now it is more flexible."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
865,140 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
21%
Financial Services Firm
13%
Retailer
11%
Healthcare Company
9%
Financial Services Firm
16%
Computer Software Company
11%
Manufacturing Company
10%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for ETL Solutions Transformation Manager?
ETL Solutions Transformation Manager is much more affordable than other solutions like AWS, Blue, or Informatica. Even though some competitors may offer seemingly economical pricing, the resource c...
What needs improvement with ETL Solutions Transformation Manager?
There is room for improvement in the solution's visualization tool. Currently, it provides basic reports and the ability to create graphs and dashboards, but I'm looking forward to more robust anal...
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 ...
 

Also Known As

Transformation Manager
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
 

Overview

 

Sample Customers

Honda, BNP Paribas, RBS, JPMorgan, Volkswagen, Thorn Lighting, OpenSpirit, Rolls-Royce, Ulster Bank
The Travel Company, Carbonite
Find out what your peers are saying about ETL Solutions Transformation Manager vs. Informatica Intelligent Data Management Cloud (IDMC) and other solutions. Updated: August 2025.
865,140 professionals have used our research since 2012.