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."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 tool is simple to use."
"Straightforward setup."
"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."
"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."
"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 are able to document the data lineage and data flows of our data from one system to another."
"The most valuable features are... those that enable me to represent the database to the development community and the business users."
"The product offers very good support for all mainstream modeling notations and architectural frameworks."
"It is an EA tool that is approved by Open Group. It is in the tool register of Open Group."
"It's easy to search within the solution."
"Some of the business processes are very easy to compare when you have the diagrams."
"Ability to keep inventory of reusable blocks, and use in different diagrams with views of various templates."
"Ability to model and create view under same roof."
"Simplified our task at maintaining architecture information and traceability with requirements."
"I have found the Meta Model tuning feature useful as it provides me with an overview of all my work needs."
"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."
"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."
"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 model diagram because very clumsy when you save it on the team server and the models are very big."
"This solution needs more precise documentation."
"We would always like to see Repository performance improve, checking in and checking out."
"The screens are a bit outdated. They could use a new look and feel."
"The window froze for five or ten seconds. You can click and click again and it takes a second to come up. It might have been specific to a version."
"The fact that you can do a lot yourself is a plus point, but it also becomes a challenge because you need an understanding of the programming languages to get things to work. It becomes challenging for those who are not very good at programming. You have standard reports, but if you want to make your own reports, you have to program it. Similarly, if you want validations rules, you have to take care of them yourself."
"More challenging than other tools to maintain documents and document versions for an architecture board review."
"Using EA involves a steep learning curve if you want to understand its capabilities and functionality."
"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."
"Their technical support is not good in India. I wrote to them because I had a question, but I never got an answer. So, I just left it behind."
"The integration could be improved."
"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."
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, erwin Evolve by Quest, Aqua Data Studio and Toad Data Modeler, 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.