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 interface is really simple to use and it allows me to pick and choose which tables I want to reverse engineer."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"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 most valuable feature of the solution is generating DDL (data definition language)."
"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 valuable features are... those that enable me to represent the database to the development community and the business users."
"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."
"It is an EA tool that is approved by Open Group. It is in the tool register of Open Group."
"It provides good utilization and it's a convenient tool for building exact architectural work."
"Its ability to reference and link to components from any diagram."
"It's easy to search within the solution."
"The stability has been good and satisfactory. I would rate the stability a ten out of ten."
"Sparx Systems Enterprise Architect supports multiple modeling languages like ArchiMate for database design, software lifecycle visualization, and team management."
"We have found the stability to be very reliable."
"Large variety of profiles and frameworks available out-of-the-box without the need for customization."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"The screens are a bit outdated. They could use a new look and feel."
"When building the relationships there should be a little more flexibility."
"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."
"The model diagram because very clumsy when you save it on the team server and the models are very big."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"What needs the most improvement are semantic lineage and usability."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"Inconsistent UI elements must be tidied up with the toolbox gaps removed."
"For data modeling, it is not very mature when comparing with other data modeling tools."
"I struggled with most of the features for this tool, as did the rest of our architecture team."
"From a practical point of view, we need speed and reliability for creating a model and doing some really meaningful tasks such as application landscape, refactoring, etc. These are two primary criteria. Sometimes, when you import something, it creates the object duplicates, or it allows you to do something that you're not supposed to do. For example, validation is missing. This could be frustrating because when you work at a high speed, you need to come back and start fixing things that the tool allowed you to go with, which is not quite good. So, there should probably be some internal mechanisms to advise you about what you're doing and what is probably not the best idea."
"The integration could be improved."
"There should be a MATLAB-specific toolbox added to the solution with better compatibility. The connections currently are good but in the future, it needs a huge improvement."
"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."
"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."
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.