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

SAP Data Hub vs SAP PowerDesigner comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

SAP Data Hub
Ranking in Metadata Management
9th
Average Rating
7.6
Number of Reviews
3
Ranking in other categories
Data Governance (28th)
SAP PowerDesigner
Ranking in Metadata Management
3rd
Average Rating
7.8
Number of Reviews
35
Ranking in other categories
Enterprise Architecture Management (5th)
 

Mindshare comparison

As of November 2024, in the Metadata Management category, the mindshare of SAP Data Hub is 4.0%, down from 6.4% compared to the previous year. The mindshare of SAP PowerDesigner is 6.4%, up from 5.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Metadata Management
 

Featured Reviews

VM
Sep 22, 2023
The solution is seamless, but the database sometimes leads to confusion
We used to have multiple different kinds of databases, which internally, had different compliance levels. Retention management is very different now. If the policy is live and the claim has been completed, I couldn't archive the claim. I needed to keep a reference integrity of that claim and understand which policy paid out the claim. With this solution, the policy came in six months ago and qualified for archiving. The claim had been paid and in every environment, the claim had been closed, including the reporting system, the claims system, etc. With the payment set gateway, I can just go and archive. But, we had a hard time during this process. I rate the overall solution a seven out of ten.
JorgeSanz - PeerSpot reviewer
Apr 18, 2024
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

"Its connection to on-premise products is the most valuable. We mostly use the on-premise connection, which is seamless. This is what we prefer in this solution over other solutions. We are using it the most for the orchestration where the data is coming from different categories. Its other features are very much similar to what they are giving us in open source. Their push-down approach is the most advantageous, where they push most of the processing on to the same data source. This means that they have a serverless kind of thing, and they don't process the data inside a product such as Data Hub. They process the data from where the data is coming out. If it is coming from HANA, to capture the data or process it for analytics, orchestration, or management, they go to the HANA database and give it out. They don't process it on Data Hub. This push-down approach increases the processing speed a little bit because the data is processed where it is sitting. That's the best part and an advantage. I have used another product where they used to capture the data first and then they used to process it and give it. In Data Hub, it is in reverse. They process it first and give it, and then they put their own manipulations. They lead in terms of business functions. No other solution has business functions already implemented to perform business analysis. They have a lot of prebuilt business functions for machine learning and orchestration, which we can use directly to get an analysis out from the existing data. Most of the data is sitting as enterprise data there. That's a major advantage that they have."
"The most valuable feature is the S/4HANA 1909 On-Premise"
"SAP is one of the most seamless ERPs that have integrated SAP archiving within Excel. I have not seen this with any other database."
"The most valuable features of the solution are it's built very well, easy to use, and simple to describe freely what is needed in logical and physical data models."
"The physical database model is definitely the most valuable feature because it describes normalization exactly the way you understand the data, and it deploys it perfectly with open source systems."
"It is more flexible than other tools and user-friendly, making it easy to adapt."
"I like the connectivity or the lineage between the models and usability."
"It has helped me to develop the as-is state, design its to-be state, and track the capital investment according to gap analysis."
"This solution has good tools for big data, where you can manage large and complex databases."
"I do a data-centric design, so for me, the data analysis and design tools are the most valuable features."
"Very good repository features."
 

Cons

"In 2018, connecting it to outside sources, such as IoT products or IoT-enabled big data Hadoop, was a little complex. It was not smooth at the beginning. It was unstable. It took a lot of time for the initial data load. Sometimes, the connection broke, and we had to restart the process, which was a major issue, but they might have improved it now. It is very smooth with SAP HANA on-premise system, SAP Cloud Platform, and SAP Analytics Cloud. It could be because these are their own products, and they know how to integrate them. With Hadoop, they might have used open-source technologies, and that's why it was breaking at that time. They are providing less embedded integration because they want us to use their other products. For example, they don't want to go and remove SAP Analytics Cloud and put everything in Data Hub. They want us to use SAP Analytics Cloud somewhere else and not inside the Data Hub. On the integration part, it lacks real-time analytics, and it is slow. They should embed the SAP Analytics Cloud inside Data Hub or support some kind of analysis. They do provide some analysis, but it is not extensive. They are moreover open source. So, we need a lot of developers or data scientists to go in and implement Python algorithms. It would be better if they can provide their own existing algorithms and give some connections and drop-down menus to go and just configure those. It will make things really quick by increasing the embedded integrations. It will also improve the process efficiency and processing power. Its performance needs improvement. It is a little slow. It is not the best in the market, and there are other products that are much better than this. In terms of technology and performance, it is a little slow as compared to Microsoft and other data orchestration products. I haven't used other products, but I have read about those products, their settings, and the milliseconds that they do. In Azure Purview, they say that they can copy, manage, or transform the data within milliseconds. They say that they can transform 100 gigabytes of data within three to five seconds, which is something SAP cannot do. It generally takes a lot of time to process that much amount of data. However, I have never tested out Azure."
"The company has everything offshore."
"Nowadays there are some inconsistencies in data bases, however, they upgrade and release the versions to market."
"This product lacks artificial intelligence that should be very good in terms of automatically identifying the classification of elements."
"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."
"This product does not have a good BPMN Modeler."
"The data governance should be improved, like ER/Studio."
"The portal of SAP PowerDesigner could be better. The tool also needs more features and integration with other products, such as Collibra. It would be interesting for SAP PowerDesigner to have more integration."
"UI could be improved by enabling simpler navigation."
"There should be a better usage of current hardware including multicore CPUs, higher resolutions, and multiple displays."
"I've tried to use Power Designer to bring in images, which didn't work very well at all."
 

Pricing and Cost Advice

"The Cloud is very expensive, but SAP HANA previous service is okay."
"I bought the software outright and do not pay a licensing fee."
"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."
"The ROI has been 43%."
"SAP PowerDesigner is cheaper than eriwin."
"The pricing varies based on functionality and users."
"The price of the solution is too expensive. When we asked for certain licenses in different countries it was unattainable."
"When you purchase the license for SAP PowerDesigner, you have to buy one year of support. The tool is worth the money."
report
Use our free recommendation engine to learn which Metadata Management solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
14%
Manufacturing Company
14%
Government
9%
Financial Services Firm
25%
Government
14%
Manufacturing Company
10%
Computer Software Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What do you like most about SAP Data Hub?
SAP is one of the most seamless ERPs that have integrated SAP archiving within Excel. I have not seen this with any other database.
What needs improvement with SAP Data Hub?
We moved from Oracle. If you're aware of your monitoring system, the RPU market, and the managed system, you should move to HANA, which is an innovative database built by SAP itself. However, this ...
What is your primary use case for SAP Data Hub?
I technically handle the database, like cycle management projects. When transaction data comes in, we see it based on the retention periods. We have to move the data to some secure storage rather t...
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

No data available
Sybase PowerDesigner
 

Learn More

Video not available
 

Overview

 

Sample Customers

Kaeser Kompressoren, HARTMANN
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 SAP Data Hub vs. SAP PowerDesigner and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.