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
 

Categories and Ranking

IDERA ER/Studio
Ranking in Enterprise Architecture Management
9th
Average Rating
8.4
Number of Reviews
35
Ranking in other categories
Database Development and Management (15th)
LeanIX
Ranking in Enterprise Architecture Management
1st
Average Rating
8.6
Number of Reviews
20
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of November 2024, in the Enterprise Architecture Management category, the mindshare of IDERA ER/Studio is 4.1%, down from 4.4% compared to the previous year. The mindshare of LeanIX is 15.9%, up from 11.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
 

Featured Reviews

Aaron Cutshall - PeerSpot reviewer
Jun 17, 2024
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.
NickGenoese - PeerSpot reviewer
Jan 3, 2024
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

"The tool is simple to use."
"We found a lot of duplication, a lot of non-conformity in the way our databases were designed. By identifying these situations, we're able to go back in and try to create a more standardized solution."
"IDERA keeps up with the versions of Oracle and SQL Server that I'm using. I mostly use SQL Server and when there are new features, a new type of index, for example, IDERA also includes them in upgrades of the data modeling tool."
"The most valuable feature of the solution is generating DDL (data definition language)."
"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."
"We are able to document the data lineage and data flows of our data from one system to another."
"One of the valuable features is inheritance when joining tables. When setting up RI and domains and rules, ER/Studio does a lot of the grunt, boilerplate code that would otherwise have to be hand-coded."
"We've been able to develop some nice looking reports, and the dashboard's capability to map is very easy compared to Enterprise Architect."
"The most valuable features are that it's user-friendly and the user experience. It's easy to map the fact sheets."
"The solution has a very useful assessment tool that automatically populates from input data to produce a detailed analysis of customer's environments."
"It offers neat visualization and referencing functionality while enabling the creation of landscape maps and showing the relationship between different applications."
"For the reporting capabilities, LeanIX provides dashboards for different levels, including CXO dashboards. There are plenty of dashboards for reporting."
"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."
"LeanIX has a great application information architecture."
 

Cons

"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."
"The only thing I had an issue with was licensing, and the support was very good."
"Whenever there is a new version, there are a lot of release notes on the technical side of it, but I would like to be told why are we doing the upgrade... What I would like to really see is how this benefits us from the business point of view. What are the real benefits that the user gets? I want some kind of way white paper. The release notes describe the technical enhancements but, from the layman's point of view, if someone asks me what are the business benefits of this upgrade, I don't have any documentation to explain it to the business."
"Sometimes our version is a little unstable. But I think this problem occurs because our version is old."
"The solution is not so strong at creating modeling views and database views."
"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."
"The screens are a bit outdated. They could use a new look and feel."
"They're probably positioned pretty well. I hope that they would not focus that much on the business architecture, and they would focus more on the overall cloud strategy and how we can leverage multi-cloud and transition back and forth from other cloud providers. With a lot of current vendors, you get locked in with one cloud, and then you try to migrate to someone else, and it becomes very problematic. What they need to do is to look at the overall data strategy, and they probably need to amplify their data strategy, especially around multi-cloud."
"It's hard to predict the pricing of the system."
"Another area for improvement is that when you're starting to look into more advanced information, using the solution's APIs and its customizations, documentation for that specific aspect is not very good. There is not too much support built into the offering for that aspect, for a developer."
"Improvements in user interface simplicity could be made, particularly with the reporting and filtering capabilities."
"They should improve the out of the box connectors that they provide. They should see if clients are really ready to adapt them."
"The solution uses Gartner's time-based framework for application rationalization. One more thing that you can consider is having some add-on frameworks for the same, not just Gartner."
"The modeling could be improved."
"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."
 

Pricing and Cost Advice

"The price of this product is okay."
"The solution’s pricing is high."
"I feel the product's pricing is a good value."
"Pricing is expensive and on the higher-end."
"The product is pricey."
"The process of licensing could be much simpler, from our experience."
"It is priced fairly. It's around the same as erwin and other competitors' costs."
"Pricing is on point, but do your due diligence - not every developer needs the tool."
"As the tool is cloud-based, its cost is more affordable."
"The pricing is very good. We definitely get good value for the money."
"LeanIX uses application-based account licensing, where the cost is multiplied by the number of applications in the software implementation."
"I would rate the pricing a one out of ten, where one is cheap, and ten is expensive."
"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."
"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."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
814,649 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
22%
Computer Software Company
11%
Government
9%
Manufacturing 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 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 uses application-based account licensing, where the cost is multiplied by the number of applications in the software implementation. Essential Docker offers unlimited users and limited appli...
 

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: October 2024.
814,649 professionals have used our research since 2012.