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 (9th)
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.5%, up 10.0% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 23.7% mindshare, up 19.5% since last year.
Enterprise Architecture Management
Mind Mapping Software
 

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

"We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."
"It is a scalable solution...The technical support team is fine."
"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."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
"The principal feature that I liked is that the solution has a very graphic interface."
"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 has centralized storage so that a data model can be shared by different teams."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"The templates are quite valuable, as is the fact that you can export to PDF, to a Visio document, or as a picture. These are valuable features for me because they give me the ability to make changes in any other product that I'm using. I'm not bound by one platform."
"It is important to me that the solution accommodates both Mac and PC users because the developers in our company use Mac, then the business people use Windows. The technical people create the technical architecture using Lucidchart. So, it is important that it is compatible with both the systems."
"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."
"The flow chart is most valuable. It is a very user-friendly and simple-to-use product. Quite quickly, I was able to understand how to use it and just get on with my process flow."
"There is no alternative to Lucidchart if you want to describe a five-step process with bullet points. I believe every person who ever worked with PowerPoint on any type of documentation and then thought about which tool would actually help to describe what they're trying to do but without the words, would come up with Lucidchart."
"For documenting processes and systems, I would rate the solution a nine out of 10. I'm not aware of any other software that is as usable as this, because of the templates. They make documenting these things really easy."
"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."
"In general, the usability is great. You have a ton of customization options with different colors, different borders, different thicknesses of lines, different types of arrows, et cetera. There's so much variety. You can really make a chart with all sorts of color-coding, and color charts in different colors, link them together, for example, or use different types of arrows for different types of links between the chart elements. That variety, while not a specific feature, is really useful. If you want to make a chart, you can basically do anything."
 

Cons

"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."
"It is not a very stable solution. I rate the stability five out of ten."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"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."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"There is a lack of local support in the China region."
"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."
"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."
"It would be nice to have more features that help me visually present information. Since I use it as a canvas, my use case for it is probably very specific. I use it as a way to present information to people visually on a large mind map. So, it would be nice to be able to have more graphical things to clean it up, like a header, banners, or something to help draw attention to certain areas. I would also like more infographic-like features, because I am kind of limited to float chart shapes. This makes the solution a little cumbersome."
"It would be nice to be able to import not just contacts from Salesforce but also leads. In the beginning, when I was still learning the ropes and my way around it, I couldn't find such an option. There might be an option, but I just don't know about it."
"They should make it more user-friendly. The only option is either to use the existing template with already existing colors and gradients. If you want to do custom colors and gradients, then it's too complicated to use and should be simplified."
"What I do find extremely frustrating is that when I've sent the sheet to non-license holders, you have to create an account. You create a username and password. The path taken to create that account is so confusing that everyone thinks that they have to give their credit card number, and then they're reluctant. They don't want to go through the sheet."
"There were some things I wish were a little bit more user-friendly. For instance, when you're putting all the stuff onto a document or PDF, there's a set limit of width and height. It would have been very nice in certain situations to be able to drag people on the far edges and move them back up so that everything fits nicely onto the page."
"I'm not sure if this feature is already there, but it would be good if we can import a cloud database in the web version."
"One of the major drawbacks is that we have to extract the work in Lucidchart as an image when we want to create a presentation."
"There is a basic function that I struggle with, in the interface, which is having to switch between the editing and navigation modes. A lot of clicks are required when switching between edit and navigation modes and I think that many could potentially be avoided by handling the tasks at the same time."
 

Pricing and Cost Advice

"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."
"There are no costs in addition to the standard licensing fees."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"The price should be lower in order to be on the same level as its competitors."
"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 tool is expensive."
"Likewise, the solution is a little pricey."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"The price of this product is a little bit high. It is probably 20% higher than what I expected to pay for such a solution."
"I was using the paid version, but at $12 USD per month, I canceled the plan because it was a little bit too expensive for me."
"The price was low enough to make me think that it was fine, I'll go for it. I think it's $80 or so. It's not too expensive."
"I had a quick glimpse of it. It was about 100 Canadian Dollars a year for just me. I don't know if there are any additional costs."
"I have a subscription as an individual user for one year, and it is not expensive."
"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."
"The pricing and licensing are fine, though I wish they didn't require you to buy the licenses in batches of five."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
856,873 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
10%
Government
9%
Computer Software Company
7%
Financial Services Firm
13%
Computer Software Company
10%
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: June 2025.
856,873 professionals have used our research since 2012.