Lucidchart vs erwin Data Modeler by Quest comparison

Cancel
You must select at least 2 products to compare!
erwin by Quest  Logo
6,311 views|3,313 comparisons
94% willing to recommend
Lucid Software Logo
1,313 views|1,099 comparisons
94% willing to recommend
Comparison Buyer's Guide
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: May 2024).
771,212 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products.""Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed.""I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature.""The fitting model is very intuitive.""We can create mappings in erwin and possibly data dictionaries.""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 principal feature that I liked is that the solution has a very graphic interface.""The data lineage feature is very valuable."

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.""The interface is very good and easy to use. We don't need documentation on how to use it. It is self-explanatory, which is very convenient for a new user.""The wireframe and mock-up features have been the most useful so far. It's easy to create the mock-ups and then communicate to our development team what they need to look like. Lucidchart's capabilities for visualizing and understanding process flows or workflows is very good as well. I'm able to easily use any style of box that I need to create on a flowchart, to effectively communicate to our development team.""The interface is really good and it is very easy to use.""I like the panel on the left of the screen that has all of the shapes that are available to use in the charts. It's easy to use because you can just drag and drop.""The interface is very user-friendly and it is not a hassle to use the site at all. They did a really good job in that regard.""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.""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."

More Lucidchart Pros →

Cons
"The erwin Data Modeler is quite complex to use.""I would like the solution to be less rigid in terms of its theory.""The solution's reporting side needs to be improved.""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.""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 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.""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.""I would like to have more data sources from other, different vendors. In recent years, the vendor has reduced the number of data sources, and I would like to have more data sources for every brand. For example, with Oracle, I would like to have compatibility for many versions, including old ones, not just the most recent."

More erwin Data Modeler by Quest Cons →

"They should continue to bring in more shapes. For example, I saw something cool the other day that was a timeline and in between each step, there was a circle. I thought that that was very clean and that's something that I could see myself using. Lucidchart could come up with more visualizations. I'm not a designer so I would like to have more visuals. That would make my job easier because it would make my job much more professional looking but without having to be a designer myself.""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.""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.""If you're trying to expand a comments box that is sitting on top of the chart, it automatically defaults to assuming you're trying to connect it to the next step in the process, when all you're trying to do is make the box bigger. It automatically goes to the arrow, but I just want to resize the box. That gets a little cumbersome because it does it every single time. It's not just a bug.""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.""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""The communication with sales has been pretty poor. They have been spotty in terms of response. So far, that has been our problem with it. We were in contact with one of their representatives, but he just kind of disappeared one day and we couldn't find him anymore. He has not been responsive to email.""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
  • "The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
  • "This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
  • "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 price should be lower in order to be on the same level as its competitors."
  • "I wish it wasn't so expensive. I would love to personally buy a copy of my own and have it at home, because the next job that I'm looking at is probably project management and I might not have access to the tool. I would like to keep my ability to use the tool. Therefore, they should probably have a pricing for people like me who want to just use the solution as an independent consultant, trying to get started. $3,000 is a big hit."
  • "There are no costs in addition to the standard licensing fees."
  • "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 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 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 pricing and licensing are fine, though I wish they didn't require you to buy the licenses in batches of five."
  • "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'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."
  • "We chose Lucid based on the price comparison between it and draw.io... Lucidchart was about 15 percent cheaper per user... I was surprised to learn that it came with a separate subscription model and was not included in my existing Lucidchart subscription."
  • "The pricing is very reasonable, and they have a free trial available that you can play with."
  • "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."
  • "I have a subscription as an individual user for one year, and it is not expensive."
  • More Lucidchart Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
    771,212 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
    Top Answer:The solution's model mark could be better because it crashes sometimes.
    Top Answer: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… more »
    Top Answer: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… more »
    Top Answer: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… more »
    Ranking
    Views
    6,311
    Comparisons
    3,313
    Reviews
    11
    Average Words per Review
    432
    Rating
    7.9
    2nd
    Views
    1,313
    Comparisons
    1,099
    Reviews
    3
    Average Words per Review
    963
    Rating
    10.0
    Comparisons
    Also Known As
    erwin DM
    Learn More
    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
    Top Industries
    REVIEWERS
    Financial Services Firm28%
    Insurance Company21%
    Government14%
    Energy/Utilities Company7%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Government10%
    Computer Software Company9%
    Manufacturing Company8%
    REVIEWERS
    Computer Software Company18%
    Manufacturing Company11%
    Wellness & Fitness Company8%
    Financial Services Firm8%
    VISITORS READING REVIEWS
    Financial Services Firm13%
    Computer Software Company12%
    Manufacturing Company8%
    Government6%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise7%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise10%
    Large Enterprise73%
    REVIEWERS
    Small Business41%
    Midsize Enterprise25%
    Large Enterprise34%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise12%
    Large Enterprise67%
    Buyer's Guide
    Enterprise Architecture Management
    May 2024
    Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management. Updated: May 2024.
    771,212 professionals have used our research since 2012.

    erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while Lucidchart is ranked 2nd in Mind Mapping Software with 54 reviews. erwin Data Modeler by Quest is rated 8.6, while Lucidchart is rated 8.6. The top reviewer of erwin Data Modeler by Quest writes "The product lets users import different types of models, but it is expensive, and the interface must be improved". On the other hand, the top reviewer of Lucidchart writes "Good brainstorming features, facilitates collaboration, and keeps us focused on our work". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Sparx Systems Enterprise Architect and AWS Well-Architected Tool, whereas Lucidchart is most compared with Lucidspark, Figma, Sparx Systems Enterprise Architect, Visio and IBM Blueworks Live.

    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.