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."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."
"They have a lot of features and the most up-to-date technology integration, which I haven't seen in other products."
"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."
"It has centralized storage so that a data model can be shared by different teams."
"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"The data lineage feature is very valuable."
"The templates are quite valuable, as is the fact that you can export to PDF, to a Visio document, or as a picture. These are valuable features for me because they give me the ability to make changes in any other product that I'm using. I'm not bound by one platform."
"The interface is easy for a layperson to use and adapt to."
"In general, this product has improved our organization because it makes accessing up-to-date processes and planning a lot easier."
"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 love the simplicity and how clean all the different boxes, arrows, and charts can be. Especially with something complicated like our sales flow, it could be really easy to be all cluttered and everything like that, but my favorite feature is how clean it is, how straightforward it makes our flow look, and how easy it is to understand. Lucidchart accommodates both Mac and PC users which is important to us because at my company right now, our sales floor and then every other computer we have as a company is a Mac, but a lot of our employees actually have PCs and Android as well. So it's really beneficial because if we're ever on the go or we need to make a change, it's versatile and is open for both Mac and PC."
"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."
"The collaboration, hands-down, is the top feature. It is valuable because our company doesn't believe in working in silos... While I may be the one leading the efforts, it's very important that my team gets buy-in on decisions being made when we're designing. It's critical, especially in this virtual environment, when we're not in an office to have a team meeting and able to whiteboard something. Lucidchart is an extremely useful tool for our team."
"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."
"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."
"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing."
"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."
"We can only get licenses through partners."
"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 the reporting capabilities be more dynamic and more inclusive of information. The API is very sparsely understood by people across the user community."
"The solution's reporting side needs to be improved."
"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 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."
"As far as I know, LucidChart can’t be automated with Visual Basic .Net like Visio."
"I've had an issue is when you create, let's say, a rectangle box. You can write some text in it and give it a name, and, depending on how you shape the size of the box, the text will rearrange itself to fit. That is, except if your box is very, very narrow, but very long, like a long, narrow rectangle in a vertical position. In this case, the text will always go out of the rectangle."
"I would like to have more text boxes to write more comments so I can write a small note below a picture. I would like some flexibility."
"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."
"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."
"It might already exist and I haven't used it, but in terms of improvement, I would like a hot-key system for some of the diagrams to auto-generate things a bit quicker to be able to produce charts a lot faster, or have more standard templates that you can just go to if you're trying to generate something quickly."
"The layering is something that can be improved because sometimes, it is confusing for me when I'm trying to get to the layer that I want to edit."
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 SAP Signavio Process Manager.
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.