We performed a comparison between erwin Data Modeler by Quest 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 solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"The product lets us import different types of models from various databases."
"The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc."
"The product allows us to reuse entities and attributes."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"The fitting model is very intuitive."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"Its ease of use and the breadth of the toolkit are most valuable. It has an incredible repository of artifacts to work with, and they're all cross-referenced. It works with a whole bunch of different standards. It works with BPMN, which is Business Process Modeling Notation, and it also works with something called TOGAF, which is the Open Group Architecture Foundation. There are different layers when you're dealing with architecture. There is the user interface, application, data, data servers, and all that kind of stuff. You have the infrastructure, hardware, and software layers, and then you have the application and business capability layers. You can model a business process and decompose it into all of the applications, data, and hardware to support it."
"I like Sparx's BPM features and the way it lets you create the diagram."
"It is a very rich tool in terms of the functionality, and the types of diagrams, that you can create in this tool."
"Sparx Systems Enterprise Architect supports multiple modeling languages like ArchiMate for database design, software lifecycle visualization, and team management."
"Sparx Systems Enterprise Architect is very flexible and it is simple to define the metamodel. Additionally, it is lightweight on resources."
"It has led some teams to do better code reviews - to be less focussed on coding conventions (syntax) and more focussed on the semantics because of the abstraction level clear design affords."
"Provides a single repository for all architecture work."
"Ability to model and create view under same roof."
"The erwin Data Modeler is quite complex to use."
"It does not have a cloud application."
"There is a lack of local support in the China region."
"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"I would like to have more data sources from other, different vendors. In recent years, the vendor has reduced the number of data sources, and I would like to have more data sources for every brand. For example, with Oracle, I would like to have compatibility for many versions, including old ones, not just the most recent."
"The modeling product itself is far and above anything else that I've seen on the market. There are certain inconsistencies when it comes to keeping up with other platforms' databases in the reverse-engineering process. It should also support more database platforms."
"The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work."
"For data modeling, it is not very mature when comparing with other data modeling tools."
"The modeling tool is targeted toward a sophisticated user."
"The solution needs to offer better support for the mobile-based system. Right now, it's not working."
"The user interface is not so good. It's not easy for someone to use it at first. The product takes some getting used to."
"It can be improved in the area of shared documentation. The idea is that the architecture tool can call back to an enterprise asset, pull that information, and link that as a sub-artifact."
"It would be great if we could decrease the use of different parts of the Toolbox."
"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."
"When many users are accessing the system at the same time, Sparx slows down. It can't easily support a large team."
More Sparx Systems Enterprise Architect Pricing and Cost Advice →
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while Sparx Systems Enterprise Architect is ranked 2nd in Enterprise Architecture Management with 97 reviews. erwin Data Modeler by Quest is rated 8.6, while Sparx Systems Enterprise Architect is rated 8.0. The top reviewer of erwin Data Modeler by Quest writes "The product lets users import different types of models, but it is expensive, and the interface must be improved". 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". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and AWS Well-Architected Tool, whereas Sparx Systems Enterprise Architect is most compared with Visual Paradigm, Visio, No Magic MagicDraw, Lucidchart and iServer. See our Sparx Systems Enterprise Architect vs. erwin Data Modeler by Quest report.
See our list of best Enterprise Architecture Management vendors and best Business Process Design 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.