Try our new research platform with insights from 80,000+ expert users

LeanIX vs erwin Data Modeler by Quest comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024
 

Categories and Ranking

erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Average Rating
8.6
Reviews Sentiment
6.5
Number of Reviews
38
Ranking in other categories
Business Process Design (9th)
LeanIX
Ranking in Enterprise Architecture Management
1st
Average Rating
8.4
Reviews Sentiment
7.4
Number of Reviews
21
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of December 2024, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 11.0%, up from 10.0% compared to the previous year. The mindshare of LeanIX is 15.9%, up from 12.0% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

JorgeSanz - PeerSpot reviewer
Streamline data modeling and automate network changes for increased efficiency
The initial setup depends on the tool if you are using the data model environment. Stopping the server could be complex and require strong expertise. If you have everything set up and configured, Erwin is straightforward. You can deploy it in a few hours. In our case, it took a couple of months to address internal conditions, assign machines, and set up everything for the services. I rate the initial setup a six out of ten, where one is difficult and ten is easy.
NickGenoese - PeerSpot reviewer
Streamlines the process of identifying apps nearing end-of-life or requiring retirement and facilitates informed decisions about app retention
When we input our inventory and components, it tells us which ones are nearing end-of-life, deprecated, or obsolete. It also categorizes them. We've added flags, essentially tags, to mark certain things as non-strategic technologies. Using LeanIX, we made conscious decisions about which technologies are strategic and which aren't. This allows us to generate reports highlighting applications written in non-strategic technologies, giving us a better picture of our inventory size and what needs to migrate to the cloud or our target technology. So, it's about understanding what we have, seeing how it aligns with our strategic direction, and then driving the movement towards that direction.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Drag-and-drop data modeling and reverse engineering out of databases are the most valuable features of erwin Data Modeler by Quest."
"The most valuable features are the ability to reverse engineer and do model comparison. With the reverse engineering, I can understand the databases from third-party products. With the model comparison, I can track the differences between two versions of the same database."
"We had some data integration projects, where we needed to integrate it for about 100 databases. Doing that manually is crazy; we can't do that. With erwin, it was much easier to identify which tables and columns could be used for the integration. That means a lot in terms of time and effort as well as my image to the customer, because they can see that we are providing value in a very short time."
"The generation of DDL saved us having to write the steps by hand. You still had to go in and make some minor modifications to make it deployable to the database system. However, for the data lineage, it is very valuable for tracing our use of data, especially personal confidential data through different systems."
"The product lets us import different types of models from various databases."
"The fitting model is very intuitive."
"It provides flexibility with the code. You can change the code as you want. Basically, you can change SQL based on what's best for your project."
"It's important to create standard templates — Erwin is good at that — and you can customize them. You can create a standard template so that your models have the same look and feel. And then, anyone using the tool is using the same font and the same general layout. erwin's very good at helping enforce that."
"I like the tool’s integration and maps."
"The solution provides a single window view of business, application, data, and technology views of the IT ecosystem."
"My favorite feature of LeanIX is its ability to induct attribute-driven surveys."
"For the reporting capabilities, LeanIX provides dashboards for different levels, including CXO dashboards. There are plenty of dashboards for reporting."
"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."
"I can develop a report and then do a presentation, or develop a report and some other diagrams and then put them all in one presentation, and from there, I can present things directly, so there is no need to move images."
"The most valuable features are the clean user interface and the fact sheet feature in Application Portfolio Management. The tool integrates well with ServiceNow, which is the usual CMDB platform."
"LeanIX has a great application information architecture."
 

Cons

"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."
"erwin is not as robust as a data warehousing project I've been on in the past."
"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 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."
"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."
"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."
"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."
"What would make LeanIX better is more variety in terms of reporting, and more flexibility with its data importing feature."
"It's hard to predict the pricing of the system."
"LeanIX should improve its support services."
"The whole integration architecture view of interfaces/data exchange could be improved."
"The initial setup has room for improvement."
"The modeling could be improved."
"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."
"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."
 

Pricing and Cost Advice

"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."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"erwin is expensive compared to other solutions. We are paying almost $6,000 per seat a month."
"erwin Data Modeler by Quest is an expensive solution."
"The tool is expensive."
"The price of erwin Data Modeler is very expensive, in particular for this part of the world."
"Likewise, the solution is a little pricey."
"There are no costs in addition to the standard licensing fees."
"The pricing is very good. We definitely get good value for the money."
"The tool needs to include more flexible licensing options. We do not use the tool all the time. So pricing should be considered only when we use the tool."
"The solution's pricing is based on a licensing model that is competitive and in line with other products."
"I would rate the pricing a one out of ten, where one is cheap, and ten is expensive."
"It cost me $91,000 a year for 300 applications. For any enterprise, 300 applications are minimal, as many have well over 1,000 applications."
"As the tool is cloud-based, its cost is more affordable."
"There is a sweet spot of where they need to be on pricing right now. They could go up a little bit in pricing, but it has to do with the cost savings, and it has to do with the practitioners using it. I use it where I get cost savings and I can justify it, but they probably have the ability to flex a 10% up channel on their sales on that. So, they could increase their settle price, not their offering price, when they sell. They can probably hold that up a little bit higher than it is because there are cost savings that we can drive from it."
"LeanIX uses application-based account licensing, where the cost is multiplied by the number of applications in the software implementation."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
824,067 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
9%
Government
9%
Computer Software Company
8%
Financial Services Firm
13%
Computer Software Company
11%
Manufacturing Company
11%
Insurance Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What is your experience regarding pricing and costs for erwin Data Modeler by Quest?
The product is expensive. I rate the product’s pricing a nine out of ten, where one is cheap and ten is expensive.
What needs improvement with erwin Data Modeler by Quest?
The solution's model mark could be better because it crashes sometimes.
Any experience with Strategic Project Portfolio Management Solutions?
Hi @Cheryl Joseph ​Looking at the crossover between Project and Portfolio management with EA, then Planview could be a good choice. If looking at Portfolio Management from an EA perspective then Le...
What do you like most about LeanIX?
The ability to import data and generate reports from it. That's where its power lies.
What is your experience regarding pricing and costs for LeanIX?
LeanIX is associated with high costs. It cost me $91,000 a year for 300 applications. For any enterprise, 300 applications are minimal, as many have well over 1,000 applications. The first pricing ...
 

Also Known As

erwin DM
No data available
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
adidas, Bosch, Chico's, Haworth, Helvetia, KuKa, Osram, Telekom, TUI, Santander, Swarovski, Vaillant, 7Eleven, and Zalando.
Find out what your peers are saying about LeanIX vs. erwin Data Modeler by Quest and other solutions. Updated: December 2024.
824,067 professionals have used our research since 2012.