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

No Magic MagicDraw vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024

Review summaries and opinions

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

Categories and Ranking

erwin Data Modeler by Quest
Ranking in Business Process Design
9th
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (3rd)
No Magic MagicDraw
Ranking in Business Process Design
13th
Average Rating
8.4
Reviews Sentiment
7.5
Number of Reviews
18
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of May 2025, in the Business Process Design category, the mindshare of erwin Data Modeler by Quest is 2.2%, down from 2.4% compared to the previous year. The mindshare of No Magic MagicDraw is 3.1%, down from 3.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Business Process Design
 

Featured Reviews

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.
DiegoRangel - PeerSpot reviewer
Enhanced team communication and design exploration with integrated simulation tools
I was using No Magic MagicDraw to model operations, such as using different kinds of operations with ships or crafts and other systems No Magic MagicDraw facilitated great communication within the team and allowed for the exploration of different designs and architectures, which was beneficial…

Quotes from Members

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

Pros

"The fitting model is very intuitive."
"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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 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 supports a wide variety of databases, including the latest ones. We have chosen to go for a cloud-based database, and it supports that, which is very useful."
"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."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"The principal feature that I liked is that the solution has a very graphic interface."
"There is a lot of documentation available on the Internet to understand its functionality."
"The initial setup was not straightforward."
"I would rate MagicDraw a nine out of ten because of the price. Enterprise Architect has a lot of bugs and MagicDraw is a lot more accurate and flexible. It's a level better."
"I think one of the key things is the plugins for integration with requirements management tools like Doors"
"When you look at it, No Magic is an all-encompassing tool. You can use it for business architecture design. You can use it for deploying an ERP system across your enterprise. However, it was initially designed and developed for model-based systems engineering. That's the systems engineering required to either produce an IP system or product. It takes away the mounds of paper and puts it into a model. It enables you to generate significant savings by modeling that new product or that system before you ever start developing a prototype."
"The most valuable feature is the amount of flexibility that one has to model, which is great for an individual."
"The most valuable feature of No Magic MagicDraw is the simulation capabilities and interface."
"It is pretty easy to use. It is pretty versatile."
 

Cons

"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."
"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."
"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."
"One of the best aspects of the tool is its reverse engineering capability."
"The erwin Data Modeler is quite complex to use."
"The solution's model mark could be better because it crashes sometimes."
"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."
"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."
"I would like to see the ability to deploy live business process models and capture real-time data (without the need for another product tool) so you don't have to be dependent on other products for this functionality."
"There could be a trial version for students."
"The cost of upgrading the product should be lower."
"It's very focused on specific modern languages and it doesn't do necessarily general systems software engineering with diagrams. They should expand the diagram types for the languages."
"For the next releases, I would like to have them import requirements from other sources. They could make it very easy to do that because there are a lot requirements management tools like DOORS, D-O-O-R-S, Dynamic Object Oriented Management. A lot of folks use DOORS to create a requirement. For those requirements you allocate them to a component in the architecture and a verification method for that requirement. It would be good if we could import those into MagicDraw as components so you don't have to manually do these things."
"The licenses are expensive compared to similar tools. At the moment, the user is open to using MagicDraw if it's 15% more than other solutions. If it were to cost any more, they wouldn't use it."
"There's lots of documentation. They process multiples of guides. They've got all kinds of guides and documentation out there, but it's kind of hard to find. There are a lot of videos. You can go to YouTube and find videos on how it's been used in different ways, but it just kind of scratches the surface."
"They don't really support code engineering, and that's why we have to move to Enterprise Architect. MagicDraw is stuck at C++03 standards, whereas most C++ programs today want to use the latest definition of the C++ standards. We were at C++11, and we wanted to do code engineering with C++11 or 17, but they didn't support it. That pushed us into a different tool, which is Sparx Enterprise Architect."
 

Pricing and Cost Advice

"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 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."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"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."
"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 primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"I would say licensing would be anywhere from $3,500 to $6,500 per person or per seat (it's a per seat style license)."
"In addition to the initial cost, you have to pay annually for support in order to get the upgrades."
"The licensing is on a yearly basis, and it's expensive."
"I rate the pricing a ten out of ten. It is an expensive product compared to software for model-based system engineering."
"The price of No Magic MagicDraw could improve. The price of the solution is too expensive for smaller-sized companies. There should be a better pricing model."
report
Use our free recommendation engine to learn which Business Process Design solutions are best for your needs.
851,604 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
10%
Government
9%
Computer Software Company
7%
Manufacturing Company
22%
Government
15%
Aerospace/Defense Firm
12%
Financial Services Firm
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

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?
As a documenting tool, it's solid, though its reporting could be more robust. The reporting mechanisms could be more intuitive regarding report creation. It can generate reports in CSV files, displ...
What do you like most about No Magic MagicDraw?
There is a lot of documentation available on the Internet to understand its functionality.
What is your experience regarding pricing and costs for No Magic MagicDraw?
Maybe the price is a little bit high for a small company to acquire this tool. However, they offer trial versions and trial licenses for members of INCOSE.
What needs improvement with No Magic MagicDraw?
I don't think there are areas that need improvement.
 

Also Known As

erwin DM
MagicDraw
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Northrop Grumman, Labcorp, Deposco, ClearView Training, IT Services Promotion Agency, Intelligent Chaos, Metalithic Systems Inc., Sodifrance
Find out what your peers are saying about No Magic MagicDraw vs. erwin Data Modeler by Quest and other solutions. Updated: April 2025.
851,604 professionals have used our research since 2012.