Lucidchart vs erwin Data Modeler by Quest comparison

erwin Data Modeler by Quest

Read 38 erwin Data Modeler by Quest reviews

5,748 Views
3,046 Comparison Views

95% willing to recommend

Lucidchart

Read 54 Lucidchart reviews

1,273 Views
1,054 Comparison Views

94% willing to recommend

erwin Data Modeler by Quest

Lucidchart

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between erwin Data Modeler by Quest and Lucidchart based on real PeerSpot user reviews.

Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management.

To learn more, read our detailed Enterprise Architecture Management Report (Updated: June 2024).

Buyer's Guide

Enterprise Architecture Management

June 2024

Download the complete report

Helped 793,295 peers since 2012

Categories and Ranking

erwin Data Modeler by Quest

Average Rating

8.6

Number of Reviews

Ranking in other categories

Enterprise Architecture Management (3rd), Database Design (1st), Business Process Design (9th)

Lucidchart

Average Rating

8.6

Number of Reviews

Ranking in other categories

Mind Mapping Software (2nd), Visual Collaboration Platforms (3rd)

Mindshare comparison

As of July 2024, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 10.8%, up from 8.6% compared to the previous year. The mindshare of Lucidchart is 9.5%, up from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Enterprise Architecture Management

Unique Categories:

Business Process Design

2.7%

Mind Mapping Software

33.8%

Visual Collaboration Platforms

16.5%

Featured Reviews

Denise Smallwood

Data Architect at a real estate/law firm with 1,001-5,000 employees

Jul 26, 2023

A tool that you can use in multiple environment and creates data dictionaries

I use erwin Data Modeler for a metadata project. I don't have thousands of tables to manage or a data warehouse or anything erwin Data Modeler helps us reverse engineer and keep track of data before converting from one tool to another. erwin allows us to track data and share it with business…

Read full review

Roseann Joy Braley

Project Manager at Freelancer

Jan 17, 2023

The ease of use, clarity, and different functionalities make this one incredibly useful tool

You don't need to have a Lucidchart account or license in order to view a sheet if you're just a viewer. However, I found it frustrating when non-license holders created their accounts, which should only consist of creating a username and password, the setup process lead them to believe that they needed to give their credit card numbers to proceed. I have at least two colleagues who did put in their credit card information and then they forget to cancel the subscription, and they ended up getting charged for a license that they don't use. To me, the confusing setup for non-license holders is a barrier to entry. If you want new people to see this tool, the process shouldn't be that confusing to view a sheet for non-users. But as a user myself, it truly is perfect. For non-users, this is a pain point.

Read full review

Quotes from Members

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

Pros

"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."

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

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

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

"The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."

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

"The solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."

"Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera."

More erwin Data Modeler by Quest pros

"The ability for Lucidchart to create database schemas or modify existing data structures is strong. That's what I initially introduced it for in our organization. The script that Lucidchart provides works with other systems like Oracle, SQL Server, and Postgres that I can copy-paste, and get a quick dump of metadata and import into has saved me a ton of steps that I didn't have to manually create these tables. I had a lot of things where I still had to put in the linkages between tables, but I didn't have to type in every field name, every data type, and everything else that came in. That saved me tons of time."

"I love the fact that you can just integrate a drawing into Google Slides. I build a lot of visuals in Lucidchart, and then, rather than sharing them directly from Lucidchart, I just build Google Slides decks for senior management, and I link the Lucidchart on the cloud version to a slide image. That makes it easy. This way, I can build in one tool and show in another."

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

"Lucidchart is a lovely tool for creating visual representations of any process or organization."

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

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

"Easy to work on."

More Lucidchart pros

Cons

"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 would like to see the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."

"The erwin Data Modeler is quite complex to use."

"It does not have a cloud application."

"The only real complaint I have is the time it takes to do a database comparison on a large model. If they could speed that up, that would be the only thing I can think of that needs improvement."

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

"erwin is not as robust as a data warehousing project I've been on in the past."

More erwin Data Modeler by Quest cons

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

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

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

