Try our new research platform with insights from 80,000+ expert users

Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest comparison

Sponsored
 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024
 

Categories and Ranking

IBM Blueworks Live
Sponsored
Ranking in Business Process Design
12th
Average Rating
8.2
Reviews Sentiment
7.5
Number of Reviews
20
Ranking in other categories
No ranking in other categories
erwin Data Modeler by Quest
Ranking in Business Process Design
9th
Average Rating
8.6
Reviews Sentiment
6.5
Number of Reviews
38
Ranking in other categories
Enterprise Architecture Management (3rd)
Sparx Systems Enterprise Ar...
Ranking in Business Process Design
4th
Average Rating
7.8
Reviews Sentiment
6.9
Number of Reviews
99
Ranking in other categories
Enterprise Architecture Management (2nd)
 

Featured Reviews

AjarMathur - PeerSpot reviewer
An easily scalable and affordable solution that enables users to document and digitize processes with ease
IBM Blueworks is BPMN 2.0 compliant, but it does not adapt to the overarching BPMN 2.0 concepts. There is only one kind of BPMN 2.0 diagram. It is a process diagram. It doesn't have the concept of separate tools, which other products offer. If I had to do a hardcore BPMN 2.0 modeling, the product would have its own reservations. There were features we could not explore from a BPMN 2.0 perspective. Most of the time, people who are shifting from Microsoft Office tools to a digitized way of working still want the reporting capabilities to be strong. Some tools, like ARIS or Signavio, offer customized solutions from the reporting perspective. If I have documented my whole finance process and want to fetch out a complete SOP report in a very customized manner, IBM Blueworks cannot provide it. We have to rely on some other services. So that's one area in which we always struggled, how to really customize the reporting aspects. I understand that we need to keep the tool a little more asset-light. It's very difficult to keep adding many options, but at least a few BPMN 2.0 options were needed. We have been suggesting to IBM that we should have some way of customizing the reporting. At least we should get a custom way of reporting it into different formats like Excel or putting up a logo for one of the clients so that their SAP can be printed that way.
JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.
Milan Sterba - PeerSpot reviewer
Efficient documentation generation through organized model structure with a good price-performance ratio
Whenever I begin a new project with Sparx, I have to spend time training people on how to use it since it is not straightforward. Although it's a powerful product with plenty of features, it's not easy for even experienced users to find their way without guidance. This is not the most user-friendly solution.

Quotes from Members

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

Pros

"The licenses are transferrable between different users."
"It is a stable solution since there has not been any downtime. Everything loads fast."
"We are you using the product as a process mapping tool and as part of a larger process improvement project. We use it with IBM BPM and IBM ODM. We get an automated workflow solution for our customers, an improved workflow automation."
"It has a built-in capability to capture process owners and managers against processes along with other process governance roles."
"The solution is easy to operate. Also, there is an automatic mode to make the business flow. You don't have to put any lines or arrows in a decision point in IBM Blueworks Live; it's very automatic."
"It has the ability to document in different formats. It is not tied to a specific model. You can look at it from different angles and see the intuitive nature of it. It always generates a valid diagram. You cannot create something that is not BPMN compliant."
"For me, what I find to be the most valuable is its simplicity and the association with Microsoft Office."
"It enables decisions based upon processes that we do model, and ultimately move forward with."
"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."
"It has centralized storage so that a data model can be shared by different teams."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera."
"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."
"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."
"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."
"The principal feature that I liked is that the solution has a very graphic interface."
"Automated document generation is a real time saver, no more cut and paste, no more keeping track of which diagrams are in which reports, no more last minute update panics. Just click a mouse and you've got an up to date report."
"Its traversability is most valuable. I can use ArchiMate, and I can create a UML model. ArchiMate is for logical enterprise architecture, UML is for software engineering, and BPMN is for business processes. I can build it to have multiple models, and they are also traversable, which is not something that every tool allows. If there is a huge organization, you can segment it and have separate models for business technology or internal resource management system. You don't need to keep them in one model, and you can decide to segregate them."
"We have found the stability to be very reliable."
"The solution allows us to quickly present designs and concepts to customers and get their feedback, thereby moving the project forward step by step."
"The stability has been good and satisfactory. I would rate the stability a ten out of ten."
"The initial setup is easy."
"It provides good utilization and it's a convenient tool for building exact architectural work."
"I have found the Meta Model tuning feature useful as it provides me with an overview of all my work needs."
 

Cons

