Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

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.
To learn more, read our detailed Sparx Systems Enterprise Architect vs. erwin Data Modeler by Quest Report (Updated: May 2024).
772,649 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""We can create mappings in erwin and possibly data dictionaries.""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.""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 solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application.""It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project.""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 is a scalable solution...The technical support team is fine."

More erwin Data Modeler by Quest Pros →

"The features I find most valuable is the ability to create a document and then put it into a OneCare artifact.""Its ability to reference and link to components from any diagram.""The system provides powerful tools for obtaining reports and documentation.""The product offers very good support for all mainstream modeling notations and architectural frameworks.""Ability to model and create view under same roof.""The most valuable features are the flexibility and adaptability of Sparx Enterprise Architect.""It's a very practical solution. You don't need to do an advanced course to start using this tool.""The solution saved a lot of time, about 30%."

More Sparx Systems Enterprise Architect Pros →

Cons
"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.""The solution's reporting side needs to be improved.""The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today.""Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model.""I am not so happy with its speed. Sometimes, it can have problems with connections.""The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository.""Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use.""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."

More erwin Data Modeler by Quest Cons →

"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.""This solution should have better ease of use for the uninitiated.""The dashboard and connectivity could be improved.""The UI is a little bit outdated. It should be more fresh and clean.""The modeling tool is targeted toward a sophisticated user.""The Business Process Modeling or BPM feature can be improved to make it more interactive and user friendly because it is a tool for technical people. My current use is only for business process modeling notation and putting in the icons etc. You need to take them in as a class, which makes things very complex. Because of this complexity, it is not an easy-to-handle solution. Enterprise Architect is not very good for mockups. We cannot create user screens and other similar kinds of stuff, which is bad. For these things, we prefer to use Axure RP and other similar solutions. They should either remove this feature from this product or provide some kind of connectivity with Axure RP so that people can do better mockups of screens and import them. They need to augment and strengthen the BPM feature, which is the main feature. They need to put in some elements like artificial intelligence and augmented reality. They should look into such features because these things are coming up.""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.""When collaborating with other people, it needs to be more user-friendly."

More Sparx Systems Enterprise Architect Cons →

