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

IDERA ER/Studio vs LeanIX comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Nov 3, 2024

Review summaries and opinions

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

Categories and Ranking

IDERA ER/Studio
Ranking in Enterprise Architecture Management
10th
Average Rating
8.4
Reviews Sentiment
7.1
Number of Reviews
36
Ranking in other categories
Database Development and Management (16th)
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 January 2025, in the Enterprise Architecture Management category, the mindshare of IDERA ER/Studio is 4.2%, down from 4.3% compared to the previous year. The mindshare of LeanIX is 15.9%, up from 12.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

Aaron Cutshall - PeerSpot reviewer
Used for data modeling and has a scripting language to write your own scripts
The solution has streamlined our data modeling processes quite a bit. It's a central focus in our data modeling and data cataloging efforts. The tool's reverse engineering capability to bring in existing database structures and create models from them has benefitted our data architecture needs. With the tool's data dictionary capability, we're able to maintain consistency in our models, name use, and actual data domains. The solution's reverse engineering helps with understanding legacy databases. In fact, I've been asked to reverse-engineer several more legacy databases so that we can have them modeled and cataloged. The solution is deployed on the cloud server, but it’s only within our network. The solution has a lot of capabilities. I like the fact that it has a scripting language that allows you to automate and write your own scripts. I think that's been a big bonus for us. I highly recommend the solution because of its capability for logical models, where you can put your business definitions and logic. While less expensive, some other tools can't do that. Overall, I rate the solution an eight out of ten.
Umit Sengul - PeerSpot reviewer
A platform that facilitates efficient IT architecture management and integration, improving organizational coordination and decision-making
LeanIX is primarily used to create and manage architectural models, link capabilities, activities, and products and generate comprehensive reports. It serves as a central platform for overseeing the IT landscape within EON, a large organization, streamlining operations and enhancing governance…

Quotes from Members

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

Pros

"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"I set up this tool and found it to be very simple."
"It's much easier to develop the database structure and change it on the fly, rather than doing it manually in SQL Server itself. That saves time."
"The most important features are logical and physical models that we can compare and develop. Also, the Data Dictionary can be created out of your studio. Finally, database schemas help understand the logic that's behind the scene, behind the SQL tables. Especially when there are a lot of them, the schemas help everyone understand the business processes."
"The data modeling and reverse engineering features are most important to us."
"Modeling with Data Architect: We can quickly reverse-engineer a database from an existing database or create a model from scratch."
"The reverse engineering is the most important feature."
"This application does a lot of things, as do competitor products, but the main reason to go with this product was the ability to create many automations, where we can improve our work and our process."
"I like the tool’s integration and maps."
"The ability to import data and generate reports from it. That's where its power lies."
"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."
"Among the most valuable features are the easy-to-use interface and the ability to get quick results... Many tools that I have seen are great for technical people and for giving technical and business information as well, but they're not as friendly and easy as LeanIX... It works well for both technical and business users. It provides a good combination, enabling you to quickly put valuable information in for both technical and non-technical people and derive results."
"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."
"One of the product's most valuable features is its ability to configure hardware devices."
"My favorite feature of LeanIX is its ability to induct attribute-driven surveys."
"I like LeanIX's ease of use in general."
 

Cons

"It isn't easy to compare the thousands of tables in the model against the database. The tool should improve the synchronization within the large organization"
"Tech support is a sticking point with me. I am really disappointed in the tech support. We pay for the Platinum level. It takes hours to get a response."
"One limitation I have found in ER/Studio is that when you want to make some changes to the table definitions, you have to go item by item. You cannot do it globally. Another issue concerns defining the foreign keys between the different tables. It is a little more tedious in the ER/Studio than in ERrwin. With ERwin it is direct."
"We did have a big issue when we upgraded to the 2016 version. The Team Server portion never did quite install correctly, and/or the database was corrupted, and we never figured it out."
"I'd like the ability to debug the errors ourselves instead of having to call them. There are certain types of errors that, I wouldn't say they come up regularly, but when you have an error it is very often the same type of error. Knowing that it's a Type III or Type I, it would be nice to have some kind of debugging facility for us to use to find out where the problem that threw that error occurs. That would be a really cool feature."
"I would like to see better documentation/help for the Data Architect tool. Creation of tutorials would be nice, as there are some features which are not as clearly defined as they should be."
"What needs the most improvement are semantic lineage and usability."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"LeanIX experiences a lot of server timeouts. Nearly every transaction needs to be done twice due to these issues."
"The initial setup has room for improvement."
"What would make LeanIX better is more variety in terms of reporting, and more flexibility with its data importing feature."
"The solution needs to incorporate a data patch tool that moves within and irons data."
"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 should improve the out of the box connectors that they provide. They should see if clients are really ready to adapt them."
"Does a poor job of being able to allocate detailed costings to components within the network."
"They could include a combination of LeanIX and some modeling extensions."
 

Pricing and Cost Advice

"Pricing is expensive and on the higher-end."
"The product is pricey."
"The price of this product is okay."
"I'm a firm believer that all software is overpriced these days but, comparatively speaking, I think ER/Studio is worth the money."
"On a scale of one to ten, where one is bad and ten is good, I would rate the licensing cost as a seven or eight. It's not too expensive for us."
"I feel the product's pricing is a good value."
"It is priced fairly. It's around the same as erwin and other competitors' costs."
"The process of licensing could be much simpler, from our experience."
"LeanIX uses application-based account licensing, where the cost is multiplied by the number of applications in the software implementation."
"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 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."
"I would rate the pricing a one out of ten, where one is cheap, and ten is expensive."
"The solution's pricing is based on a licensing model that is competitive and in line with other products."
"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."
"The pricing is very good. We definitely get good value for the money."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
831,265 professionals have used our research since 2012.
 

Top Industries

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

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What needs improvement with IDERA ER/Studio?
Since the solution was originally developed in the eighties and nineties and hasn't changed much since then, it could use an overhaul. The solution is not so strong at creating modeling views and d...
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

IDERA ER Studio, ER/Studio, ER/Studio Enterprise Team Edition
No data available
 

Learn More

 

Overview

 

Sample Customers

Newmont Mining, Entrust, Accolade, TalkTalk, Catalina, Protective Life, NTT Data, dir systèmes, Microsoft; American Express, Astellas Pharma, AstraZeneca, Coriant, Fedex, GlaxoSmithKline, PepsiCo, Prudential, Wells Fargo
adidas, Bosch, Chico's, Haworth, Helvetia, KuKa, Osram, Telekom, TUI, Santander, Swarovski, Vaillant, 7Eleven, and Zalando.
Find out what your peers are saying about IDERA ER/Studio vs. LeanIX and other solutions. Updated: January 2025.
831,265 professionals have used our research since 2012.