IBM Rational System Architect vs IDERA ER/Studio comparison

IBM and IDERA are both solutions in the Enterprise Architecture Management category. IBM is ranked #20, while IDERA is ranked #10 with an average rating of 8.0. IBM holds a 1.9% mindshare in AM, compared to IDERA’s 4.1% mindshare. Additionally, 83% of IBM users are willing to recommend the solution, compared to 87% of IDERA users who would recommend it.

IBM Rational System Architect

Read 5 IBM Rational System Architect reviews

1,084 Views
602 Comparison Views

83% willing to recommend

IDERA ER/Studio

Read 35 IDERA ER/Studio reviews

1,517 Views
1,073 Comparison Views

87% willing to recommend

IBM Rational System Architect

IDERA ER/Studio

Comparison Buyer's Guide

Download the report

Executive SummaryUpdated on Nov 3, 2024

IBM Rational System Architect and IDERA ER/Studio are competing products in the enterprise architecture and data modeling category. IDERA ER/Studio appears to have an upper hand due to its usability, model management features, and overall user satisfaction.

Features: IBM Rational System Architect offers comprehensive support for enterprise architecture frameworks and integrations with IBM solutions. It facilitates complex architecture modeling and supports application portfolio scoring models. IDERA ER/Studio provides strong data modeling and database design features, offering better model visualization, collaboration tools, and reverse engineering capabilities.

Room for Improvement: IBM Rational System Architect could improve its deployment process to be more intuitive, optimizing setup time and reducing required expertise. Enhancing user-friendly features and streamlining integration processes might also be beneficial. IDERA ER/Studio may focus on refining some advanced modeling features, expanding meta-model customization, and enriching reporting tools to enhance overall experience and flexibility for users.

Ease of Deployment and Customer Service: IBM Rational System Architect's deployment is complex, requiring significant setup time and expertise, but benefits from strong support within IBM's ecosystem. IDERA ER/Studio ensures faster and simpler deployment with intuitive setup processes, coupled with reliable customer service, making it attractive for those seeking quick implementation and support.

Pricing and ROI: IBM Rational System Architect generally has a higher setup cost, potentially offering better ROI for existing IBM users due to its integration with IBM products. IDERA ER/Studio presents competitive pricing and strong ROI, thanks to effective data modeling capabilities and lower initial investment, appealing to enterprises focused on data-centric projects.

To learn more, read our detailed IBM Rational System Architect vs. IDERA ER/Studio Report (Updated: December 2024).

Buyer's Guide

IBM Rational System Architect vs. IDERA ER/Studio

December 2024

Download the complete report

Helped 824,053 peers since 2012

Categories and Ranking

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

IDERA ER/Studio

Ranking in Enterprise Architecture Management

10th

Average Rating

8.4

Reviews Sentiment

7.1

Number of Reviews

Ranking in other categories

Database Development and Management (15th)

Mindshare comparison

As of December 2024, in the Enterprise Architecture Management category, the mindshare of IBM Rational System Architect is 1.9%, down from 2.7% compared to the previous year. The mindshare of IDERA ER/Studio is 4.1%, down from 4.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Enterprise Architecture Management

Featured Reviews

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

Aaron Cutshall

Enterprise Data Architect & Senior Manager at Health First Inc.

Used for data modeling and has a scripting language to write your own scripts

The solution has streamlined our data modeling processes quite a bit. It's a central focus in our data modeling and data cataloging efforts. The tool's reverse engineering capability to bring in existing database structures and create models from them has benefitted our data architecture needs. With the tool's data dictionary capability, we're able to maintain consistency in our models, name use, and actual data domains. The solution's reverse engineering helps with understanding legacy databases. In fact, I've been asked to reverse-engineer several more legacy databases so that we can have them modeled and cataloged. The solution is deployed on the cloud server, but it’s only within our network. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts. I think that's been a big bonus for us. I highly recommend the solution because of its capability for logical models, where you can put your business definitions and logic. While less expensive, some other tools can't do that. Overall, I rate the solution an eight 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 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."

"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."

"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."

"Valuable features include the ability to visually represent what the database tables are going to look like and their relationships. Also, the ability to document the definitions of the tables and the columns that are in a table so that we can communicate what the data is and how it should be used."

"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."

"The reverse engineering is the most important feature."

"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."

"We are able to document the data lineage and data flows of our data from one system to another."

"The tool is simple to use."

More IDERA ER/Studio pros

Cons

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

"This solution can be more user-friendly and easier to use, with better dashboards."

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

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

