We performed a comparison between erwin Data Modeler by Quest and iServer 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."The data lineage feature is very valuable."
"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."
"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."
"erwin has versioning so you can keep versions, over time, of those models and you can compare any version to any version. If you're looking at a specific database and you want to see what changed over time, that's really useful. You can go back to a different version or connect that to your change-control processes so you can see what was released when."
"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."
"It is a scalable solution...The technical support team is fine."
"The solution's ability to compare and synchronize data sources with data models is fantastic. We use it for that on a regular basis to make sure that changes haven't been made to the database outside of the modeling process. I can take existing databases and reverse engineer them and understand their structure within 15 minutes. If I didn't have Data Modeler it would take hours. It increases our productivity and helps in understanding our legacy application."
"The visual data models for helping to overcome data source complexity and enabling understanding and collaboration around maintenance and usage are excellent. A picture speaks 1,000 words. Seeing a picture that shows you how the data relates to each other helps you better understand what the data is and how to use it. Pairing that information with a dictionary, which has the definitions of the tables and columns or the entities and attributes, ensures that the users understand what the data is so that they can use it best and most successfully."
"Good and effective reporting features, which help in decision making."
"We like the governance."
"It has helped having data lineage in the business cluster, which is used as control artifacts."
"The solution is easily modified to suit your needs."
"iServer is a solution that helps catalog enterprise architect solutions and catalog information."
"Integrating the Microsoft documents to the product and visualization matrix where we can see the end-to-end relationship of the network is of great importance to our company."
"There were lots of different requirements, and collaboration and review is one of the biggest things. There is also Office 360 integration, and there's flexibility to use it as a database as well."
"The most valuable features of iServer are the integration with Microsoft Office and the interface is similar to Microsoft applications making them easy to use."
"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."
"I would like to see the ability to support more NoSQL platforms more quickly. In addition, enhancing the graphics to render more quickly would be beneficial for any user."
"I'd really like to see the PDF function become available. It would make my life much easier than what it is at the moment because whenever I need to collaborate with people that do not have erwin, I have to go through the wonkiness of going to Word and then save it from Word into PDF. There's a lot of differences between erwin 4.4 and 2020."
"The erwin Data Modeler is quite complex to use."
"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."
"There is a lack of local support in the China region."
"erwin is not as robust as a data warehousing project I've been on in the past."
"Some Source official systems give us DDLs to work with and they have contents not required to be part of the DDL before we reverse engineer in the erwin DM. Therefore, we manually make changes to those scripts and edit them, then reverse-engineer within the tool. So, it does take some time to edit these DDL scripts generated by the source operational systems. What I would suggest: It would be helpful if there were a place within the erwin tool to import the file and automatically eliminate all the unnecessary lines of code, and just have the clean code built-in to generate the table/data model."
"We could allocate permissions to use only specific components to the users rather than the entire instance."
"It definitely needs help to improve the visual aspect of the solution."
"There could be features for process mining, process simulation, and analytics."
"The performance is slow, which is something that should be improved."
"Enhancing integration options with ERP or ITSM-related solutions for triggering automated requests for process definitions, changes, and tracking them in the iServer."
"The one issue is that if you want to import predefined work, you need to put the licensing model in. So if you wanted to import work that was done before, you then need to buy a separate product for that."
"Cannot see which activities are control activities."
"More visualization techniques and ways to report the data might be helpful."
erwin Data Modeler by Quest is ranked 3rd in Enterprise Architecture Management with 37 reviews while iServer is ranked 6th in Enterprise Architecture Management with 15 reviews. erwin Data Modeler by Quest is rated 8.6, while iServer is rated 7.2. 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 iServer writes "Enables flexible parameters for any process model and has a valuable document management feature ". erwin Data Modeler by Quest is most compared with SAP PowerDesigner, IDERA ER/Studio, Visio, Lucidchart and BiZZdesign HoriZZon, whereas iServer is most compared with LeanIX, Sparx Systems Enterprise Architect, Visio, ARIS BPA and OrbusInfinity. See our erwin Data Modeler by Quest vs. iServer report.
See our list of best Enterprise Architecture Management vendors and best Business Process Design 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.