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 most valuable feature of the solution is generating DDL (data definition language)."
"It's easy to model and has a user-friendly interface. I like the team portal because, once we upload, the entire team can see the model."
"Straightforward setup."
"We have been able to quickly create models for our enterprise-wide databases, even when some of them are third-party databases."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"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."
"The tool is simple to use."
"We are able to document the data lineage and data flows of our data from one system to another."
"Features good reporting facilities coupled with a concrete database."
"The profiles allow me to customize the tool to the corporate environment instead of the other way around saving huge amounts of time and energy on trying to turn dozens of individuals into TOGAF, ArchiMate or Zachman experts, or even Sparx EA experts."
"The initial setup is easy."
"Scalability is not a problem. You can always increase the footprint of what the thing can do because it's so powerful."
"I like Sparx's BPM features and the way it lets you create the diagram."
"It is an EA tool that is approved by Open Group. It is in the tool register of Open Group."
"The company has become more efficient and reduced its budget."
"Ability to keep inventory of reusable blocks, and use in different diagrams with views of various templates."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"It would be helpful if they could create a generic JSON database type, as a target database, rather than a specific one like Mongo."
"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."
"The only thing I had an issue with was licensing, and the support was very good."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"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."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"The modeling tool is targeted toward a sophisticated user."
"The documentation could be better. Where I work, we speak French and we don't speak English, so we don't have anything in French. It's perfect in English, but we need something in French."
"No way to implement data integrity and referential integrity constraints."
"What should be improved are the integration capabilities of the solution with Bizagi."
"Its usability needs to be improved. For non-technical users, it is a little difficult to understand how Enterprise Architect works. Users who are not engineers find it difficult to understand how this tool works. This is something they need to work on. They can develop a BPM model to simulate processes."
"It took me a while to figure out how to use the report generation features effectively. So, it would be really nice if they had a way to make that a little bit more interactive and a little bit more straightforward."
"The documentation needs a bit of improvement. What I find is that when I'm trying to do something specific for some part of a project, in terms of documentation, it's kind of hard to get at figuring out if you don't use it all the time."
"The solution needs to offer better support for the mobile-based system. Right now, it's not working."
More Sparx Systems Enterprise Architect Pricing and Cost Advice →
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 34 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 LeanIX, whereas Sparx Systems Enterprise Architect is most compared with Visual Paradigm, Visio, No Magic MagicDraw, LeanIX and Lucidchart. 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.