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

Informatica Intelligent Data Management Cloud (IDMC) vs Informatica PowerCenter 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:
 

ROI

Sentiment score
7.1
Informatica IDMC enhances data quality, efficiency, and analytics, offering secure integration and reduced cloud migration costs for businesses.
Sentiment score
8.1
Informatica PowerCenter is valued for its flexibility, stability, and effectiveness in handling diverse and complex data for reports.
We see return on investment from this solution in terms of time; time reduction or cost benefits is what we are getting very good results from.
 

Customer Service

Sentiment score
6.9
Informatica's customer service is praised for quick, knowledgeable support, though response times can vary with customization and membership levels.
Sentiment score
6.9
Customer service and technical support receive mixed reviews, highlighting varying levels of responsiveness, resource availability, and user experiences.
The response time is pretty good because we have someone in-house, who is an expert from Informatica, in our team who can help us with any sort of queries usually.
If they are unsure how to resolve an issue, they keep customers informed, providing updates about progress and ensuring communication with the product team to deliver accurate responses.
I would rate it as nine out of ten for Informatica PowerCenter kind of products or the Informatica integration products.
I like the technical support provided by Informatica.
 

Scalability Issues

Sentiment score
7.3
Informatica IDMC delivers scalable, flexible data management across cloud and on-premise environments, accommodating diverse enterprise needs efficiently.
Sentiment score
6.8
Informatica PowerCenter excels in scalability and versatility for data management, though costs and setup complexity are concerns.
I find Informatica Intelligent Data Management Cloud (IDMC) to be a sustainable and scalable solution.
As a SaaS platform, IDMC is quite scalable and provides complete flexibility.
For scalability, I would rate Informatica PowerCenter between eight to nine.
 

Stability Issues

Sentiment score
7.7
Informatica Cloud is highly rated for stability, despite occasional issues; support effectively resolves any reported bugs.
Sentiment score
7.8
Informatica PowerCenter is highly rated for stability, with few issues, mostly resolved by hotfixes, ensuring reliable performance.
Stability is crucial because IDMC holds business-critical data, and it needs to be available all the time for business users.
Informatica PowerCenter is stable and can scale well.
 

Room For Improvement

Informatica IDMC requires improvements in integration, user interface, performance, support consistency, connectivity, automation, data tagging, and pricing.
Informatica PowerCenter users seek improved affordability, a modern interface, better integration, and scalability for enhanced efficiency and user-friendliness.
The tool needs to mature in terms of category-specific attributes or dynamic attributes.
The observability concept in Informatica Intelligent Data Management Cloud (IDMC) needs improvement as the capabilities are not up to the mark compared to the industry.
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.
With Informatica PowerCenter, I am looking for an AI interface that looks at the underlying data model of the databases and the metadata of the tables, allowing the developer to provide instructions on what data sources to connect to and how to apply or create Transformations.
Utilizing more stored procedures from Oracle databases in an easy way would significantly boost performance.
 

Setup Cost

Informatica IDMC, a costly solution for large enterprises, offers extensive features and flexibility, justifying its premium pricing.
Informatica PowerCenter, although costly, is valued by large enterprises for its comprehensive features and effective complex data handling.
IDMC is often described as the 'Ferrari of Master Data Solutions,' implying that while expensive, it is business-critical and, therefore, justified.
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.
I think the costs are reasonable for the kinds of features that Informatica Intelligent Data Management Cloud (IDMC) has.
The price of Informatica PowerCenter is high, especially for small and medium-sized businesses.
I find that the pricing and licensing for Informatica PowerCenter align with its quality.
 

Valuable Features

Informatica IDMC excels in data management with strong integration, AI-driven analytics, and a flexible user interface.
Informatica PowerCenter provides robust, scalable ETL solutions with user-friendly design, supporting extensive databases and seamless data integration.
Informatica Intelligent Data Management Cloud (IDMC) can connect to pretty much any application, including Oracle Analytics and Power BI, and it works quite seamlessly.
The platform's ability to pull in data from other platforms without the need for an additional integration tool enhances its appeal.
In on-premise, we call it EDC for metadata management, while in cloud-based technologies, it is known as the Metadata Command Center, which serves the same purpose as EDC concerning CDGC.
The system supports real-time integration, which is essential for many of my tasks.
The functions in Informatica PowerCenter that I have found most valuable are the way it manages the volume of data, the push down optimization, and the performance aspects of it, mostly related to parallelism techniques.
 

