SAP Data Hub vs erwin Data Modeler comparison

Quest Software and SAP are both solutions in the Data Governance category. Additionally, 95% of Quest Software users are willing to recommend the solution, compared to 66% of SAP users who would recommend it.

erwin Data Modeler

Read 39 erwin Data Modeler reviews

95% willing to recommend

SAP Data Hub

Read 3 SAP Data Hub reviews

1,169 Views
503 Comparison Views

66% willing to recommend

erwin Data Modeler

SAP Data Hub

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between erwin Data Modeler and SAP Data Hub based on real PeerSpot user reviews.

Find out what your peers are saying about Microsoft, Informatica, Collibra and others in Data Governance.

To learn more, read our detailed Data Governance Report (Updated: July 2025).

Buyer's Guide

Data Governance

July 2025

Download the complete report

Helped 865,384 peers since 2012

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

erwin Data Modeler

Average Rating

8.6

Reviews Sentiment

7.2

Number of Reviews

Ranking in other categories

Enterprise Architecture Management (4th), Business Process Design (10th)

SAP Data Hub

Average Rating

7.6

Reviews Sentiment

6.8

Number of Reviews

Ranking in other categories

Data Governance (29th), Metadata Management (12th)

Featured Reviews

JorgeSanz

Data Governance Senior Advisor at Abu Dhabi National Oil Company

Streamline data modeling and automate network changes for increased efficiency

The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.

Read full review

Vijaya Macherla

GTM Lead at Capgemini

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.

Read full review

Quotes from Members

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

Pros

"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."

"The solution is excellent in providing a visual representation of a database and can generate DDL for implementing changes. We use DDL for logical purposes to review with business people, ensuring they have the required fields for processing. We also use it as a data dictionary for the physical data model to understand all the purposes of the terms. This helps us map the logical and physical terms with the business definition to understand our data."

"The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."

"The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically."

"It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."

"It has centralized storage so that a data model can be shared by different teams."

"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."

"The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."

More erwin Data Modeler pros

"The most valuable feature is the S/4HANA 1909 On-Premise"

"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."

"SAP is one of the most seamless ERPs that have integrated SAP archiving within Excel. I have not seen this with any other database."

Cons

"The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement."

"The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work."

"I would like to see more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata."

"We can only get licenses through partners."

"As someone who has used it for a long time, I have seen stability vary from version to version."

"erwin is not as robust as a data warehousing project I've been on in the past."

"I find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it."

"I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."

More erwin Data Modeler cons

"The company has everything offshore."

"Nowadays there are some inconsistencies in data bases, however, they upgrade and release the versions to market."

"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."

Pricing and Cost Advice

"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."

"The price should be lower in order to be on the same level as its competitors."

"The price of erwin Data Modeler is very expensive, in particular for this part of the world."

"There are two license options and the pricing is reasonable."

"There are no costs in addition to the standard licensing fees."

"There is either a one-year or three-year license. It is not a pay-as-you-go license like a SaaS solution. It’s more of a traditional licensing. They are a little bit on the pricier side."

"Likewise, the solution is a little pricey."

"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."

More erwin Data Modeler pricing and cost advice

"The Cloud is very expensive, but SAP HANA previous service is okay."

See which vendors are best for you

Use our free recommendation engine to learn which Data Governance solutions are best for your needs.

See recommendations

865,384 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

18%

Manufacturing Company

Government

Computer Software Company

Manufacturing Company

15%

Financial Services Firm

12%

Computer Software Company

12%

Government

11%

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

What do you like most about erwin Data Modeler by Quest?

Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.

See all answers

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?

The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.

See all answers

What needs improvement with erwin Data Modeler by Quest?

As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...

See all answers

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.

See all answers

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 ...

See all answers

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...

See all answers

Comparisons

SAP PowerDesigner vs erwin Data Modeler

Compared 36% of the time

IDERA ER/Studio vs erwin Data Modeler

Compared 18% of the time

Lucidchart vs erwin Data Modeler

Compared 12% of the time

Visio vs erwin Data Modeler

Compared 6% of the time

Sparx Systems Enterprise Architect vs erwin Data Modeler

Compared 6% of the time

More erwin Data Modeler Competitors

Microsoft Purview Data Governance vs SAP Data Hub

Compared 32% of the time

Palantir Foundry vs SAP Data Hub

Compared 23% of the time

Informatica Intelligent Data Management Cloud (IDMC) vs SAP Data Hub

Compared 16% of the time

Collibra Governance vs SAP Data Hub

Compared 7% of the time

IBM InfoSphere DataStage vs SAP Data Hub

Compared 6% of the time

More SAP Data Hub Competitors

Product Reports

Buyer's Guide

erwin Data Modeler

August 2025

Download erwin Data Modeler product report

Buyer's Guide

Data Governance

July 2025

Download SAP Data Hub product report

Also Known As

erwin DM

No data available

Overview

Erwin Data Modeler provides an effective approach to visualizing and managing data models. It assists in creating, reversing, and synchronizing data models with ease, supporting logical and physical transitions while enhancing understanding across teams.

Erwin Data Modeler is a comprehensive tool designed for professional database management. It offers capabilities to organize and enforce standards, automating script generation with robust reverse engineering and DDL output. Users can manage complex data environments, capitalize on integration with data intelligence, and maintain large-scale databases smoothly. Despite its strengths, improvements in multi-language support, database integration, and reporting features are needed. Users benefit from extensive support for conceptual, logical, and physical database modeling, enhancing architectural design and data governance for platforms like SQL Server, Oracle, and Teradata.

What are the key features of Erwin Data Modeler?

Visual Representation: Facilitates clear visualization of data models, aiding comprehension.
Versioning and Editing: Enhance usability with versioning and bulk editing capabilities.
Reverse Engineering: Offers powerful tools for reverse engineering and DDL generation.
Integration: Aligns with data intelligence to streamline database management.
Naming Standards: Enforces consistency with automated script creation.

What benefits should users consider in Erwin Data Modeler reviews?

Collaboration: Promotes team understanding and collaboration through visual tools.
Automation: Reduces manual effort through automated processes and integration.
Scalability: Handles large database management efficiently, crucial for enterprise settings.
Data Governance: Facilitates effective data governance with structured modeling.

Erwin Data Modeler finds application in industries focused on robust data management, implementing it for enterprise data warehouses, business domain models, and operational systems. It supports architectural design and governance, aligning with business applications demanding precise data representation and visualization.

Quest Software

The SAP® Data Hub solution enables sophisticated data operations management. It gives you the capability and flexibility to connect enterprise data and Big Data and gain a deep understanding of data and information processes across sources and systems throughout the distributed landscape. The unified solution provides visibility and control into data opportunities, integrating cloud and on-premise information and driving data agility and business value. Distributed processing power enables greater speed and efficiency.

SAP

Sample Customers

Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples

Kaeser Kompressoren, HARTMANN

Find out what your peers are saying about Microsoft, Informatica, Collibra and others in Data Governance. Updated: July 2025.

DOWNLOAD NOW

865,384 professionals have used our research since 2012.

See our list of best Data Governance vendors.

We monitor all Data Governance reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.