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

No Magic MagicDraw vs erwin Data Modeler comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 23, 2025

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
Ranking in Business Process Design
7th
Average Rating
8.4
Reviews Sentiment
5.9
Number of Reviews
47
Ranking in other categories
Enterprise Architecture Management (2nd), Data Governance (9th)
No Magic MagicDraw
Ranking in Business Process Design
14th
Average Rating
8.4
Reviews Sentiment
6.0
Number of Reviews
19
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of February 2026, in the Business Process Design category, the mindshare of erwin Data Modeler is 2.6%, up from 2.3% compared to the previous year. The mindshare of No Magic MagicDraw is 2.6%, down from 3.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Business Process Design Market Share Distribution
ProductMarket Share (%)
erwin Data Modeler2.6%
No Magic MagicDraw2.6%
Other94.8%
Business Process Design
 

Featured Reviews

Sushree Panigrahi - PeerSpot reviewer
Snowflake Data Engineer| Senior PLSQL Developer |Data Modeler|Assitant Vice Pre at Jp Morgan Chase & Co.
Data modeling has transformed regulatory reporting and collaboration across cloud environments
In erwin Data Modeler, areas that have room for improvement include performance improvements. I see that large models sometimes cause it to be slow when opening. Impact analysis can lag as well. Version control is another aspect. If we have developed a current version, it is not integrated with Git where we can easily compare different versions. UI modernization is also something we cannot utilize as it is primarily for development. Additionally, cloud-specific optimizations are needed when it comes to Snowflake or Databricks. When it comes to AI aspects, auto-suggestions for normalization or identifying primary, foreign, or surrogate keys are areas that can be improved.
reviewer2080611 - PeerSpot reviewer
System Engineer at a consultancy with 51-200 employees
Ease of use and real-time collaboration empower effective teamwork and streamlined development
For CAMEO, it's not only the ease of use, it's versatility, its communicability, but Rhapsody is the worst tool I've ever used. It is very difficult, not user-friendly, and very expensive. It works only with its IBM counterparts. SPARX Enterprise Architecture is very easy to use, but it's limited. It gives you an idea of how your model is developing, so this feature helps maintain integrity or correctness of system models. It's really a good feature to have. You've got to have the simulation toolkit installed to be able to do that, and that works really well. The MagicDraw or CAMEO system is good on its own, but it should be integrated and should come out of the box with the simulation toolkit because there are some things you can't do without it, making it very difficult to have to look for another license to be able to do that. I would prefer that it come with the simulation toolkit.

Quotes from Members

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

Pros

"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"The principal feature that I liked is that the solution has a very graphic interface."
"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."
"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 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 product allows us to reuse entities and attributes."
"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."
"I like the traceability feature. Whoever is working with the product would be sure of the things that could be affected if they decided to affect one of the other companies. For example, let's say that an engineer starts a new project optimization problem by adjusting the thickness of metal sheets. However, the engineers only see a reduced number of affections, but when we use the requirement traceability, they can see the whole picture. That's the main aspect that we were promoting with this tool."
"It is very user-friendly, and the customer service is really good."
"Offers good standards compliance and is user-friendly."
"The MBFC capability of MagicDraw is higher than the other competitors."
"The most valuable feature is the amount of flexibility that one has to model, which is great for an individual."
"The most valuable features with No Magic MagicDraw are its ease of use; you can put this in front of a 12-year-old and they would know what to do right away."
"There is a lot of documentation available on the Internet to understand its functionality."
"No Magic has the tools and capability to model a complete enterprise and all product lines."
 

Cons

"As erwin Data Modeler files get larger, the response time really slows down, and when I have multiple files open I sometimes get a glitch where a lot of the text fields get solid black and the first eight characters of column names might be blacked out with a rectangle."
"One of the best aspects of the tool is its reverse engineering capability."
"I would like to have more data sources from other, different vendors. In recent years, the vendor has reduced the number of data sources, and I would like to have more data sources for every brand. For example, with Oracle, I would like to have compatibility for many versions, including old ones, not just the most recent."
"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."
"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 rate the visualization feature in erwin Data Modeler a six out of ten because the visualization is somewhat poor and some of the features are not user-friendly."
"erwin is not as robust as a data warehousing project I've been on in the past."
"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."
"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."
"One potential area for improvement is the recommendation feature. At times, we face challenges in locating specific features, and we have to reach out for assistance in finding the information we need."
"The technical support is not very good."
"Some of No Magic MagicDraw's most valuable features were its integration with other simulation tools, such as MATLAB, the seasonal plugin, and the Rangel simulation toolkit."
"There are some technical features that you have to study and do research on to be able to understand."
"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."
"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."
"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."
 

Pricing and Cost Advice

"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 solution is expensive."
"There are no costs in addition to the standard licensing fees."
"Though the solution is not cheap, it's worth the money."
"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."
"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 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 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."
"The licensing is on a yearly basis, and it's expensive."
"In addition to the initial cost, you have to pay annually for support in order to get the upgrades."
"I rate the pricing a ten out of ten. It is an expensive product compared to software for model-based system engineering."
"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)."
report
Use our free recommendation engine to learn which Business Process Design solutions are best for your needs.
881,360 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
8%
Government
8%
Performing Arts
5%
Manufacturing Company
24%
Government
11%
Aerospace/Defense Firm
10%
Financial Services Firm
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business16
Midsize Enterprise3
Large Enterprise34
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise1
Large Enterprise7
 

Questions from the Community

What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
Regarding pricing, I am unsure what the exact price is for erwin Data Modeler, but I believe it is not useful for an individual. It is more targeted toward an enterprise level since organizations l...
What needs improvement with erwin Data Modeler by Quest?
I write code and I write code accessing erwin Data Modeler's API, the Application Programming Interface, so that I can use Excel to update erwin Data Modeler and then get those updates and put them...
What is your primary use case for erwin Data Modeler by Quest?
I work for CVS with a pretty big database as a data modeler on the PBMs, the Caremark PBM side, which is the Pharmacy Benefits Manager. There's a retail side too for all the stores, but our data wa...
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?
For CAMEO, it's not only the ease of use, it's versatility, its communicability, but Rhapsody is the worst tool I've ever used. It is very difficult, not user-friendly, and very expensive. It works...
What is your primary use case for No Magic MagicDraw?
I deal with DOD lifecycle acquisition sorts of things as some of the main use cases currently, and I expect to continue using it for more than 25 years.
 

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 and other solutions. Updated: February 2026.
881,360 professionals have used our research since 2012.