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."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."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"The fitting model is very intuitive."
"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."
"I have worked with erwin Data Modeler for quite some time and familiarity is its most valuable feature."
"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 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 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."
"I like how all the contacts in my chart are linked to LinkedIn. That's what makes it really easy for outreach and for making sure we have all the contacts right there in front of us when we need to."
"The interface is easy for a layperson to use and adapt to."
"Creating flowcharts and documentation is easy to do and the results are very nice."
"Easy to work on."
"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 most valuable features are the different templates that they have already created, as well as all the different shapes you can use in the process charts because each shape stands for a different element or thing that's being done. It's easy to distinguish between different steps using the already set-out shapes."
"It's very easy to use. I didn't go through any tutorials or any documentation. It was very easy for me to start. It is intuitive. Right after logging in, I was able to quickly just drag and drop and do the things I wanted to do, without any prior knowledge of the solution."
"Using Lucidchart for documenting processes is great. The elements are ready to use and it is quick to do."
"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 like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"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."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"I would like the solution to be more user-friendly to deploy."
"We can only get licenses through partners."
"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."
"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."
"It can have more colors or graphics. Currently, it is a little boring. It can have a little bit more fun factor."
"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."
"This might already be a feature, but I remember sometimes when we're just all viewing, if you accidentally click, then there's an arrow that pops up, and you have to go back and delete it. A lot of times there are accidental arrows being drawn when really we're just trying to present to each other."
"The flowcharting feature would be improved if it had some kind of prediction capability that helped to create the diagrams, such as the ability to automatically join components with my database."
"One of the issues has been that, as far as I understand, even to view it, the other person needs a Lucidchart account unless you send them a PDF. That's been a bit of an issue because some people in our organization don't have Lucidchart accounts, only certain people have logins. If we just want to collect comments from people, that's been a bit complicated."
"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."
"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."
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.