We performed a comparison between IBM Rational System Architect and IDERA ER/Studio based on real PeerSpot user reviews.
Find out in this report how the two Enterprise Architecture Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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 solution is pretty stable."
"The user interface is good. It's both clear and comprehensible. It's easy to work with."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"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."
"We use the solution to create data models which describe our company's data architecture"
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"The data modeling module is important to me because I am a database developer and designer... It's very fast, reliable, up-to-date, so easy to use, smooth."
"Using this product has improved the way we maintain our models because they have a place where we can keep all of them, and they can be viewed using the web interface."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"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."
"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."
"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."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"The screens are a bit outdated. They could use a new look and feel."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct."
"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."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
Earn 20 points
IBM Rational System Architect is ranked 21st in Enterprise Architecture Management while IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 34 reviews. IBM Rational System Architect is rated 7.4, while IDERA ER/Studio is rated 8.4. The top reviewer of IBM Rational System Architect writes "Modeling is useful, but many features need improvement and technical support is lacking". On the other hand, the top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". IBM Rational System Architect is most compared with Sparx Systems Enterprise Architect and erwin Data Modeler by Quest, whereas IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and erwin Evolve by Quest. 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.