Compare Sparx Systems Enterprise Architect vs. erwin Data Modeler (DM)

Cancel
You must select at least 2 products to compare!
Most Helpful Review
Find out what your peers are saying about Sparx Systems Enterprise Architect vs. erwin Data Modeler (DM) and other solutions. Updated: July 2021.
521,690 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
"The most valuable feature is the ability to share the logic within the rules engine with the business, so you can put it up for everybody to read.""When I compare it with other BPM tools, like IBM, it is great, open source, and free when you use the community version.""The solution is easily compatible with HTML forms and HTML language programming and that is the most significant part.""The speed and execution of DMN was a big selling point for us. It's very good at conducting business processes that are easily modeled and presented in a way that's easy to understand.""It allows me to present or to demonstrate the business process flow, visually, without having to resort to PowerPoint, Visio, or other products.""It has an open BPM""The interface and the number of connectors that they provide are the most valuable features. The support here, it's kind of okay. But the main thing is with the number of connectors and the UI, the user interface.""Being able to use a Java-based solution makes the product flexible."

More Camunda Platform Pros »

"The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases.""When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable.""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.""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.""It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that.""Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed.""The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model.""We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."

More erwin Data Modeler (DM) Pros »

"Some of the business processes are very easy to compare when you have the diagrams.""I like that there is support for software patterns.""The most valuable features are the flexibility and adaptability of Sparx Enterprise Architect.""The most valuable feature is the integrated data model, so if I change the name of an item, all models using that object are automatically updated.""Ability to keep inventory of reusable blocks, and use in different diagrams with views of various templates.""The initial setup is easy.""Scalability is not a problem. You can always increase the footprint of what the thing can do because it's so powerful.""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."

More Sparx Systems Enterprise Architect Pros »

Cons
"I would like to see the forms engine available in the open-source version of this solution.""I would like to have a feature for audit logging, audit logs and audit log management. And some history of use for the audit logs.""I would also like a very easy to use form builder.""Especially when you use the open-source version, there are issues with performance.""If there were some industry templates it would have helped significantly, because it is similar to a process map for a domain. That is what we are currently creating, a domain-relevant process map.""Lacking in forms visualization.""The support definitely can be improved. Apart from that, the language should be extendable to other platforms. If I want to write, I'll run a different platform, like Python code on top of it, or COBOL code on top of it, and it should support those languages.""The solution could use some enhancements like adding connectors, improving forms and having a mobile app, but everything is an enhancement rather than a flaw."

More Camunda Platform Cons »

"I would like to see more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata.""One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated.""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 would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else.""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.""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 find the UI very clunky and very difficult to use. If I add columns to a table the whole workflow could be so much easier. I get frustrated using it. I've tried other tools. I've tried to get off of erwin a few times. I always come back to it because every tool has its own set of problems, and it seems like if I have to pick my poison, I stay with erwin. But so many things that are clunky with it.""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 (DM) Cons »

"I think that collaboration can be better.""It would be nice to have it supported on the Linux operating system.""Using EA involves a steep learning curve if you want to understand its capabilities and functionality.""This solution should have better ease of use for the uninitiated.""Not visually appealing.""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.""I think the product is good. When I'm trying to do something specific for some part of project documentation, it's hard to get it figured out if you don't use it all the time. It's such a massive tool, it's hard to figure out how to dig in and get to the documentation where you have to be to get some idea of what to do. There are not a lot of examples that I'm aware of to be able to do that.""Because its easy to create diagrams one needs to be vigilant on the housekeeping of orphaned fragments - I have written my own scripts to do this, maybe they are available now."

More Sparx Systems Enterprise Architect Cons »

Pricing and Cost Advice
"We are using the open-source version of this solution.""Camunda is much cheaper.""I use the open-source free version.""The open-source version of the product is free to use.""The cost of this solution is better than some competing products.""Licensing costs are anywhere from $80,000 to $100,000 USD per year.""We use the open-source version, which can be used at no cost.""I think Camunda BPM can improve their licensing costs. It isn't easy to find clients with Camunda BPM licenses mainly because it's quite expensive."

More Camunda Platform 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."

More erwin Data Modeler (DM) Pricing and Cost Advice »

"In terms of cost, Sparx EA is probably one of the cheapest tools I have ever used.""The licensing is not as expensive as some of the other data modeling tools such as Erwin.""Its price is very good for the value that you get with it.""They have the price on their site for the enterprise version, and we do receive a small discount.""The licence has a costly upfront fee which gets you access. You have to pay an annual maintenance fee, which is less.""It is cheaper than other solutions. Its cost is around $686 per year. There are no costs in addition to the standard licensing fees.""We have an annual license, and it's very affordable.""I think our license costs roughly $1,000 a year, but I could be wrong."

