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
 

Categories and Ranking

erwin Data Modeler by Quest
Average Rating
8.6
Reviews Sentiment
6.5
Number of Reviews
38
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 11.0%, up 10.0% compared to last year.
Lucidchart, on the other hand, focuses on Mind Mapping Software, holds 22.3% mindshare, up 20.3% 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

"It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"It reduces monthly savings by hundreds of thousands of dollars. Think about a company like Costco and all of the points of sale systems in Costco, all of the systems, the applications, but if all the applications in Costco all had their own data model, trying to integrate those, upgrade them and manage their different versions of the same model throughout the store, is an absolute nightmare. It's phenomenally expensive. This helps reduce that cost significantly. I'm talking on the orders of hundreds of thousands of dollars."
"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."
"The principal feature that I liked is that the solution has a very graphic interface."
"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."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"There is absolutely no problem with the stability."
"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."
"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."
"Easy to work on."
"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."
"We are using Lucidchart a lot for documenting things, such as processes, systems, new teams, etc. Its ability to document processes is great. Some of the major pluses are the sheer number of templates and the flexibility in the types of things that you can document. This is a benefit because we are able to structure it in whatever format we want. So, we can take a template that maybe was designed for something different and not have to create it from scratch. We just modify it for our purposes."
"The ease of creating some of the maps and diagrams is most valuable. Lucidchart is just simpler and works more intuitively than other solutions that I have used in the past, such as Microsoft Visio. I am not in a creative role, but I know how to use Adobe Illustrator and other solutions like that. If I need to map out something that I've never mapped out before, and it is going to need a totally custom graphic, eight times out of 10, I'm going to go to Lucidchart rather than trying to build it in Illustrator. Its intuition and flexibility are really big features for me."
"It is important that Lucidchart accommodates both Mac and PC users because if you support Mac, that means you also support the mobile applications on the iPad... Some of the other employees have access to an iPad, but not all of them do. When we're trying to talk through a process with them on-the-fly, or at the point of occurrence, it's so much nicer if we can both have it up on the iPad. That's why I would say the Mac support is essential."
"The interface is easy for a layperson to use and adapt to."
 

Cons

"We can only get licenses through partners."
"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."
"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."
"I would like to see more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata."
"erwin is not as robust as a data warehousing project I've been on in the past."
"Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model."
"It does not have a cloud application."
"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."
"I don't know if I will be able to add some animations if I want to. I believe the problem may be the program's process flows but if I want to transfer it into a PPP or any other document, I can only do image transfer."
"The UML diagram that it gave me initially was a huge flow with a bunch of UML tables, and I wasn't going to need that many. If it was a more simple linkage between the tables then it would be easier to finish projects, instead of having to select unnecessary tables and delete them."
"I would like to have access to more colorful and more vibrant icons."
"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."
"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."
"I would really like to be able to set default appearance settings for new documents because I have a set of appearance settings that I always use. I end up setting that manually every time. There may be a way to do that, and maybe I am not able to find it. This is my only major point of feedback for improvement. There are other little nitpicky things, such as being able to lock layers without them looking like a big red line around them would be nice, but every graphic design software does that, so I understand why they have that. All my concerns are nitpicks. They're not big."
"A couple of times when I tried to move a line, connecting two shapes on an organizational chart, occasionally the line doesn't move as intuitively as I think it should. I have to fiddle around with it a few times to get it to do what I want it to do."
"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."
 

Pricing and Cost Advice

"It is not a very expensive solution. Only the licensing and maintenance fee needs to be paid."
"Though the solution is not cheap, it's worth the money."
"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"Likewise, the solution is a little pricey."
"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."
"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."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"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."
"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 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."
"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."
"Lucidchart's pricing model is not excessive, as compared to similar products. It is pretty much in line with everyone else."
"The licensing is pretty cost-effective but I haven't considered it on an enterprise level."
"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 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.
823,875 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
9%
Government
9%
Computer Software Company
8%
Financial Services Firm
14%
Computer Software Company
11%
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?
The solution's model mark could be better because it crashes sometimes.
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...
Can we use a product like Lucidchart for "personal" use?
Absolutely! Lucidchart is a clever tool that is fit for purpose for whatever activity you would like - whether it's your thoughts or processes. There is a well-populated library of well-designed te...
 

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: December 2024.
823,875 professionals have used our research since 2012.