IBM Rational System Architect vs erwin Data Modeler by Quest comparison

erwin by Quest and IBM are both solutions in the Enterprise Architecture Management category. erwin by Quest is ranked #3 with an average rating of 8.2, while IBM is ranked #20. erwin by Quest holds a 11.1% mindshare in AM, compared to IBM’s 1.8% mindshare. Additionally, 95% of erwin by Quest users are willing to recommend the solution, compared to 83% of IBM users who would recommend it.

erwin Data Modeler by Quest

Read 39 erwin Data Modeler by Quest reviews

4,548 Views
2,477 Comparison Views

95% willing to recommend

IBM Rational System Architect

Read 5 IBM Rational System Architect reviews

1,020 Views
569 Comparison Views

83% willing to recommend

erwin Data Modeler by Quest

IBM Rational System Architect

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Nov 3, 2024

IBM Rational System Architect and erwin Data Modeler by Quest are enterprise architecture and data modeling tools, respectively. erwin Data Modeler holds the advantage due to superior features and quick deployment, despite IBM's competitive pricing aspects.

Features: IBM Rational System Architect supports complex frameworks and integrates with multiple tools, providing a versatile modeling platform. erwin Data Modeler efficiently manages large data volumes and offers detailed visual representations. It excels in metadata management and collaboration, distinguishing it from IBM's capabilities.

Room for Improvement: IBM Rational System Architect could improve its deployment speed and user interface for better accessibility. erwin Data Modeler might enhance its pricing flexibility and expand support for diverse database systems. Both products can benefit from refining their integration capabilities with third-party tools

Ease of Deployment and Customer Service: IBM Rational System Architect requires a traditional deployment approach, often leading to longer setups. Despite this, it offers extensive documentation and dedicated customer service. erwin Data Modeler ensures a more intuitive deployment with responsive support, promoting user satisfaction efficiently.

Pricing and ROI: IBM Rational System Architect has a higher initial cost but brings long-term value through its comprehensive features. erwin Data Modeler's premium price is justified by its efficient capabilities and quick deployment, delivering significant ROI by reducing long-term operational expenses.

To learn more, read our detailed IBM Rational System Architect vs. erwin Data Modeler by Quest Report (Updated: January 2025).

Buyer's Guide

IBM Rational System Architect vs. erwin Data Modeler by Quest

January 2025

Download the complete report

Helped 831,265 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 by Quest

Ranking in Enterprise Architecture Management

3rd

Average Rating

8.6

Reviews Sentiment

7.2

Number of Reviews

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

Ranking in other categories

No ranking in other categories

Mindshare comparison

As of January 2025, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 11.1%, up from 10.0% compared to the previous year. The mindshare of IBM Rational System Architect is 1.8%, down from 2.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Enterprise Architecture Management

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

Entrprsarch67

Enterprise Architecture Specialist at a energy/utilities company with 10,001+ employees

Modeling is useful, but many features need improvement and technical support is lacking

I find that almost every feature related to the models requires improvement. For example, I would like to see more trendy models, the look and feel of the models can be improved. This solution can be more user-friendly and easier to use, with better dashboards. The impact analysis feature is in need of heavy improvement. The is a standalone product that lacks integration with a business process automation engine. I would like to see the workflow improved, where it integrates seamlessly with the artifacts.

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

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

"The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc."

"The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."

"One of the best aspects of the tool is its reverse engineering capability."

"The principal feature that I liked is that the solution has a very graphic interface."

"It reduces monthly savings by hundreds of thousands of dollars. Think about a company like Costco and all of the points of sale systems in Costco, all of the systems, the applications, but if all the applications in Costco all had their own data model, trying to integrate those, upgrade them and manage their different versions of the same model throughout the store, is an absolute nightmare. It's phenomenally expensive. This helps reduce that cost significantly. I'm talking on the orders of hundreds of thousands of dollars."

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

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

