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

Informatica Intelligent Data Management Cloud (IDMC) vs SAP PowerDesigner comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Mar 3, 2025

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
1st
Average Rating
7.8
Reviews Sentiment
6.8
Number of Reviews
182
Ranking in other categories
Data Integration (3rd), Data Quality (1st), Business Process Management (BPM) (13th), Business-to-Business Middleware (4th), API Management (8th), Cloud Data Integration (3rd), Data Governance (2nd), Test Data Management (3rd), Cloud Master Data Management (MDM) Solutions (1st), Data Management Platforms (DMP) (1st), Data Masking (2nd), Test Data Management Services (3rd), Product Information Management (PIM) (1st), Data Observability (2nd)
SAP PowerDesigner
Ranking in Metadata Management
4th
Average Rating
7.8
Reviews Sentiment
6.6
Number of Reviews
35
Ranking in other categories
Enterprise Architecture Management (5th)
 

Mindshare comparison

As of April 2025, in the Metadata Management category, the mindshare of Informatica Intelligent Data Management Cloud (IDMC) is 25.4%, down from 27.4% compared to the previous year. The mindshare of SAP PowerDesigner is 4.2%, up from 3.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Metadata Management
 

Featured Reviews

Raj Sethupathi - PeerSpot reviewer
Offers profiling and address standardization but can be complicated
Informatica Data Quality has its data warehouse, primarily using Oracle and some SQL databases. You need a database to host the data. The cleansed version of the data is stored in the data warehouse. It integrates with PowerCenter and other Informatica tools. The integration details can be complex, but a regional setup is involved in this process. Profiling smaller datasets, such as 10,000-50,000 records, worked fine. However, unexpected issues could arise with larger datasets, such as thousands of records or more, especially with tables containing many columns. Handling tables with fifty or more columns can be challenging, even in Excel. A mismatch in data types could cause the entire system to crash. Continual enhancements are being made to address these issues, which can be unique to specific industries like finance and healthcare.
JorgeSanz - PeerSpot reviewer
Effective in terms of validating everything, but sometimes they don't allow us some flexibility and GUI could improve
I would recommend SAP PowerDesigner to others for data architecture management. It provides all the functionalities in terms of data modeling, so it's also a good tool for that. I see trends in terms of data classification, but I don't see this tool with the intelligence to do that automatically. So, like, with artificial intelligence. Overall, I would rate the solution a six out of ten because there are too many validations. Also, I found some gaps in terms of relationships; they didn't appear when you do reverse engineering. Also, this tool lacks artificial intelligence that should be very good in terms of automatically identifying the classification of elements and maybe also to incorporate some artificial intelligence in providing descriptions for each data element included in the solution.

Quotes from Members

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

Pros

"The product's most valuable feature is the ability to select the data flow and lineage."
"The scalability of the solution is excellent."
"The metadata management of Informatica is great."
"The Mapping Designer allows for declarative ETL development (visual scripting) that leverages a wide array of different transformations."
"The features for data quality, data cataloging, and UI are excellent."
"The most valuable features of Informatica Cloud Data Integration for our clients are the AI capabilities within Informatica Intelligent Cloud Services."
"The most valuable feature of Informatica Axon is features, interfaces, and data mapping. It represents clusters nicely."
"There isn't any human touch involved. It's just an automated business process to build different applications and talking to various APIs using the client's ecosystems. We then build new functionalities out of it."
"The most valuable feature is the way you can extend it and customize it. With most modeling tools, you fit your modeling process to fit the tool. In PowerDesigner, you can make the tool fit the way you want to work."
"This solution has good tools for big data, where you can manage large and complex databases."
"The most useful feature has been the detailed possibility to model almost anything regarding physical databases."
"I've used the reverse engineering feature a lot. I can take a look at the structure of the database and what relationships it has."
"The feature I found valuable in SAP PowerDesigner is extraction. I also like that my company hasn't faced any issues because of the clear documentation about SAP PowerDesigner."
"SAP PowerDesigner is an excellent tool that does what I need it to do. What I like most about it is that it's stable, fast, and easy to understand."
"Has a specific template that's very helpful for importing metadata."
"SAP PowerDesigner is fairly stable."
 

Cons

"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."
"The customer servive and support could be faster. There is a slow turnaround."
"I think they should work really hard on UI."
"I would like to have the solution in one product and technical support needs to be better."
"Informatica MDM has limitations with connectivity."
"A general improvement in icons and the virtual interface would be good."
"Informatica Axon's response times and certain aspects of the admin panel could be enhanced for better usability."
"The biggest challenge I see is the IDE's for the cloud and automization are different."
"The solution itself does not need to be improved. However, they could add support for different languages."
"One disadvantage of SAP PowerDesigner is that you cannot reverse engineer the ALTER statements, so that's an enhancement or area for improvement I'm looking forward to seeing from the SAP team in the future. That should directly reflect on the physical data models my company builds."
"In terms of improvement, the pricing is a bit high."
"There are many areas of this solution that needs to be changed."
"There are some minor things that could be easier. We're writing up procedures to bring all the modeling back into one group as this reduces delays in production."
"SAP PowerDesigner can improve the ease of use. It is not the best tool on the market because it is tough to navigate and use. A beginner would not be able to use it well, it requires some experience. If the solution was more user-friendly it would be able to be used by more audiences. I do not think many people are aware of this solution and they should use it."
"Technical support needs improvement."
"This product lacks artificial intelligence that should be very good in terms of automatically identifying the classification of elements."
 

Pricing and Cost Advice

"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 licensing price of the product depends on the organization's requirements."
"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 pricing is high compared to other tools on the market."
"Informatica MDM is very expensive. Apart from licensing fees, they have broken down their products into multiple products, and they charge for each and every product. If the data is huge, they charge for the data. At times, we have to use third party services for data cleaning, and they charge for that as well."
"Informatica MDM recently changed its pricing model. It's usage-based but I don't have much insight into the current pricing."
"My understanding is that Informatica is quite expensive compare to other tools that are available in the market."
"We got a 50% discount."
"SAP PowerDesigner is cheaper than eriwin."
"The pricing varies based on functionality and users."
"PowerDesigner is not the cheapest solution on the market, so make sure that you are using it to its full potential."
"Regarding costs, SAP PowerDesigner is pricey, as I've heard from my team manager, which is why the company has been thinking of bringing another solution on board."
"When you purchase the license for SAP PowerDesigner, you have to buy one year of support. The tool is worth the money."
"The ROI has been 43%."
"The price of the solution is too expensive. When we asked for certain licenses in different countries it was unattainable."
"I bought the software outright and do not pay a licensing fee."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
845,040 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
Computer Software Company
12%
Manufacturing Company
10%
Insurance Company
6%
Financial Services Firm
26%
Government
12%
Manufacturing Company
8%
Computer Software Company
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

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 do you like most about SAP PowerDesigner?
It allows us to have proper documentation in terms of the databases.
What needs improvement with SAP PowerDesigner?
Based on my experience with SAP PowerDesigner, I'd like to see improvements in the DMM feature. Even if I have an ETL tool, I'd like the DMM options to directly connect to ETL tool repositories lik...
 

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
Sybase PowerDesigner
 

Overview

 

Sample Customers

The Travel Company, Carbonite
Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
Find out what your peers are saying about Informatica Intelligent Data Management Cloud (IDMC) vs. SAP PowerDesigner and other solutions. Updated: March 2025.
845,040 professionals have used our research since 2012.