"I would like to upload, a database with about 3,000 tables. It takes so much time and, finally, it freezes the whole solution so that I actually cannot work with that environment. For the data warehouse, it's fine because I have 20 or 30 tables. It works fine. But, when I reverse-engineer the database with 3,000 tables, it freezes and it's hard to upload and reverse-engineer such environments in ER/Studio."

"We would always like to see Repository performance improve, checking in and checking out."

"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."

"When building the relationships there should be a little more flexibility."

"The solution is not so strong at creating modeling views and database views."

"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."

"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."

"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."

More IDERA ER/Studio cons

Pricing and Cost Advice

Information not available

"As an individual user, the renewal is a little costly."

"I use the product's trial version."

"On a scale of one to ten, where one is bad and ten is good, I would rate the licensing cost as a seven or eight. It's not too expensive for us."

"At my previous company using ER/Studio, a database compare took four hours before using the product and 15 minutes after using the product."

"Pricing is expensive and on the higher-end."

"I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."

"I feel the product's pricing is a good value."

"I am currently using the trial version, but this solution is definitely worth considering for the price point."

More IDERA ER/Studio pricing and cost advice

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

824,053 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Manufacturing Company

15%

Government

13%

Computer Software Company

13%

Financial Services Firm

13%

Financial Services Firm

19%

Computer Software Company

10%

Manufacturing Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

No data available

Questions from the Community

Ask a question

Earn 20 points

What do you like most about IDERA ER/Studio?

The tool is simple to use.

See all answers

What is your experience regarding pricing and costs for IDERA ER/Studio?

The solution’s pricing is high.

See all answers

What needs improvement with IDERA ER/Studio?

Since the solution was originally developed in the eighties and nineties and hasn't changed much since then, it could use an overhaul. The solution is not so strong at creating modeling views and d...

See all answers

Comparisons

Sparx Systems Enterprise Architect vs IBM Rational System Architect

Compared 67% of the time

MEGA HOPEX vs IBM Rational System Architect

Compared 12% of the time

erwin Data Modeler by Quest vs IBM Rational System Architect

Compared 12% of the time

ARIS BPA vs IBM Rational System Architect

Compared 10% of the time

More IBM Rational System Architect Competitors

erwin Data Modeler by Quest vs IDERA ER/Studio

Compared 57% of the time

SAP PowerDesigner vs IDERA ER/Studio

Compared 14% of the time

Sparx Systems Enterprise Architect vs IDERA ER/Studio

Compared 9% of the time

Toad Data Modeler vs IDERA ER/Studio

Compared 5% of the time

erwin Evolve by Quest vs IDERA ER/Studio

Compared 5% of the time

More IDERA ER/Studio Competitors

Product Reports

Buyer's Guide

Enterprise Architecture Management

December 2024

Download IBM Rational System Architect product report

Buyer's Guide

IDERA ER/Studio

December 2024

Download IDERA ER/Studio product report

Also Known As

Rational System Architect

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition

Learn More

IBM

IDERA

Overview

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.

IDERA ER/Studio is a powerful suite for business-driven data modeling that enables companies to create an enterprise architecture foundation for data governance. With round-trip support for multiple database platforms, data architects have the power to reverse-engineer, analyze, and optimize existing databases easily from diverse platforms. Data professionals can easily capture and share models, metadata, data sources, and glossaries across the organization for improved alignment between the organization and Information Technology. Organizational stakeholders can take part in the metadata definition workflow and access information on models and metadata at the right level for their needs.

Unlike its competition, it provides the broadest range of data platform support, industry-leading enterprise-level capabilities, visual data lineage and flow modeling, full dimensional modeling for data warehousing and business intelligence, and business data objects to bridge the gap between developers and data architects. It also provides a complete solution for enterprise architecture and data governance, extensive model change management, unique incorporation of true enterprise data dictionaries, unique linking of constructs across models, integrated visual data lineage import, and integrated data and business process modeling.

Sample Customers

Wuxi Lake Cloud, Nationwide, ETI, IDS Scheer

Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo

Buyer's Guide

IBM Rational System Architect vs. IDERA ER/Studio

December 2024

Free Report: IBM Rational System Architect vs. IDERA ER/Studio

Find out what your peers are saying about IBM Rational System Architect vs. IDERA ER/Studio and other solutions. Updated: December 2024.

DOWNLOAD NOW

824,053 professionals have used our research since 2012.

See our IBM Rational System Architect vs. IDERA ER/Studio 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.