No more typing reviews! Try our Samantha, our new voice AI agent.

IBM Rational System Architect vs erwin Data Modeler comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive SummaryUpdated on Jun 3, 2026

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
Ranking in Enterprise Architecture Management
1st
Average Rating
8.4
Reviews Sentiment
6.0
Number of Reviews
54
Ranking in other categories
Business Process Design (7th), Data Governance (10th)
IBM Rational System Architect
Ranking in Enterprise Architecture Management
15th
Average Rating
7.4
Number of Reviews
5
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of September 2026, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler is 8.4%, down from 8.9% compared to the previous year. The mindshare of IBM Rational System Architect is 3.0%, up from 2.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management Mindshare Distribution
ProductMindshare (%)
erwin Data Modeler8.4%
IBM Rational System Architect3.0%
Other88.6%
Enterprise Architecture Management
 

Featured Reviews

Sushree Panigrahi - PeerSpot reviewer
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Data modeling has transformed regulatory reporting and collaboration across cloud environments
In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.
GM
IT/Business Architect at a financial services firm with 51-200 employees
Lots of valuable features, especially the metamodel customization
In terms of what could be improved, we did not take the whole package with all the modules, and I think that the integration with other platforms like Office could be better. The reverse engineering of the database is already there, but in the next release I would like to see some pilot supplied with the solution in order to address any database.

Quotes from Members

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

Pros

"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."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"The biggest lesson I have learned from erwin is the old cliche, that a picture is worth a thousand words, and when a person asks for a set of tables and they actually see that diagram visually, it really assists in any meeting that you will have."
"The product itself is fantastic and it's about the only way to get an enterprise view of the data that you're designing."
"It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
"It is an invaluable tool for us; it has been part of our data governance process in regards to database design for at least 15 years."
"Erwin is by far the best tool I've ever used."
"The solution is pretty stable."
"The user interface is good. It's both clear and comprehensible. It's easy to work with."
"The System Architect Product has greatly assisted the corporate strategic planning process in two areas: the simulation of scenarios for Enterprise Transformation Projects and providing a global view of Enterprise Capabilities and Functional Gaps."
"We have seen ROI with this solution over the years that we have used it."
"There are a lot of features I find valuable, but I think that the metamodel customization is one of the best features that the solution offers."
"The main advantage of the solution and its most valuable aspect is the customization of the meta-model."
 

Cons

"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."
"Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk."
"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."
"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."
"As erwin Data Modeler files get larger, the response time really slows down, and when I have multiple files open I sometimes get a glitch where a lot of the text fields get solid black and the first eight characters of column names might be blacked out with a rectangle."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"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 are not happy with this product and are not planning to continue with it."
"Some aspects of the user interface lack a common navigational or functional framework."
"The reverse engineering of the database is already there, but in the next release I would like to see some pilot supplied with the solution in order to address any database."
"Integration with all other software, like Microsoft, to facilitate an exchange, is not great."
"There needs to be more information at the outset about how to use the solution and how to deploy it. The deployment process needs improvement."
"The solution needs to better integrate with other products, like Microsoft."
"This solution can be more user-friendly and easier to use, with better dashboards."
"It was sold separately and it is not very easy for somebody who wants to use the solution for modeling to think that you have to select specific modules in order to use the product."
 

Pricing and Cost Advice

"I don't specifically know what we're paying now. About three years ago, in another organization, I have this memory of 6,000 AUD a seat or something like that, but I am not sure. In the mid-2000s, it was something like 1,200 AUD a seat. I get the impression that there was a price jump when it was spun off from CA as a separate company, which is understandable, but it could sometimes be a barrier in some organizations picking it up. I haven't talked to erwin people yet, but I'm going to suggest to them that they could perhaps think of having an entry-level product that is priced a bit lower, and then, you can buy the extra suite."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"Pricing is very high compared to any other product."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"Likewise, the solution is a little pricey."
"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."
"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."
"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
Information not available
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
913,806 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
14%
Outsourcing Company
9%
Marketing Services Firm
7%
Manufacturing Company
6%
Comms Service Provider
13%
Financial Services Firm
13%
Manufacturing Company
10%
Healthcare Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business17
Midsize Enterprise4
Large Enterprise44
No data available
 

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The experience with pricing, setup cost, and licensing is that the licensing process is painful and quite onerous. The setup is okay, but there is room for improvement.
What needs improvement with erwin Data Modeler by Quest?
Regarding improvements, the first thing I would mention is that every release has some issues, some of which are related to current functionalities, which means they often seem not very well tested...
What is your primary use case for erwin Data Modeler by Quest?
My main use case for erwin Data Modeler is to implement a single data architecture design department so everyone is using erwin Data Modeler for their data models to be a transactional application ...
Ask a question
Earn 20 points
 

Also Known As

erwin DM
Rational System Architect
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Wuxi Lake Cloud, Nationwide, ETI, IDS Scheer
Find out what your peers are saying about IBM Rational System Architect vs. erwin Data Modeler and other solutions. Updated: September 2026.
913,806 professionals have used our research since 2012.