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
37th
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
3rd
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
185
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (10th), 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 (1st), Metadata Management (1st), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
 

Mindshare comparison

As of October 2025, in the Data Integration category, the mindshare of ETL Solutions Transformation Manager is 0.5%, up from 0.2% compared to the previous year. The mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.6%, down from 5.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Market Share Distribution
ProductMarket Share (%)
Informatica Intelligent Data Management Cloud (IDMC)3.6%
ETL Solutions Transformation Manager0.5%
Other95.9%
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.
SaurabhGaonshindhe - PeerSpot reviewer
Modular structure and AI features stream new reporting processes
One of my clients has a requirement; they want to integrate metadata into the process, which means, for example, if I just want to implement a new field into my database, that field needs to be reflected throughout, let's say, 200 mappings. This highlights the need for a data-driven approach. My experience with technical support from Informatica is quite interesting; I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products, because my team can do some hands-on using their free licenses or one-month kind of products. However, 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.

Quotes from Members

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

Pros

"It is among the best, even if not widely known."
"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."
"The most valuable feature of Informatica MDM is hierarchy management. It's not something that's typically available and effective within ERPs."
"The advanced features like task flow and conditional integration are particularly useful."
"The scalability is very high."
"On a scale of 1-10, I rate Informatica Intelligent Data Management Cloud (IDMC) a 10 out of 10."
"The solution is easier to use compared to the other solutions."
"I give the stability a ten out of ten."
"The solution is straightforward."
"The features for data quality, data cataloging, and UI are excellent."
 

Cons

"They should build a functional architecture based on queuing."
"There is room for improvement in the solution's visualization tool."
"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."
"The customer servive and support could be faster. There is a slow turnaround."
"It would be great if the cloud version could match the full range of capabilities available on-premise."
"I would like to see support for more data sources."
"The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."
"The integration process is not easy."
"When it comes to UI look and feel and user experience, Informatica is not as good as other solutions."
"Informatica is very expensive."
"We promote our code changes from a lower to a higher environment, which is highly complex when working with a multi-domain MDM like Informatica. This is the biggest obstacle for Informatica MDM, and I think they should change it because that's very time consuming."
 

Pricing and Cost Advice

"It is an expensive solution."
"The product is highly-priced."
"The price is high, but the competitors are even higher, like Collibra."
"Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
"It's pretty high for us. It's more on the higher side, like low to middle high."
"The solution is very expensive."
"It's offers value for money. They're more competitive with respect to pricing and offerings."
"The price is comparable."
"We have licenses, and we are provided with certain particular services in the solution."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
869,760 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
22%
Financial Services Firm
13%
Healthcare Company
11%
Retailer
11%
Financial Services Firm
15%
Manufacturing Company
10%
Computer Software Company
10%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business42
Midsize Enterprise24
Large Enterprise134
 

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: September 2025.
869,760 professionals have used our research since 2012.