We performed a comparison between IDERA ER/Studio 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."We have a database design group of about 15 people. The Repository enables multiple people to work on the same model at the same time. We have fully integrated models, so we have one model for the enterprise data warehouse, one model for MDM, with a lot of sub-models in these things. People work on different parts of the model at different times. So the repository enables us to share the models, and keep track of what everybody is working on."
"Developing new dimensional models; for the data we're hosting, dimensional modeling is more useful."
"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."
"We can track changes to our data models and tie those changes back to specific tasks or efforts that we identify."
"When validating the model, the ability to provide sub-models to developers, and generate a physical model from the logical, makes it easier to review a logical model with stakeholders."
"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."
"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."
"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."
"The solution has a very useful assessment tool that automatically populates from input data to produce a detailed analysis of customer's environments."
"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."
"We've been able to develop some nice looking reports, and the dashboard's capability to map is very easy compared to Enterprise Architect."
"I like LeanIX's ease of use in general."
"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."
"The most valuable features are that it's user-friendly and the user experience. It's easy to map the fact sheets."
"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."
"The ability to import data and generate reports from it. That's where its power lies."
"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."
"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"
"The solution's reporting could be improved because the report writer is terrible."
"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."
"What I would like to see improved is the reliability of the releases, releases that are a little less buggy."
"The solution could be sped up, as it is a little slow (e.g., when it's doing its database compare)."
"The visual presentation is a little too colorful and seems that it is dumbed down."
"when there are some links to the external databases, if this database is not structured it is not uploaded. It gives me errors and I cannot see the view that was created on this structure and I cannot change those views, even manually. It skips the views. I have to ignore those views. I cannot re-upload them because it gives me an error."
"What would make LeanIX better is more variety in terms of reporting, and more flexibility with its data importing feature."
"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."
"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."
"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."
"They should improve the out of the box connectors that they provide. They should see if clients are really ready to adapt them."
"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."
"The solution needs to incorporate a data patch tool that moves within and irons data."
"Not a ten because you always have that gap between complexity and easy to use. And the more complex the tool becomes, the more difficult it is to get the usability."
IDERA ER/Studio is ranked 10th in Enterprise Architecture Management with 34 reviews while LeanIX is ranked 1st in Enterprise Architecture Management with 18 reviews. IDERA ER/Studio is rated 8.4, while LeanIX is rated 8.6. The top reviewer of IDERA ER/Studio writes "The solution has important reverse engineering features, but it needs a single sign-on feature". 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". IDERA ER/Studio is most compared with erwin Data Modeler by Quest, SAP PowerDesigner, Sparx Systems Enterprise Architect, Toad Data Modeler and Aqua Data Studio, whereas LeanIX is most compared with ServiceNow, Sparx Systems Enterprise Architect, MEGA HOPEX, ADOIT and iServer. See our IDERA ER/Studio vs. LeanIX 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.