Categories and Ranking

Informatica Intelligent Dat...
Ranking in Data Integration
4th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
186
Ranking in other categories
Data Quality (1st), Business Process Management (BPM) (11th), Business-to-Business Middleware (6th), 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)
Informatica PowerCenter
Ranking in Data Integration
3rd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
82
Ranking in other categories
Data Visualization (9th)
 

Mindshare comparison

As of September 2025, in the Data Integration category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 3.6%, down from 6.3% compared to the previous year. The mindshare of Informatica PowerCenter is 6.3%, down from 11.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration Market Share Distribution
ProductMarket Share (%)
Informatica PowerCenter6.3%
Informatica Intelligent Data Management Cloud (IDMC)3.6%
Other90.1%
Data Integration
 

Q&A Highlights

NC
Feb 13, 2022
 

Featured Reviews

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.
Deepak Shiv - PeerSpot reviewer
Provides multiple transformations in one toolset and helpful when extracting data from multiple sources
Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors. In addition, there are KB articles published by Informatica that are really helpful. So, error handling and the KB articles provided by Informatica are very helpful. Even if you face any issues or errors, we can usually resolve them. If the error cannot be solved with Informatica PowerCenter, we can raise a case with Informatica, and their support team will help us address that issue. If it cannot be solved with that particular version, they will consider it and try to solve it with the next patch or hotfix. AI Initiatives: Our company also has organizational AI or machine learning initiatives. However, Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool. It doesn't have a significant role in the field. It is just a small ETL on-premises tool. So basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud and Informatica Cloud), where their AI comes into the picture. But for Informatica PowerCenter, AI does not come into the picture at all.
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
867,349 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Answers from the Community

NC
Feb 13, 2022
Feb 13, 2022
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 quantities of data with a high level of reliability. We also like the metadata repository and the data warehouse application console. We would like to see the licensing improved, though. We would lik...
2 out of 3 answers
RC
Oct 25, 2021
Cloud Data Integration
Nov 21, 2021
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 quantities of data with a high level of reliability. We also like the metadata repository and the data warehouse application console. We would like to see the licensing improved, though. We would like to see a feature-wise option as opposed to the current bundle option. PowerCenter is a very expensive solution. The numerous levels of transformation and multiple interfaces can make it a very confusing solution to learn. Cloud Data Integration offers great options for data cleansing, data mastering, data masking, master data management, and API management. The UI is very easy to use and the setup is straightforward. The new licensing is very flexible. Cloud Data Integration has inbuilt tools that allow for a lot of data transformation without changing any SQL queries from the code. This is one of our favorite features. We would point out, though, that there are some limitations with performance using Cloud Data Integration. We experienced some connectivity issues, making things run a bit slow. There are some issues with data residency laws in some countries. More regions should be added. Finally, it would behoove Cloud DataIntegration to consider adding more data sources. Conclusion: These are two great solutions under Informatica Brand which is synonymous with quality, reliability, and price. (Very high price.) Cloud Data is best suited for small to medium organizations and is somewhat limited in the regions it can be used. PowerCenter is most applicable for large enterprises that can more easily absorb the cost and best utilize everything PowerCenter has to offer with their current bundle licensing tier.
 

Top Industries

By visitors reading reviews
Financial Services Firm
16%
Computer Software Company
10%
Manufacturing Company
10%
Insurance Company
7%
Financial Services Firm
19%
Computer Software Company
11%
Manufacturing Company
7%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business42
Midsize Enterprise24
Large Enterprise134
By reviewers
Company SizeCount
Small Business15
Midsize Enterprise10
Large Enterprise71
 

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 ...
How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
How do you evaluate the pricing model of Informatica PowerCenter?
The pricing model of Informatica PowerCenter is suitable for big companies and enterprises. This is an amazing product, and it certainly does its job, however, if you are a medium or small business...
 

Also Known As

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
PowerCenter
 

Overview

 

Sample Customers

The Travel Company, Carbonite
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. Informatica PowerCenter and other solutions. Updated: September 2025.
867,349 professionals have used our research since 2012.