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
8th
Average Rating
8.6
Reviews Sentiment
5.8
Number of Reviews
45
Ranking in other categories
Enterprise Architecture Management (2nd), Data Governance (15th)
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 January 2026, in the Business Process Design category, the mindshare of erwin Data Modeler is 2.5%, up from 2.2% compared to the previous year. The mindshare of No Magic MagicDraw is 2.7%, down from 3.3% 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.5%
No Magic MagicDraw2.7%
Other94.8%
Business Process Design
 

Featured Reviews

reviewer2795649 - PeerSpot reviewer
Senior Data Architect at a computer software company with 1,001-5,000 employees
Data modeling has enabled end-to-end designs and has improved collaboration between teams
Areas of erwin Data Modeler that I think could be improved or enhanced include a few things. I have not worked in erwin for the past four to five years, but based on my 20 years of career experience, I worked with erwin one or two years on an earlier project and currently am working with it again. Based on my overall 20 years of career experience, I have worked with erwin modeling for four to five years. I am not a master of the tool, but I cannot identify significant flaws. The price should be reduced. That could be one area of improvement. Additionally, the licensing system could be enhanced. In our current project, there are five licenses within the business. If anyone is moving to erwin, the other person cannot enter the erwin solution. There should be a message indicating that five persons are involved in erwin, and you cannot use it at that time. However, that is a minor issue.
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

"Quest can create conceptual and physical data models to facilitate effective communication between business and IT. It can also integrate expertise from various engineering and database systems within your organization to enhance data management and administration."
"The solution is excellent in providing a visual representation of a database and can generate DDL for implementing changes. We use DDL for logical purposes to review with business people, ensuring they have the required fields for processing. We also use it as a data dictionary for the physical data model to understand all the purposes of the terms. This helps us map the logical and physical terms with the business definition to understand our data."
"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 most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"This tool is beneficial to any organization as it is foundational; there is no better way than this, and it is a must-have for every organization, whether large or small."
"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."
"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."
"No Magic has the tools and capability to model a complete enterprise and all product lines."
"The most valuable feature is the amount of flexibility that one has to model, which is great for an individual."
"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."
"There is a lot of documentation available on the Internet to understand its functionality."
"I think one of the key things is the plugins for integration with requirements management tools like Doors"
"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."
"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."
 

Cons

"The erwin Data Modeler is quite complex to use."
"I would like to see improved reporting and, potentially, dashboards built on top of that. Right now, it's a little manual. More automated reporting and dashboard views would help because currently you have to push things out to a spreadsheet, or to HTML, and there aren't many other options that I know of. I would like to be able to produce graphs and additional things right in the tool, instead of having to export the data somewhere else."
"The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement."
"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid."
"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."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"One of the best aspects of the tool is its reverse engineering capability."
"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."
"The price of the solution could be reduced."
"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 documentation for MagicDraw and the video tutorials compared to other competitors is an area for improvement."
"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."
"The cost of upgrading the product should be lower."
"The technical support is not very good."
"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."
 

Pricing and Cost Advice

"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."
"erwin Data Modeler by Quest is an expensive solution."
"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."
"There are no costs in addition to the standard licensing fees."
"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."
"The price should be lower in order to be on the same level as its competitors."
"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."
"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."
"In addition to the initial cost, you have to pay annually for support in order to get the upgrades."
"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."
"I rate the pricing a ten out of ten. It is an expensive product compared to software for model-based system engineering."
report
Use our free recommendation engine to learn which Business Process Design solutions are best for your needs.
880,844 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business14
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: December 2025.
880,844 professionals have used our research since 2012.