"I would like to have access to more colorful and more vibrant icons."

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

"The main improvement I would like to see is for them to improve the help section on the flow charts or on the formatting."

"One area for improvement is the fact that I had to create two sheets. I had to create a process flow diagram, and I had to create a timeline. I wasn't able to do that in one sheet. If they could add that kind of feature, where you could input a timeline and different types of templates into one worksheet, that would be really useful. I had to include two and then cut and paste, and that was an extra step for me."

"Although it comes with a lot of pre-existing tools, it would help if it had some more design templates. By now, they must know what kinds of things people are trying out, and that should help them create more templates. I would also like to see a little more automation."

More Lucidchart cons

Pricing and Cost Advice

"erwin Data Modeler by Quest is an expensive solution."

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

"Though the solution is not cheap, it's worth the money."

"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."

"Likewise, the solution is a little pricey."

"There are two license options and the pricing is reasonable."

"The solution is expensive."

"The price of erwin Data Modeler is very expensive, in particular for this part of the world."

More erwin Data Modeler by Quest pricing and cost advice

"Pricing-wise, it is pretty fair. I don't really know what group pricing looks like, but right now, I pay $10 a month for my Lucid subscription. One thing I would say is that I do worry about my bosses being okay with paying $10 a month for every single employee because we would have around 20 people. It makes me a little nervous about whether they are going to pay $200 a month for people to be able to use this software. At the same time, from where I'm sitting, it's totally worth it. We save a thousand dollars from using this software. It's still a no-brainer."

"Its pricing is very affordable and reasonable for the features that it provides. I am using its basic plan, and for my usage, it is perfectly reasonable. It suits perfectly."

"The price and licensing are good."

"At €167 per user per year, the pricing is slightly higher than Visio, but it's worth it."

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

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

"The pricing is very reasonable, and they have a free trial available that you can play with."

More Lucidchart pricing and cost advice

See which vendors are best for you

Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.

See recommendations

793,295 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

20%

Government

Computer Software Company

Manufacturing Company

Financial Services Firm

14%

Computer Software Company

12%

Manufacturing Company

Government

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.

See all answers

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.

See all answers

What needs improvement with erwin Data Modeler by Quest?

The solution's model mark could be better because it crashes sometimes.

See all answers

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

See all answers

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

See all answers

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

See all answers

Comparisons

SAP PowerDesigner vs erwin Data Modeler by Quest

Compared 28% of the time

IDERA ER/Studio vs erwin Data Modeler by Quest

Compared 16% of the time

Visio vs erwin Data Modeler by Quest

Compared 12% of the time

Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest

Compared 8% of the time

AWS Well-Architected Tool vs erwin Data Modeler by Quest

Compared 5% of the time

More erwin Data Modeler by Quest Competitors

Lucidspark vs Lucidchart

Compared 15% of the time

Figma vs Lucidchart

Compared 14% of the time

Sparx Systems Enterprise Architect vs Lucidchart

Compared 12% of the time

Visual Paradigm vs Lucidchart

Compared 9% of the time

SAP Signavio Process Manager vs Lucidchart

Compared 5% of the time

More Lucidchart Competitors

Product Reports

Buyer's Guide

erwin Data Modeler by Quest

July 2024

Download erwin Data Modeler by Quest product report

Buyer's Guide

Lucidchart

July 2024

Download Lucidchart product report

Also Known As

erwin DM

No data available

Learn More

erwin by Quest

Lucid Software

Overview

erwin pioneered data modeling, and erwin Data Modeler (erwin DM) remains trusted, award-winning software for data modeling and database design, automating complex and time-consuming tasks. Use it to discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives – all while supporting data governance and intelligence efforts.

Our online diagram application makes it easy to sketch and share professional flowchart diagrams. From brainstorming to project management, we support all of your communication needs. That’s why millions of users choose Lucidchart.

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

Buyer's Guide

Enterprise Architecture Management

June 2024

Download Free Report

Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: June 2024.

DOWNLOAD NOW

793,295 professionals have used our research since 2012.

We monitor all Enterprise Architecture Management reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.