We performed a comparison between IDERA ER/Studio and Sparx Systems Enterprise Architect 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."The tool is simple to use."
"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."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"The reverse engineering is the most important feature."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"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."
"The solution saved a lot of time, about 30%."
"The best thing about the tool is that its database is open."
"Modeling is a part of my work, and it has a lot of standard modeling languages. It is quite wide, and a lot is possible in it. We are not programming it ourselves, but if you are into programming and developing software yourself, you can go further and do a lot with Sparx. You can work from the framework and go into the details. With this solution, you get a lot of value at a low cost. It is also quite intuitive in terms of use. I like the use of it."
"Scalability is not a problem. You can always increase the footprint of what the thing can do because it's so powerful."
"It is a very flexible product. It can do a lot. It is also a reliable product."
"The initial setup is easy."
"It is a handy tool for visual modeling that provides opportunities for analysis, design, and support of models using ArchiMate, UML."
"We have found the stability to be very reliable."
"They allow functionalities to be released before the full tests for catching and correcting errors are completed."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"When building the relationships there should be a little more flexibility."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"This solution needs more precise documentation."
"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 presentation graphics need to be improved in future builds."
"The UI could be improved and made a little bit more presentable."
"The solution needs to offer better support for the mobile-based system. Right now, it's not working."
"When the model is large, it is a bit slow to render."
"When many users are accessing the system at the same time, Sparx slows down. It can't easily support a large team."
"In general, we now have a problem with Sparx Enterprise Architect because many analysts think it's too complicated to use in a giant environment."
"The solution's interface could be more straightforward."
"Using EA involves a steep learning curve if you want to understand its capabilities and functionality."
More Sparx Systems Enterprise Architect Pricing and Cost Advice →
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 33 reviews while Sparx Systems Enterprise Architect is ranked 2nd in Enterprise Architecture Management with 97 reviews. IDERA ER/Studio is rated 8.4, while Sparx Systems Enterprise Architect is rated 8.0. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". On the other hand, the top reviewer of Sparx Systems Enterprise Architect writes "Easy to set up and had no issues with stability, but it's not a very friendly tool, and its database modeling and entity-relationship modeling functions need improvement". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Toad Data Modeler, erwin Evolve by Quest and Aqua Data Studio, whereas Sparx Systems Enterprise Architect is most compared with Visual Paradigm, Visio, No Magic MagicDraw, Lucidchart and LeanIX. See our IDERA ER/Studio vs. Sparx Systems Enterprise Architect 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.