Pricing and Cost Advice
  • "The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
  • "This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
  • "An issue right now would be that erwin doesn't have a freely available browser (that I am aware of) for people who are not data modelers or data engineers that a consumer could use to look at the data models and play with it. This would not be to make any changes, but just to visually look at what exists. There are other products out there which do have end user browsers available and allow them to access data models via the data modeling tool."
  • "The price should be lower in order to be on the same level as its competitors."
  • "I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."
  • "There are no costs in addition to the standard licensing fees."
  • "I don't specifically know what we're paying now. About three years ago, in another organization, I have this memory of 6,000 AUD a seat or something like that, but I am not sure. In the mid-2000s, it was something like 1,200 AUD a seat. I get the impression that there was a price jump when it was spun off from CA as a separate company, which is understandable, but it could sometimes be a barrier in some organizations picking it up. I haven't talked to erwin people yet, but I'm going to suggest to them that they could perhaps think of having an entry-level product that is priced a bit lower, and then, you can buy the extra suite."
  • "The price of erwin Data Modeler is very expensive, in particular for this part of the world."
  • More erwin Data Modeler by Quest Pricing and Cost Advice →

  • "The Corporate Edition, or one of the bundles, is the way to go."
  • "Use floating licenses strategically."
  • "The pricing for ultimate version is steeply high."
  • "Licenses are pretty low cost compared to, for example, ARIS."
  • "It’s the best deal in town, by far."
  • "Pricing and licensing is very attractive, simple, and straightforward."
  • "Pricing and licensing are suitable even for small companies."
  • "In terms of cost, Sparx EA is probably one of the cheapest tools I have ever used."
  • More Sparx Systems Enterprise Architect Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
    772,649 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
    Top Answer:The solution's model mark could be better because it crashes sometimes.
    Top Answer:The stability has been good and satisfactory. I would rate the stability a ten out of ten.
    Top Answer:It's reasonably priced for large organizations, though it may be perceived as expensive for individual users.
    Top Answer: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. So, two years ago, it was used very, very often, and… more »
    Ranking
    Views
    6,064
    Comparisons
    3,191
    Reviews
    11
    Average Words per Review
    432
    Rating
    7.9
    Views
    7,459
    Comparisons
    5,552
    Reviews
    6
    Average Words per Review
    452
    Rating
    7.2
    Comparisons
    Also Known As
    erwin DM
    Learn More
    Sparx Systems
    Video Not Available
    Overview

    erwin pioneered data modeling, and erwin Data Modeler (erwin DM) remains trusted, award-winning software for data modeling and database design, automating complex and time-consuming tasks. Use it to discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts.

    Sparx Systems Enterprise Architect is an enterprise solution that helps streamline, accelerate, and integrate software, system, and business development. With this intuitive modeling and design solution, enterprises can stay in control of their workplaces, enable collaboration, support their teams and colleagues, and manage complex projects. Software architects, business analysts, project managers, developers, support staff, and testers can unite under a single repository. Through numerous view points and potential sub-systems, users are offered a unified view in a complex environment.

    With Sparx Systems Enterprise Architect, users are also offered a shared model option which can be accessed quickly and securely by in-office and remote team members through the Enterprise Architect’s Pro Cloud Server. Building a coherent, verifiable model can be done by connecting and integrating a variety of behavioral and structural information in visual form. As a result, Enterprise Architect offers high performance, flexibility, and the ability to model, manage, and trace every stage of the business development and modeling process.

    Sparx Systems Enterprise Architect Features

    Sparx Systems Enterprise Architect assists in creating a unified and accessible vision in business development by offering a flexible platform with a unique set of rich features. These features include:

    • Test and debug - Streamline software development and visualize software with the simulation process. Users can test and confirm correct behavior, set and oversee test points, and debug and examine software.
    • Track tasks - Track, prioritize, and assign individual and group tasks to assist in the model’s development. Users can visually monitor their progress through the Gantt chart.
    • Open standards - Users can visualize and analyze running software with integrated custom tools. They can also run advanced simulations, team-based repositories, testing tools, and version control. In addition, the solution supports enterprise architecture frameworks such as UPDM and TOGAF.
    • Simulation - Create and debug embedded solutions by simulating behaviors and state models. Users can specify events, triggers, constraints, and more. Users can also specify extensive and complex structural systems and create custom domain-specific solutions.

    Reviews from Real Users

    Sparx Systems Enterprise Architect merges high-end tools, online availability, a dedication to open standards, and accessible pricing so enterprises can stay in control of their workplaces, whether remote or in-office. Users particularly like the architectural frameworks and the scalability.

    Marc L., a principal architecture enterprise solution adviser at Cronomagic Canada, notes, "The product offers very good support for all mainstream modeling notations and architectural frameworks."

    An enterprise architect at a manufacturing company writes, "Scalable solution for modeling, project sharing, and collaboration. Support for it is good."

    Sample Customers
     Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
    OmniLink
    Top Industries
    REVIEWERS
    Financial Services Firm28%
    Insurance Company21%
    Government14%
    Energy/Utilities Company7%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Government10%
    Computer Software Company10%
    Manufacturing Company8%
    REVIEWERS
    Government16%
    Financial Services Firm11%
    Energy/Utilities Company9%
    Manufacturing Company9%
    VISITORS READING REVIEWS
    Educational Organization14%
    Government11%
    Financial Services Firm11%
    Computer Software Company10%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise7%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise10%
    Large Enterprise73%
    REVIEWERS
    Small Business33%
    Midsize Enterprise16%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise23%
    Large Enterprise62%
    Buyer's Guide
    Sparx Systems Enterprise Architect vs. erwin Data Modeler by Quest
    May 2024
    Find out what your peers are saying about Sparx Systems Enterprise Architect vs. erwin Data Modeler by Quest and other solutions. Updated: May 2024.
    772,649 professionals have used our research since 2012.

    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, Lucidchart, Visio and AWS Well-Architected Tool, whereas Sparx Systems Enterprise Architect is most compared with Visual Paradigm, Visio, No Magic MagicDraw, LeanIX 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.