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

"It has flexibility in extending the data model."
"I know that there are two good features, APN and ServiceNow but we haven't explored all of its features yet."
"The solution is straightforward."
"Informatica provides a comprehensive solution for on-the-fly or real-time data masking."
"The solution has the best feature for parameterization."
"Offers data lineage feature"
"It has improved our organization because it has made our data more reliable. Data is the most important asset these days, and in order to trust your data, you need these tools to make sure that your data is clean and reliable."
"The Provisioning tool is something that is really handy for everyone. It is my pick as the best feature."
"The initial setup was very easy."
"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."
"Very good repository features."
"I mostly work on the conceptual and logical side of things, and I enjoy how easy it is to use."
"It's a stable system. It never crashes."
"Provides the flexibility to create logical and conceptual data models."
"This solution has good tools for big data, where you can manage large and complex databases."
"In terms of operational efficiency and cause savings or return on investment, I can say that with SAP PowerDesigner, our company saves a lot of time."
 

Cons

"Its features for partitioning and optimization could be better."
"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."
"User/group administration could use improvement."
"Informatica's issue is the licensing. Right now, there are a lot of new gen MDMs that are offering a lot in a single licensing model."
"One thing Informatica could improve is the way IPUs are used. Each customer purchases a certain amount of IPUs per month, but you can use more or less than that defined quantity. The only problem is if you don't use the all your IPUs, they don't carry over into the next month. I think customers should have the ability to transfer unused IPUs into the next month or year. This improvement could help give customers more flexibility, especially since cloud solutions need flexibility in how we use and pay for them."
"They could improve technical support because it is not good enough at the moment."
"Inserting the GenAI into the master data management will reduce the overall effort of operational activities."
"I need to have some insight into the tool's cloud capabilities."
"UI could be improved by enabling simpler navigation."
"Regarding improvements, I suggest enhancing the connection between objects in process and data models. It's crucial to define the structure of objects, especially when dealing with standard frameworks like VMM. There should be better visualization of arrows between BPM and data modeling objects, specifying their structure and impact. For future versions, a feature similar to Bizagi, allowing users to see forms or SQL representations of objects, would be valuable for demonstrating and presenting project details to stakeholders."
"In the future, I would like to see data manipulation capability where you can actually write SQL queries and manipulate data from directly within the tool."
"You have the possibility to complete a connection for abbreviations if you are creating columns or names of the tables. In the Citrix environment, this has been lagging to the point where the PowerDesigner was not usable."
"In terms of improvement, the pricing is a bit high."
"I've tried to use Power Designer to bring in images, which didn't work very well at all."
"The user interface could be more user-friendly."
"This product lacks artificial intelligence that should be very good in terms of automatically identifying the classification of elements."
 

Pricing and Cost Advice

"We are quite happy with the licensing model."
"Licensing is difficult to understand, but the team is always available to explain anything. They are very helpful."
"The price of Informatica Cloud Data Integration could be reduced."
"I rate the product's pricing a nine on a scale of one to ten, where one is low price, and ten is high price."
"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's pricetag should come down. They have to cut some costs."
"I rate the licensing cost of Informatica MDM a five out of ten."
"it's expensive, but if you're looking for a stable solution, Informatica MDM is a good one to choose."
"PowerDesigner is not the cheapest solution on the market, so make sure that you are using it to its full potential."
"The price of the solution is low."
"I bought the software outright and do not pay a licensing fee."
"The pricing varies based on functionality and users."
"The ROI has been 43%."
"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."
"I would like SAP to prove free licenses to professionals that are using the solution. The free version is limited."
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
25%
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.