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

Lucidchart vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive Summary

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
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (3rd), Business Process Design (10th)
Lucidchart
Average Rating
8.6
Reviews Sentiment
8.1
Number of Reviews
54
Ranking in other categories
Mind Mapping Software (2nd), Visual Collaboration Platforms (3rd)
 

Mindshare comparison

erwin Data Modeler by Quest and Lucidchart aren’t in the same category and serve different purposes. erwin Data Modeler by Quest is designed for Enterprise Architecture Management and holds a mindshare of 10.2%, up 10.0% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 23.7% mindshare, up 20.3% since last year.
Enterprise Architecture Management
Mind Mapping Software
 

Featured Reviews

Saswata Mondal - PeerSpot reviewer
The creation of data models is easy and quick, and the fitting model is very intuitive
The ease and quick ability to create the model is valuable. The fitting model is very intuitive. The other cool feature is the reverse engineer feature. If we connect to the database, we can reverse engineer from the database itself of the physical model. That gives us the relationship of the data if not much documentation is available.
MichaelChirinian - PeerSpot reviewer
Intuitive, integrates well, and is a great way to change text into visual ideas
I'm not a super user, and there might be a way of doing it that I haven't explored, but I was looking for some specific icons that are just standard icons, and I found the icon library to be very focused on architecture icons. It didn't have as many standard or generic icons. Another thing that somewhat irritated me is the fact that there is a paste function in the menu, but when you right-click and select paste, it tells you that you can't use paste. You must press Command-V or Apple-V to paste. They give you a menu option to paste, but every time you use that, they say, "We don't accept it." On top of that, normally, you'd have an option for paste or paste values, but when you use the paste function, you don't have that capability. So, to copy text from one place, I have to use Command-V to paste it, but if I don't like the format, I've got to go back and do copy style and then paste style on top of that. It is a small detail, but when you're doing diagrams, it is annoying that they don't support paste values. It is a small irk. I'm not penalizing it, and I still think it is a five-star product. In terms of other bigger things, I don't really have any comments or criticism so far.

Quotes from Members

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

Pros

"It is a scalable solution...The technical support team is fine."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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 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 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."
"The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically."
"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."
"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."
"When it comes to documenting things like processes, systems, and new teams, I'd give it an eight or nine out of ten. It's very high because it's fairly intuitive, there's a low learning curve, and it's easy to get immediate output. You can get results very quickly without a lot of direct effort. You don't usually take a week-long series of training. You don't need to go through a lot of hoops to make it work."
"The interface is very good and easy to use. We don't need documentation on how to use it. It is self-explanatory, which is very convenient for a new user."
"The interface is really good and it is very easy to use."
"The organizational charts for visualizing and understanding team hierarchies and relationships are the reason why we purchased the package that would allow me to do more with it. I tried to find all the cheap ways to do things but the ease of access and the already preset structure that Lucidchart had in place made it easier. Out of all the choices that I saw come across my desk, Lucidchart was the best and easiest choice."
"Documenting things such as processes, systems, and new teams has been my primary use case. Lucidchart is really, really valuable for its ability to create a process chart from start to end. The web app makes it easy because everything is similar to other tools like Visio but Lucidchart feels a little bit more intuitive. It has been easy to use the web app. I definitely have learned a lot about how to bring in my own graphics or images in place of some of the shapes and I'm able to create and use the arrows within the processes, so it definitely has been useful for me."
"It gives information about the roles and responsibilities of any architecture system and the exact system flow, business flow, or process flow. It also gives information about how the development team should take it forward. It shows the gap analysis in the flow charts and makes it easy to define the actor and his roles and responsibilities in the organization."
"It's very easy to use. I didn't go through any tutorials or any documentation. It was very easy for me to start. It is intuitive. Right after logging in, I was able to quickly just drag and drop and do the things I wanted to do, without any prior knowledge of the solution."
"The most valuable features are the different templates that they have already created, as well as all the different shapes you can use in the process charts because each shape stands for a different element or thing that's being done. It's easy to distinguish between different steps using the already set-out shapes."
 

Cons

"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"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."
"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 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 ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"One of the things that I find frustrating is that all of our Tableau information is on a server, so when I send that out people can't open it and use it. I then have to go back and do extra work to convert everything into an Excel format that everybody can use. It would be really important to me, if I send something out to somebody who doesn't have a Lucid account, that they can just click and see it, instead of having to log in and create an account."
"I'm not a super user, and there might be a way of doing it that I haven't explored, but I was looking for some specific icons that are just standard icons, and I found the icon library to be very focused on architecture icons. It didn't have as many standard or generic icons."
"As far as I know, LucidChart can’t be automated with Visual Basic .Net like Visio."
"Lucid should create some proper documentation and video tutorials to demonstrate the capabilities of the product to new users. It should explain everything that it offers and everything that it can be used for."
"They should continue to bring in more shapes. For example, I saw something cool the other day that was a timeline and in between each step, there was a circle. I thought that that was very clean and that's something that I could see myself using. Lucidchart could come up with more visualizations. I'm not a designer so I would like to have more visuals. That would make my job easier because it would make my job much more professional looking but without having to be a designer myself."
"I would like an on-premises version of the software that I can just download and use. I think that it's easier that way."
"Perhaps it already exists, but if there were software to install the solution on a Mac, that would be helpful. I see that it's not in the App Store, so that's something that could be improved."
"There is a premium for the use of certain elements in Lucidchart... It becomes very annoying, especially if you are a first-time user of Lucidchart and you don't have a premium plan. It feels a little too restrictive, in terms of using very basic shapes and icons. It asks you to sign-up for the premium account, which I think shouldn't be the case."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"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 pricing of the solution is cheap. I rate the pricing a five out of ten."
"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."
"Likewise, the solution is a little pricey."
"Though the solution is not cheap, it's worth the money."
"The tool is expensive."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
"I have only used the trial version and have not yet paid for it, or explored the pricing options."
"The pricing is very competitive. It is more cost-effective than some competing products, such as Visio."
"We chose Lucid based on the price comparison between it and draw.io... Lucidchart was about 15 percent cheaper per user... I was surprised to learn that it came with a separate subscription model and was not included in my existing Lucidchart subscription."
"There is a nominal charge for the paid version of the product. They have a free version available and from what I could see, there was not much difference between it and the pro version."
"Pricing comes in at about $100 for a year's subscription, which is very reasonable if this is a tool that you will use more than once."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"One of the reasons we were able to get approval within two hours from our management was that it was cheap enough. We have a 3% or 10% collaboration package, which comes out to be 70 bucks a year. It was very cheap, and we had no issues actually getting the full version. It was very affordable for a business."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
862,499 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
Financial Services Firm
13%
Computer Software Company
9%
Manufacturing Company
9%
Government
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...
LucidChart vs LucidSpark for brainstorming sessions over Zoom
Hi @Krista Thompson ​ - Yes, LucidSpark is a much more nimble and, in some ways, user-friendly tool than LucidChart. LucidSpark is designed to do a better job managing multiple users participating ...
Do you recommend Lucidchart?
I definitely recommend Lucidchart. I feel it is one of the top visual collaboration platforms that’s available on the market. Out of all the solutions I have tried, it is by far the best for diagra...
 

Also Known As

erwin DM
No data available
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Google, Salesforce, Adobe, Whirlpool, Uber, Wal Mart, Pearson, Twitch, Riot Games, Western Union, Trimble, Starbucks
Find out what your peers are saying about SAP LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: July 2025.
862,499 professionals have used our research since 2012.