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."Another feature of erwin is that it can help you enforce your naming standards. It has little modules that you can set up and, as you're building the data model, it's ensuring that they conform to the naming standards that you've developed."
"The principal feature that I liked is that the solution has a very graphic interface."
"We use the Forward and Reverse Engineering tools to help us speed things up and create things that would have to be done otherwise by hand. E.g., getting a database into a data model format or vice versa."
"The data lineage feature is very valuable."
"We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team."
"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."
"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 fitting model is very intuitive."
"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 solution has a very useful assessment tool that automatically populates from input data to produce a detailed analysis of customer's environments."
"The ability to import data and generate reports from it. That's where its power lies."
"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."
"One of the product's most valuable features is its ability to configure hardware devices."
"LeanIX has a great application information architecture."
"It is not a very stable solution. I rate the stability five out of ten."
"I love the product. I love the ability to get into the code, make it automated, and make it do what I want. I would like to see them put some kind of governance over the ability to make changes to the mart tables with the API, so that instead of just using the modeler's rights to a table -- it has a separate set of rights for API access. That would give us the ability to put governance around API applications. Right now a person with erwin and Excel/VBA has the ability to make changes to models with the API if they also have rights to make changes to the model from erwin. It's a risk."
"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."
"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 more support for working with the big-data world. There are so many new databases evolving and it's very hard for them to keep up with all of the new technologies. It would be good if they were able to dynamically support big-data platforms, other than Hive and Teradata."
"I am not so happy with its speed. Sometimes, it can have problems with connections."
"It would be nice to have it on the Linux platform, not just Windows. If they can support Linux, there would be a huge market for it."
"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."
"What would make LeanIX better is more variety in terms of reporting, and more flexibility with its data importing feature."
"The solution’s API integration needs to improve. I would like to see a digital screen watch feature also in the solution."
"The modeling could be improved."
"The whole integration architecture view of interfaces/data exchange could be improved."
"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."
"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."
"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."
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 16 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, Visio, Lucidchart and Visual Paradigm, whereas LeanIX is most compared with ServiceNow, Sparx Systems Enterprise Architect, MEGA HOPEX, ADOIT and SAP PowerDesigner. 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.
