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
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
Number of Reviews
38
Ranking in other categories
Enterprise Architecture Management (3rd)
Sparx Systems Enterprise Ar...
Ranking in Business Process Design
5th
Average Rating
7.8
Number of Reviews
98
Ranking in other categories
Enterprise Architecture Management (2nd)
 

Featured Reviews

AjarMathur - PeerSpot reviewer
Jul 5, 2023
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
Jun 19, 2024
Streamline data modeling and automate network changes for increased efficiency
We are implementing erwin to streamline data modeling and automate network changes for increased efficiency and comprehensive data development. This option simplifies the need for better data indexing Quest can create conceptual and physical data models to facilitate effective communication…
Anthony Houghton - PeerSpot reviewer
May 15, 2022
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
I didn't find any valuable features in Sparx Systems Enterprise Architect because you cannot use it for re-engineering. I wanted to re-engineer the database, and it was almost impossible. I couldn't find a way. One room for improvement in Sparx Systems Enterprise Architect is that it's not very friendly. Another room for improvement in the tool is that it doesn't enable you to import the metadata from a database very easily, so reverse engineering of a database was very difficult. Its database modeling and entity-relationship modeling functions need improvement. An additional feature I'd like to see in the next release of Sparx Systems Enterprise Architect is the re-engineering of databases into logical models, if that feature's not yet there, because I haven't checked.

Quotes from Members

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

Pros

"The solution is stable. All the refreshes run very well."
"It enables decisions based upon processes that we do model, and ultimately move forward with."
"The ease of documenting and digitizing the processes was valuable to us."
"In terms of the collaboration features, from the point of discovery, it was useful to go to load up the policies and the rule sets that the client had. And in terms of exploring options and being able to model a variety of different processes, that was incredibly useful as well."
"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 is a stable solution since there has not been any downtime. Everything loads fast."
"For me the most valuable feature is that it's one depository for our bank. So it's not like everybody has their critical processes on SharePoint or on their desktops. Everything is centrally located. It's very intuitive, easy to use. The support that I get from IBM is always great."
"Business users understand it really well, which means we can then help them automate their business processes."
"The modeling portion of the tool is the most valuable. There are some notes, naming standards, and other functions that we use as well. There's a whole boatload of functionality in this thing and we use maybe 10% of it. It seems to be pretty common that not all the functionality is fully utilized. But it's just got gobs and gobs of stuff that you can implement if you so choose to."
"It is a scalable solution...The technical support team is fine."
"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."
"The principal feature that I liked is that the solution has a very graphic interface."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"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 data lineage feature is very valuable."
"The solution is easy to use, supports SysML and UML, and is able to connect to MATLAB. This is very important for us."
"The initial setup is easy."
"It's like a repository. So far, we use it only for Information Modelling."
"Some of the business processes are very easy to compare when you have the diagrams."
"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."
"Sparx technical support is good."
"It's a very practical solution. You don't need to do an advanced course to start using this tool."
"Scalability is not a problem. You can always increase the footprint of what the thing can do because it's so powerful."
 

Cons

"In the Blue Works Live software boxes and lines are automatically placed by the programme and can't be easily manipulated."
"Sometimes, the tool is automatic, which can complicate it, but once you're accustomed to manipulating it, you can use it very effectively."
"IBM Blueworks is BPMN 2.0 compliant, but it does not adapt to the overarching BPMN 2.0 concepts."
"Spaces are not well organized; space controls are lacking."
"We'd also like to see it be Six Sigma or Lean compatible, a lot of people have asked about that."
"The font size is really, really small and it's really not useful to print out process models because you cannot read what's written in different boxes. This makes it necessary for people to have access to the tool. We view licenses to see how the printing or output is. It's not very good."
"I wish Blueworks Live had simulations built in, but it doesn't. It also lacks a feature of reporting; ad hoc, drag and drop reporting. A lot of senior people are always asking for reports, and there's no reporting feature within IBM Blueworks."
"It is BPMN-compliant but the tool needs to be more involved to get into a completely 2.0 oriented tool. It has a few things but it's not the complete BPMN model."
"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."
"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."
"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 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."
"It is not a very stable solution. I rate the stability five out of ten."
"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."
"This is a very complex product."
"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."
"It could be more user-friendly. The tools could be more simple to use. It's a very complex solution. Because I am a business analyst, I use these tools to manage requirements, and I make models in UML, BPMN, and ArchiMate, and it's complex. In the next release, I would like to see more integrations."
"The product could be improved in terms of its ease of use and documentation. While it offers a lot of functionality, it can be difficult to grasp how to utilize these features effectively."
"The stability and performance of Sparx Systems Enterprise Architect could still be improved. Setup for it is also slightly complicated and could be improved."
"The reporting needs improvement."
"I would like the system to more "intellectually" build a scheme, place icons, and connect lines on the schemes."
"It should be made Windows compatible."
"The dashboard and connectivity could be improved."
"Not visually appealing."
 

Pricing and Cost Advice

"There are editor licenses that are around 50 euros per month, and contributor licenses that are around 30 euros per month."
"The solution is very, very cost-effective."
"Price wise, IBM Blueworks Live is in the middle range, and I would give it a five out of ten."
"Making it less expensive would be good."
"We are seeing ROI from this solution. The solution has saved us time."
"The solution is not very expensive."
"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."
"They have a free subscription model that gives a lot of power to the users."
"Pricing is very high compared to any other product."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"There are no costs in addition to the standard licensing fees."
"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"There are two license options and the pricing is reasonable."
"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."
"The price should be lower in order to be on the same level as its competitors."
"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."
"It is very economical and low cost. You have to pay for a one-time license, and it is active forever."
"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."
"This product has a paid license, with a yearly subscription option."
"I think our license costs roughly $1,000 a year, but I could be wrong."
"We had a yearly license."
"We have an annual license, and it's very affordable."
"The pricing for ultimate version is steeply high."
"There is no license required for this solution."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
814,649 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
20%
Manufacturing Company
9%
Computer Software Company
9%
Government
9%
Educational Organization
16%
Government
11%
Financial Services Firm
11%
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?
The pricing is reasonable, with the ultimate version costing around 290 Euros for renewal and the initial purchase ar...
What needs improvement with Sparx Systems Enterprise Architect?
The product could be improved in terms of its ease of use and documentation. While it offers a lot of functionality, ...
 

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: October 2024.
814,649 professionals have used our research since 2012.