"There should be an option to import from and export to Microsoft Visio. Being able to move files back and forth between Blueworks Live and Visio would be good."
"IBM Blueworks is BPMN 2.0 compliant, but it does not adapt to the overarching BPMN 2.0 concepts."
"Some of the import functionality was a bit restrictive, in terms of loading data in from other data sources. Something as simple as Excel, loading data tables from Excel, wasn't great. And vice-versa. Some of the export and import functionality with something like Visio - which, I know it's a slightly different tool - but being able to work seamlessly with those other tool sets would've been quite useful. I know it was something that was in the pipeline to be looked at. So that would be useful."
"We would like the ability to add additional custom colors. We would like to color additional items to add notes to the blueprint."
"In the solution Signavio, they have a customer journey mapping feature that should be added to IBM Blueworks Live. It's valuable to map or document the customer journey to identify the pains and opportunities in this process."
"The APIs are great, except the normal business user doesn't know how to create APIs. So it's hard because IBM comes to us as the business users and tell us to create reporting with APIs, except we don't know that, so we have to turn around and flip it to our IT people."
"I would like to see integration with ERP systems. This would help us to simulate the process and see where the problems are. Though IBM Blueworks Live is a good tool for documenting, it is not good for simulating."
"The initial setup is neither straightforward nor complex however you do need to know what you are doing."
"The interface must be improved."
"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."
"This is a very complex product."
"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."
"The erwin Data Modeler is quite complex to use."
"We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and share their models. It has become a pain point to merge the models from individual desktops and get them into a single data model, when multiple data modelers are working on a particular project. It becomes a nightmare for the senior data modeler to bring them together, especially when it comes to recreating them when you want to merge them."
"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."
"I'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"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."
"What should be improved are the integration capabilities of the solution with Bizagi."
"Weak in regards to data modelling. No logical or physical modelling or migration from conceptual to physical."
"More challenging than other tools to maintain documents and document versions for an architecture board review."
"The UI could be improved and made a little bit more presentable."
"The areas of improvement should be focused on utility service such as producing better graphics, perhaps having a wider image library set and producing better models for working directly with customers."
"They should make the Save button easier to find. A simplified user interface for a lighter user would probably be useful. I am not sure if such an interface is already there."
"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."
 

Pricing and Cost Advice

"The solution is not very expensive."
"Making it less expensive would be good."
"The solution is very, very cost-effective."
"We are seeing ROI from this solution. The solution has saved us time."
"There are editor licenses that are around 50 euros per month, and contributor licenses that are around 30 euros per month."
"They have a free subscription model that gives a lot of power to the users."
"Based on the licenses purchased, from a footprint perspective, you can have as many people as you want. You have multiple different categories of licenses to keep the cost low."
"Price wise, IBM Blueworks Live is in the middle range, and I would give it a five out of ten."
"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."
"erwin Data Modeler by Quest is an expensive solution."
"The price should be lower in order to be on the same level as its competitors."
"There are no costs in addition to the standard licensing fees."
"There is either a one-year or three-year license. It is not a pay-as-you-go license like a SaaS solution. It’s more of a traditional licensing. They are a little bit on the pricier side."
"The tool is expensive."
"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."
"Pricing is very high compared to any other product."
"We paid 1200 euros as a once-off cost. All add ons and integrations come at an additional cost."
"The solution is quite expensive."
"This product has a paid license, with a yearly subscription option."
"In terms of cost, Sparx EA is probably one of the cheapest tools I have ever used."
"It's reasonably priced for large organizations."
"The pricing is reasonable."
"The license for Sparx Systems Enterprise Architect is paid yearly, but I don't handle that area. It's good for its price, so I'm rating it a five out of five, but I'm not using it much. I also don't have information regarding additional costs apart from the standard licensing fees."
"Use floating licenses strategically."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
10%
Computer Software Company
10%
Government
9%
Financial Services Firm
19%
Manufacturing Company
9%
Government
9%
Computer Software Company
8%
Educational Organization
17%
Government
11%
Financial Services Firm
10%
Computer Software Company
9%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Blueworks Live?
The solution is easy to operate. Also, there is an automatic mode to make the business flow. You don't have to put an...
What is your experience regarding pricing and costs for IBM Blueworks Live?
The solution costs around 600-700 dollars/year, which is quite affordable.
What needs improvement with IBM Blueworks Live?
Sometimes, the tool is automatic, which can complicate it, but once you're accustomed to manipulating it, you can use...
What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.
What needs improvement with erwin Data Modeler by Quest?
The solution's model mark could be better because it crashes sometimes.
What do you like most about Sparx Systems Enterprise Architect?
The stability has been good and satisfactory. I would rate the stability a ten out of ten.
What is your experience regarding pricing and costs for Sparx Systems Enterprise Architect?
One of the reasons many public sector institutions in the Czech Republic use it is that it provides a very good price...
What needs improvement with Sparx Systems Enterprise Architect?
Whenever I begin a new project with Sparx, I have to spend time training people on how to use it since it is not stra...
 

Also Known As

IBM Lombardi Blueprint
erwin DM
No data available
 

Learn More

Video not available
 

Overview

 

Sample Customers

Cloudsoft Corp. Ltd., Bayer, S¾SS, Essex County Council
 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
OmniLink
Find out what your peers are saying about Sparx Systems Enterprise Architect vs. erwin Data Modeler by Quest and other solutions. Updated: December 2024.
824,053 professionals have used our research since 2012.