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

Lucidchart vs erwin Data Modeler 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
Average Rating
8.6
Reviews Sentiment
7.2
Number of Reviews
39
Ranking in other categories
Enterprise Architecture Management (4th), 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 and Lucidchart aren’t in the same category and serve different purposes. erwin Data Modeler is designed for Enterprise Architecture Management and holds a mindshare of 10.0%, down 10.4% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 23.1% mindshare, up 20.0% 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

"The fitting model is very intuitive."
"The data lineage feature is very valuable."
"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."
"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."
"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"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."
"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"The best part of Lucidchart is its comfortableness when sharing it with my teammates. Lucidchart provides me a folder for my ERD. I can make a dozen lists of my chart, then share them with my teammates easily through the diagrams of Lucidchart. This is their main comfortableness, which is the reason why I choose Lucidchart rather than some other chart program."
"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."
"Creating flowcharts and documentation is easy to do and the results are very nice."
"Using Lucidchart for documenting processes is great. The elements are ready to use and it is quick to do."
"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."
"I've been using Lucidchart for quite simple things, but it's definitely much easier making process maps using Lucidchart than it is using Google Docs for basically everything. It's much simpler in terms of how easy it is to use Lucidchart. The way that you can get the arrows on the flow charts, based on the process mapping, you can drag the arrows from one box to another and it automatically shows you where you can put it. It makes decisions for you in terms of if you have a decision diamond, then the line is automatically a yes or no. This just makes it so much easier."
"Lucidchart is a 10 out of 10 when it comes to documenting things such as processes, systems, and new teams. It's just so user-friendly. The fact that even if you've never used Lucidchart, if you take a template and adapt it, you'll inevitably find something to fit your needs, but it's also perfect for building from scratch. It's the ease of use, clarity, and the different functionalities that make it incredibly useful."
"Lucidchart's capabilities for visualizing and understanding process flows or workflows is excellent. The way that you put together the parts of charts and edit the chart are all very intuitive and easy to use."
 

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."
"erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge."
"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."
"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."
"I would like the solution to be more user-friendly to deploy."
"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 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."
"The solution's model mark could be better because it crashes sometimes."
"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."
"Lucidchart subset their older components or something like that had happened. I don't entirely know the totality of it, but we were forced to upgrade to a different integration with Lucid than what we had. I've had a lot of frustrations with that because I've lost a lot of diagrams. I can't get them back and I'm getting pop-ups that are showing me that our data will be loading and I can't run four or five years of my engineering diagrams"
"I would like to have access to more colorful and more vibrant icons."
"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."
"In terms of improvement, there can be more templates. There are good templates but there could still be more."
"It can have more colors or graphics. Currently, it is a little boring. It can have a little bit more fun factor."
"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."
"I wish there were a lot more automations. For instance, if I'm using a project management software to list out all my WBS [work breakdown structure] I wish Lucidchart had the functionality where it would take all the numbering and generate a tree diagram. Something like that would help so much, but right now it's still a manual task..."
 

Pricing and Cost Advice

"There are two license options and the pricing is reasonable."
"Though the solution is not cheap, it's worth the money."
"The tool is expensive."
"Pricing is very high compared to any other product."
"The pricing of the solution is cheap. I rate the pricing a five out of ten."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"erwin Data Modeler by Quest is an expensive solution."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"We signed up for the month-to-month and it charged us all at once for the whole year. I believe we signed up for the $7.99 one. I think that was the price."
"I have a subscription as an individual user for one year, and it is not expensive."
"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."
"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."
"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."
"I was using the free version of Lucidchart, which was very helpful."
"The pricing and licensing are fine. It has a lot of features that I prefer over some of the other programs, which is good. Being that it is web-based, I feel that it is acceptable that it's on a monthly pay basis. However, I think I pay on an annual basis, which is fine with me."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
865,295 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Manufacturing Company
9%
Government
8%
Computer Software Company
7%
Financial Services Firm
13%
Computer Software Company
9%
Manufacturing Company
8%
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, MEGA International and others in Enterprise Architecture Management. Updated: August 2025.
865,295 professionals have used our research since 2012.