More erwin Data Modeler by Quest pros

"The solution is pretty stable."

"The user interface is good. It's both clear and comprehensible. It's easy to work with."

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

Cons

"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use."

"Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model."

"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."

"I would like the solution to be less rigid in terms of its theory."

"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 the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."

"I still use Visio for conceptual modeling, and that's mainly because it is easier to change things, and you can relax some of the rules. DM's eventual target is a database, which means you actually have to dot all the Is and cross all the Ts, but in a conceptual model, you don't often know what you're working with. So, that's probably a constraint with erwin. They have made it a lot easier, and they've done a lot, but there is probably still room for improvement in terms of the ease of presentation back to the business. I'm comparing it with something like Visio where you can change colors on a box, change the text color and that sort of stuff, and change the lines. Such things are a whole lot easier in Visio, but once you get a theme organized in erwin, you can apply that theme to all of the objects. So, it becomes easier, but you do have to set up that theme."

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

More erwin Data Modeler by Quest cons

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

"The solution needs to better integrate with other products, like Microsoft."

Pricing and Cost Advice

"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."

"An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it. This would not be to make any changes, but just to visually look at what exists. There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool."

"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."

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

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

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

"Though the solution is not cheap, it's worth the money."

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

More erwin Data Modeler by Quest pricing and cost advice

Information not available

See which vendors are best for you

Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.

See recommendations

831,265 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

19%

Manufacturing Company

Government

Computer Software Company

Manufacturing Company

17%

Financial Services Firm

14%

Computer Software Company

12%

Government

10%

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?

The solution's model mark could be better because it crashes sometimes.

See all answers

Ask a question

Earn 20 points

Comparisons

SAP PowerDesigner vs erwin Data Modeler by Quest

Compared 28% of the time

IDERA ER/Studio vs erwin Data Modeler by Quest

Compared 17% of the time

Lucidchart vs erwin Data Modeler by Quest

Compared 15% of the time

Visio vs erwin Data Modeler by Quest

Compared 10% of the time

Ardoq vs erwin Data Modeler by Quest

Compared 1% of the time

More erwin Data Modeler by Quest Competitors

Sparx Systems Enterprise Architect vs IBM Rational System Architect

Compared 68% of the time

MEGA HOPEX vs IBM Rational System Architect

Compared 11% of the time

ARIS BPA vs IBM Rational System Architect

Compared 9% of the time

More IBM Rational System Architect Competitors

Product Reports

Buyer's Guide

erwin Data Modeler by Quest

January 2025

Download erwin Data Modeler by Quest product report

Buyer's Guide

Enterprise Architecture Management

January 2025

Download IBM Rational System Architect product report

Also Known As

erwin DM

Rational System Architect

Learn More

erwin by Quest

IBM

Overview

erwin pioneered data modeling, and erwin Data Modeler (erwin DM) remains trusted, award-winning software for data modeling and database design, automating complex and time-consuming tasks. Use it to discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts.

IBM Rational System Architect is an enterprise architecture solution for visualizing, analyzing, and communicating enterprise architecture and business process analysis. This solution provides decision support, process optimization, and integration into solution delivery. Rational System Architect addresses all aspects of your organization's enterprise architecture, including modeling, publishing, analysis, and execution.

Sample Customers

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

Wuxi Lake Cloud, Nationwide, ETI, IDS Scheer

Buyer's Guide

IBM Rational System Architect vs. erwin Data Modeler by Quest

January 2025

Free Report: IBM Rational System Architect vs. erwin Data Modeler by Quest

Find out what your peers are saying about IBM Rational System Architect vs. erwin Data Modeler by Quest and other solutions. Updated: January 2025.

DOWNLOAD NOW

831,265 professionals have used our research since 2012.

See our IBM Rational System Architect vs. erwin Data Modeler by Quest report.

See our list of best Enterprise Architecture Management vendors.

We monitor all Enterprise Architecture Management 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.