We performed a comparison between erwin Data Modeler by Quest and LeanIX based on real PeerSpot user reviews.
Find out in this report how the two Enterprise Architecture Management solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"The product lets us import different types of models from various databases."
"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."
"We can create mappings in erwin and possibly data dictionaries."
"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."
"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"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 most valuable feature would be application portfolio management, which is where they came from, but over time, they have got artificial intelligence. They built up a very good repository. If I identify a system by name, from historical information, oftentimes, they can tell me that this is deployed with this number of CPUs and they can give me a really good profile of the application for me to put it into a change management database with very little effort."
"LeanIX has good usability and stability. This SaaS is intuitive, easy to use, and comes with a nice reporting feature."
"I like LeanIX's ease of use in general."
"We've been able to develop some nice looking reports, and the dashboard's capability to map is very easy compared to Enterprise Architect."
"Interfaces well with downstream systems of data."
"Ease of use is the most valuable feature. From an enterprise architecture perspective, it's not too cumbersome with too many functionalities, yet it has a lot of attributes for the content it covers."
"The ability to import data and generate reports from it. That's where its power lies."
"The usability is very high. It almost looks like a Facebook for Enterprise architecture, it's pretty nice. It's HTML5 based. The repository is very easy. It has 10 different ways of sorting the objects you have in your architecture repository. Maintaining new data or to add data to your repository is very easy."
"This is a very complex product."
"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."
"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'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"Although Quest Software has made tremendous strides in recent years, they need to evolve more in the big data arena; erwin Data Modeler could use a little more work when it comes to big database designs."
"We can only get licenses through partners."
"There is a lack of local support in the China region."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
"It's hard to predict the pricing of the system."
"It would be beneficial to have additional features and capabilities to enhance mapping between applications, especially across domains where the relationships may not be direct."
"Report generation could be more detailed. There are some shortcomings when creating reports. We can't create tag-based reports or go beyond basic technical reports."
"They should improve the out of the box connectors that they provide. They should see if clients are really ready to adapt them."
"I find LeanIX's pricing expensive for the functionality it offers. However, with the acquisition by SAP, the pricing might become more affordable due to scale and tiered application pricing. Currently, it offers different tiers for the first 400 applications: 400 to 600 and 600 to 1,000, making it expensive from a pricing standpoint."
"LeanIX has limited in-build diagramming capabilities, requiring the purchase of another tool. That is the main drawback of LeanIX because they don't have a built-in add-on product for diagramming."
"They could include a combination of LeanIX and some modeling extensions."
"The solution needs to incorporate a data patch tool that moves within and irons data."
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while LeanIX is ranked 1st in Enterprise Architecture Management with 18 reviews. erwin Data Modeler by Quest is rated 8.6, while LeanIX 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 LeanIX writes "Streamlines the process of identifying apps nearing end-of-life or requiring retirement and facilitates informed decisions about app retention". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Lucidchart, Visio and Visual Paradigm, whereas LeanIX is most compared with ServiceNow, Sparx Systems Enterprise Architect, MEGA HOPEX, ADOIT and erwin Evolve by Quest. See our LeanIX vs. erwin Data Modeler by Quest report.
See our list of best Enterprise Architecture Management vendors.
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.