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."erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"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."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
"The product allows us to reuse entities and attributes."
"The data lineage feature is very valuable."
"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."
"It has centralized storage so that a data model can be shared by different teams."
"There are a couple of things. Price is one thing, but we also like the scriptability of it. We got into scripting it and automating tasks with it, and it is super duper easy to do and helpful. The API has improved over the years. We automate everything, and I love the automation aspects of it."
"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."
"The initial setup is easy."
"Large variety of profiles and frameworks available out-of-the-box without the need for customization."
"Sparx has got a range of modeling features, and I am comfortable with all its offering. I've used a lot of tools over the phone. I found EA Spark, probably the most feature rich product all in all compared to other products. The solution is very cost-effective and that is its best feature. It's a very good delivery architecture tool, which also has enterprise architecture capabilities, and it's got full life cycle processes and software development. So for me, it's a pretty comprehensive tool"
"For the most part, we find that it is remarkable how inexpensive it is."
"The advantages of Enterprise are that it's cheaper and much more practical than MagicDraw."
"The solution is easy to use, supports SysML and UML, and is able to connect to MATLAB. This is very important for us."
"erwin is not as robust as a data warehousing project I've been on in the past."
"The solution's model mark could be better because it crashes sometimes."
"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."
"I still use Visio for conceptual modeling, and that's mainly because it is easier to change things, and you can relax some of the rules. DM's eventual target is a database, which means you actually have to dot all the Is and cross all the Ts, but in a conceptual model, you don't often know what you're working with. So, that's probably a constraint with erwin. They have made it a lot easier, and they've done a lot, but there is probably still room for improvement in terms of the ease of presentation back to the business. I'm comparing it with something like Visio where you can change colors on a box, change the text color and that sort of stuff, and change the lines. Such things are a whole lot easier in Visio, but once you get a theme organized in erwin, you can apply that theme to all of the objects. So, it becomes easier, but you do have to set up that theme."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"This is a very complex product."
"I would like to see the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."
"I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk."
"The integration could be improved."
"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."
"There used to be that feature in ArchiMate Modeling of Enterprise Architect called inherited relationships. Now it's gone."
"When collaborating with other people, it needs to be more user-friendly."
"Using EA involves a steep learning curve if you want to understand its capabilities and functionality."
"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."
"I would like it to be less of a general tool. Currently, it is not a Swiss army knife that can do everything. It is not specialized for our purposes. We are a civil engineering company. We build things. We work mostly in what is known as Infra world in the Netherlands, which comprises objects such as bridges, locks, and water management. We would like to see more focus on such types of projects. It would be nice if it has more specializations. At the moment, it is very generic, and you have to create everything yourself. Our focus is more on user requirement management, which is currently very basic. I would like to see a lot more functionality in this area. Its basic functions for adding user requirements are perfect, but we need more features. Currently, it has limited possibilities for our requirements. I would also like to see better contract management and have it managed in a certain way."
"Sparx can be a bit slow. If you are trying to design software architecture, sometimes we run into issues and need to refresh."
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.