We performed a comparison between ADOIT and erwin Data Modeler by Quest based on real PeerSpot user reviews.
Find out what your peers are saying about LeanIX, Sparx Systems, erwin by Quest and others in Enterprise Architecture Management."It helps me to model the architecture at an enterprise level."
"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."
"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 allows us to create logical data models. We can represent a database model in business terms, which is very useful for us."
"We find that its ability to generate database code from a model for a wide array of data sources cuts development time. The ability to create one model in your design phase and then have it generate DDL code for Oracle or Teradata, or whichever environment you need is really nice. It's not only nice but it also saves man-hours of time. You would have to take your design and just type in manually. It has to take days off out of the work."
"There is absolutely no problem with the stability."
"The data lineage feature is very valuable."
"Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution."
"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."
"We need to understand how the data could be segregated."
"It does not have a cloud application."
"The interface must be improved."
"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."
"It is not a very stable solution. I rate the stability five out of ten."
"We can only get licenses through partners."
"The solution's model mark could be better because it crashes sometimes."
"The report generation has room for improvement. I think it was version 8 where you had to use Crystal Reports, and it was so painful that the company I was with just stayed on version 7 until version 9 came out and they restored the data browser. That's better than it was, but it's still a little cumbersome. For example, you run it in erwin, then export it out to Excel, and then you have to do a lot of cosmetic modification. If you discover that you missed a column, then you would have to rerun the whole thing. Sometimes what you would do is just go ahead and fix it in the report, then you have to remember to go back and fix it in the model. Therefore, I think the report generation still could use some work."
"The reverse engineering in Oracle Databases needs improvement, as there are issues."
Earn 20 points
ADOIT is ranked 21st in Enterprise Architecture Management while erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews. ADOIT is rated 8.0, while erwin Data Modeler by Quest is rated 8.6. The top reviewer of ADOIT writes "A good tool that's great for modelling and building heat maps ". On the other hand, 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". ADOIT is most compared with LeanIX, Sparx Systems Enterprise Architect, MEGA HOPEX, Ardoq and BiZZdesign HoriZZon, whereas erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and Sparx Systems Enterprise Architect.
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.