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 solution is good for organizing the data and the scripting part is very powerful. It's easy to create technical scripts for models."
"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 allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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."
"What has been useful, I have been able to reverse engineer our existing data models to document explicitly referential integrity relationships, primary/foreign keys in the model, and create ERDs that are subject area-based which our clients can use when working with our databases. The reality is that our databases are not explicitly documented in the DDL with primary/foreign key relationships. You can't look at the DDL and explicitly understand the primary/foreign key relationships that exist between our tables, so the referential integrity is not easily understood. erwin has allowed me to explicitly document that and create ERDs. This has made it easier for our clients to consume our databases for their own purposes."
"We can create mappings in erwin and possibly data dictionaries."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"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."
"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."
"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."
"The most valuable feature is the ease of use, and just being able to drag and drop."
"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 ability to have more than one person editing at the same time is the most valuable feature. You can have one diagram and have multiple users on it at the same time. We haven't been able to do that on other software. So that's the main reason we moved to Lucidchart."
"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."
"Lucidchart enables me to put down on paper what I was visualizing in my head. It makes it more shareable than only using words."
"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 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."
"We are planning to move, in 2021, into their server version, where multiple data modelers can work at the same time and share their models. It has become a pain point to merge the models from individual desktops and get them into a single data model, when multiple data modelers are working on a particular project. It becomes a nightmare for the senior data modeler to bring them together, especially when it comes to recreating them when you want to merge them."
"I would like the solution to be less rigid in terms of its theory."
"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 is not a very stable solution. I rate the stability five out of ten."
"There is a lack of local support in the China region."
"This is a very complex product."
"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."
"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."
"When you want to add text to a connector arrow, I have not figured out how to position the text vertically. It always wants the text to stay horizontal."
"In terms of improvement, there can be more templates. There are good templates but there could still be more."
"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."
"It would be helpful if there were different options available for organizing the folders, such as having a high-level display with pictures."
"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."
"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."
"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."
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.