More Sparx Systems Enterprise Architect Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Architecture Management solutions are best for your needs.
521,690 professionals have used our research since 2012.
Questions from the Community
Top Answer: The Camunda BPMN Platform is very flexible and gives several options to deploy and scale it.
Top Answer: There is an open-source version available, that in its core features (workflow and decision engine, modeler) is exactly… more »
Top Answer: In the future, I would definitely like to see the process administration (migration, audit, tracking) and process… more »
Top Answer: The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts… more »
Top Answer: We always had a problem keeping track of all the licenses. All of a sudden you might get a message that your license… more »
Top Answer: We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and… more »
Top Answer: A feature I like most about Sparx Systems Enterprise Architect is its ease of use.
Top Answer: I think our license costs roughly $1,000 a year, but I could be wrong.
Top Answer: My customers use Bizagi, although I do not. I don't want to change this. What should be improved, however, are the… more »
Popular Comparisons
Also Known As
Camunda BPM
erwin DM
Learn More
Overview

Camunda Platform is a complete process automation tech stack with powerful execution engines for BPMN workflows and DMN decisions paired with essential applications for modeling, operations, and analytics.

With a clear vision to automate any process, anywhere, Camunda is reinventing process automation for the digital enterprise. Featuring a developer-friendly, open source approach, enterprises can use Camunda Platform to breakthrough technological, organizational, and infrastructure barriers, optimize their business processes, and drive their digital transformation initiatives forward.

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 Enterprise Architect is a platform that accelerates and integrates software, business and systems development. Twice winner of Jolt and multiple SD Times Awards with an installed base of 580,000 + licenses, supported by 230 partners in 160 countries. From requirements to implementation and beyond, Sparx Systems' Enterprise Architect is a fully featured tool suite that lets you model, design, simulate, prototype, build, test, manage and trace from vision to solution.

Offer
Learn more about Camunda Platform
Learn more about erwin Data Modeler (DM)
Learn more about Sparx Systems Enterprise Architect
Sample Customers
24 Hour Fitness, Accruent, Allianz Indonesia, AT&T Inc., Atlassian, CSS Insurance, Deutsche Telekom, Generali, Provinzial NordWest Insurance Services, Swisscom AG, U.S. Department of Veterans Affairs, VHV Group, Zalando
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
OmniLink
Top Industries
REVIEWERS
Financial Services Firm24%
Computer Software Company24%
Comms Service Provider18%
Non Profit12%
VISITORS READING REVIEWS
Computer Software Company25%
Comms Service Provider19%
Financial Services Firm13%
Government7%
REVIEWERS
Insurance Company29%
Financial Services Firm24%
Government18%
Logistics Company12%
VISITORS READING REVIEWS
Computer Software Company22%
Financial Services Firm21%
Comms Service Provider10%
Government8%
REVIEWERS
Government18%
Energy/Utilities Company13%
Financial Services Firm13%
Computer Software Company10%
VISITORS READING REVIEWS
Computer Software Company23%
Comms Service Provider20%
Government10%
Manufacturing Company8%
Company Size
REVIEWERS
Small Business56%
Midsize Enterprise18%
Large Enterprise26%
VISITORS READING REVIEWS
Small Business15%
Midsize Enterprise28%
Large Enterprise57%
REVIEWERS
Small Business29%
Midsize Enterprise4%
Large Enterprise67%
VISITORS READING REVIEWS
Small Business2%
Midsize Enterprise1%
Large Enterprise96%
REVIEWERS
Small Business34%
Midsize Enterprise16%
Large Enterprise49%
VISITORS READING REVIEWS
Small Business10%
Midsize Enterprise17%
Large Enterprise72%
Find out what your peers are saying about Sparx Systems Enterprise Architect vs. erwin Data Modeler (DM) and other solutions. Updated: July 2021.
521,690 professionals have used our research since 2012.

erwin Data Modeler (DM) is ranked 3rd in Architecture Management with 19 reviews while Sparx Systems Enterprise Architect is ranked 1st in Architecture Management with 30 reviews. erwin Data Modeler (DM) is rated 8.8, while Sparx Systems Enterprise Architect is rated 8.2. The top reviewer of erwin Data Modeler (DM) writes "Allows us to bring in data from dozens of platforms and search holistically across all of them". On the other hand, the top reviewer of Sparx Systems Enterprise Architect writes "Great pricing with an easy initial setup and a comprehensive toolkit". erwin Data Modeler (DM) is most compared with SAP PowerDesigner, Visio, Lucidchart, AWS Well-Architected Tool and iServer, whereas Sparx Systems Enterprise Architect is most compared with Visual Paradigm, No Magic MagicDraw, Visio, ARIS BPA and IBM Rational System Architect. See our Sparx Systems Enterprise Architect vs. erwin Data Modeler (DM) report.

See our list of best Architecture Management vendors and best Business Process Design vendors.

We monitor all 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.