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
48
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

"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."
"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."
"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 fitting model is very intuitive."
"There is absolutely no problem with the stability."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"I love the way erwin Data Modeler creates data models and presents them for our users."
"The most valuable features are the visibility, standard compliance, and interface."
"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 MBFC capability of MagicDraw is higher than the other competitors."
"No Magic has the tools and capability to model a complete enterprise and all product lines."
"It is pretty easy to use. It is pretty versatile."
"The beauty of MagicDraw is that it has a simulation part, so you can simulate your model to validate it. The simulation allows you to bring in code off of an external code that you can write to set up the simulation and execute the code."
"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."
"The most valuable feature is the ability to quickly build multiple layers within the organizational and business process environments, as well as in the SysML product environments, and converting to files that can be accessed by clients who do not have a system and a teamwork server access."
 

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."
"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."
"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."
"There is a lack of local support in the China region."
"While I do not have knowledge about pricing for erwin Data Modeler, I think it could improve by having a feature that allows the publishing of models, similar to how Power BI allows for dashboard publishing for different users within an organization, not just data modelers."
"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."
"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."
"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."
"The technical support is not very good."
"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 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."
"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."
"The UI UX of the tool is not really user-friendly and needs to be completely reformed."
"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."
"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."
"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."
 

Pricing and Cost Advice

"The solution is expensive."
"erwin Data Modeler by Quest is an expensive solution."
"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"Pricing is very high compared to any other product."
"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 of erwin Data Modeler is very expensive, in particular for this part of the world."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"Likewise, the solution is a little pricey."
"I rate the pricing a ten out of ten. It is an expensive product compared to software for model-based system engineering."
"In addition to the initial cost, you have to pay annually for support in order to get the upgrades."
"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."
"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)."
"The licensing is on a yearly basis, and it's expensive."
report
Use our free recommendation engine to learn which Business Process Design solutions are best for your needs.
882,260 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
17%
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 Enterprise35
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, it depends on the company. For a cloud or SaaS standard edition, it typically runs around two hundred to two hundred ninety-nine US dollars per month. For a workgroup edition, it...
What needs improvement with erwin Data Modeler by Quest?
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. Ve...
What is your primary use case for erwin Data Modeler by Quest?
My use case is mostly architectural design for our end-to-end deployment.
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.
882,260 professionals have used our research since 2012.