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.7%, up 9.9% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 24.0% mindshare, up 18.8% 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

"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"The product allows us to reuse entities and attributes."
"The product lets us import different types of models from various databases."
"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 is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"One of the best aspects of the tool is its reverse engineering capability."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"Lucidchart helped us to realize efficiencies in the projects we use it for. I can show people pictures, and I can change things in a meeting and then email it by the end of the meeting. Because most places we go, especially now with everybody in-home office, I'm going to have great internet access, and that just makes it easier to be able to change things quickly while we're in a meeting and go, "Oh, you changed this. Oh, okay.", and then send it to them as a proof and send it as a PDF or send them a link. That works great. That saves time and accelerates a sale."
"Using Lucidchart for documenting processes is great. The elements are ready to use and it is quick to do."
"Creating flowcharts and documentation is easy to do and the results are very nice."
"The swimlanes feature is one that I use a lot. I have used swimlane diagrams to create business process flows and I think that it does the job pretty well."
"Its ease of use is most valuable. As compared to draw.io, connecting the lines and doing things like that are much easier in Lucidchart. It has been great for some of the process flow diagrams and data flow diagrams. I can export these diagrams as PDFs and share them with team members."
"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."
"Documenting complicated workflows and technology integrations so that we can go back to it has also been a benefit. And without having to dig into a lot of technical, the codes, the documents, I can simply understand on a high level what's happening."
"I really like the drag and drop feature because it makes the work easier. It is very easy to use. All the pieces are very good. All the icons and all the fields are available in the left panel. So, I just click, drag, and then edit a piece. When I showed it to my managing director, he was very inspired, and he also got a premium account for himself."
 

Cons

"I would like the solution to be more user-friendly to deploy."
"I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk."
"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."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"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."
"As someone who has used it for a long time, I have seen stability vary from version to version."
"The navigation is a little bit of a challenge. It's painful. For example, if you've got a view open and you want to try to move from side to side, the standard today is being able to drag and drop left and right. You can't really do that in the model. Moving around the model is painful because it doesn't follow the Windows model today."
"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."
"Sometimes, I have created charts with a lot of layers, which locks down parts of the chart and hides parts of the chart to edit it. If they have a better way to deal with specific layers when it gets complex, then that would be helpful. I would like to see something like an illustrator program, where they have a pallet of these layers that I want and don't want as well as being able to see each layer individually. That is the one thing that could be helpful."
"When you want to add text to a connector arrow, I have not figured out how to position the text vertically. It always wants the text to stay horizontal."
"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."
"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."
"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."
"In terms of improvement, there can be more templates. There are good templates but there could still be more."
"As far as I know, LucidChart can’t be automated with Visual Basic .Net like Visio."
 

Pricing and Cost Advice

"There are two license options and the pricing is reasonable."
"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."
"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."
"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 price should be lower in order to be on the same level as its competitors."
"Likewise, the solution is a little pricey."
"I have a subscription as an individual user for one year, and it is not 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 only used the trial version and have not yet paid for it, or explored the pricing options."
"I'm happy with the pricing of Lucidchart but I can't say I'm completely happy with it. It could be cheaper for what it offers, about $5 cheaper, or Lucid could charge $5 more and add more features, like automation. Right now, it's $15 per user per month... On the other hand, they have made their billing super-easy for users, such as for people who have to do expense reports. It is probably the easiest platform I'm using when it comes to billing for software as a service."
"The pricing and licensing are fine, though I wish they didn't require you to buy the licenses in batches of five."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"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."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
849,686 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: March 2025.
849,686 professionals have used our research since 2012.