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

IBM Rational System Architect vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024
 

Categories and Ranking

erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Average Rating
8.6
Number of Reviews
38
Ranking in other categories
Business Process Design (9th)
IBM Rational System Architect
Ranking in Enterprise Architecture Management
20th
Average Rating
7.4
Number of Reviews
5
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 10.9%, up from 10.1% compared to the previous year. The mindshare of IBM Rational System Architect is 1.9%, down from 2.9% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
Jun 19, 2024
Streamline data modeling and automate network changes for increased efficiency
We are implementing erwin to streamline data modeling and automate network changes for increased efficiency and comprehensive data development. This option simplifies the need for better data indexing Quest can create conceptual and physical data models to facilitate effective communication…
RK
Jul 31, 2019
Modeling is useful, but many features need improvement and technical support is lacking
I am using this solution for building enterprise architecture models. It is an on-premises deployment model The most valuable feature of this solution is modeling. I find that almost every feature related to the models requires improvement. For example, I would like to see more trendy models,…

Quotes from Members

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

Pros

"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"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."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."
"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"The data lineage feature is very valuable."
"The product lets us import different types of models from various databases."
"The solution is pretty stable."
"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."
"We have seen ROI with this solution over the years that we have used it."
"The user interface is good. It's both clear and comprehensible. It's easy to work with."
 

Cons

"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"There is a lack of local support in the China region."
"The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms."
"The erwin Data Modeler is quite complex to use."
"It is not a very stable solution. I rate the stability five out of ten."
"This is a very complex product."
"The solution's model mark could be better because it crashes sometimes."
"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."
"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."
"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 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."
 

Pricing and Cost Advice

"I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."
"The price should be lower in order to be on the same level as its competitors."
"Pricing is very high compared to any other product."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
"There are no costs in addition to the standard licensing fees."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"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."
Information not available
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
20%
Manufacturing Company
9%
Computer Software Company
9%
Government
9%
Manufacturing Company
14%
Computer Software Company
13%
Government
13%
Financial Services Firm
12%
 

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.
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.
What needs improvement with erwin Data Modeler by Quest?
The solution's model mark could be better because it crashes sometimes.
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 by Quest and other solutions. Updated: October 2024.
814,649 professionals have used our research since 2012.