erwin Data Modeler by Quest vs iServer comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

erwin Data Modeler by Quest
Ranking in Enterprise Architecture Management
3rd
Ranking in Business Process Design
9th
Average Rating
8.6
Number of Reviews
37
Ranking in other categories
Database Design (1st)
iServer
Ranking in Enterprise Architecture Management
6th
Ranking in Business Process Design
13th
Average Rating
7.2
Number of Reviews
15
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of June 2024, in the Enterprise Architecture Management category, the mindshare of erwin Data Modeler by Quest is 13.2%, up from 10.5% compared to the previous year. The mindshare of iServer is 3.0%, down from 4.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Enterprise Architecture Management
Unique Categories:
Business Process Design
2.1%
 

Featured Reviews

GB
Oct 2, 2023
An easy-to-deploy data modeling solution that allows users to reuse entities and attributes
We use the solution for data modeling We believe that the solution would help provide some structure to our data modeling and data design practices. The product allows us to reuse entities and attributes. Whether we're working on a conceptual or logical model, once we have defined them, we can…
FY
Nov 22, 2022
Useful in managing artifacts but the integration capabilities are flaky
We use iServer to manage our artifacts and governance Central repository holding single version of truth. We really like the governance. The modelling needs improvement, specifically forecasting capabilities and scenarios. The existing capabilities have integration with the office, and it's…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Being able to point it to a database and then pull the metadata is a valuable feature. Another valuable feature is being able to rearrange the model so that we can display it to users. We are able to divide the information into subject areas, and we can divide the data landscape into smaller chunks, which makes it easier to understand. If you had 14 subject areas, 1,000 entities, and 6,000 columns, you can't quite understand it all at once. So, being able to have the same underlying model but only display portions of it at a time is extremely useful."
"We can create mappings in erwin and possibly data dictionaries."
"The principal feature that I liked is that the solution has a very graphic interface."
"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."
"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."
"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 data lineage feature is very valuable."
"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."
"Good and effective reporting features, which help in decision making."
"The solution is easily modified to suit your needs."
"The solution has wide use within Microsoft products. The integration with Microsoft products, and, in particular, Microsoft Office, is great."
"iServer has valuable features for workflow and document management."
"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."
"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."
"The product has a valuable customized model."
 

Cons

"The Bulk Editor needs improvement. If you had something that was a local model to your local machine, you could connect to the API, then it would write directly into the repository. However, when you have something that is on the centralized server, that functionality did not work. Then, you had to export out to a CSV and upload up to the repository. It would have been nice to be able to do the direct API without having that whole download and upload thing. Maybe I didn't figure it out, but I'm pretty sure that didn't work when it was a model that sat on a centralized repository."
"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."
"The erwin ETL functionality has room for improvement when it comes to mapping databases with a classic entity-relationship model to a data warehouse model."
"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."
"The solution's reporting side needs to be improved."
"There is a lack of local support in the China region."
"In terms of new features, it would be great to have a cloud base. We should be able to put it on the cloud for better collaboration and data models sharing."
"Cannot see which activities are control activities."
"The migration tool needs to be included in the main package, and not as a separate license."
"Requirements management needs to be improved."
"There can be some performance issues using the solution that should be improved. When you make modifications modify to files there are embedded data within that can take a while to process."
"I haven't used this solution long enough to know what areas could be improved."
"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."
"There could be features for process mining, process simulation, and analytics."
"More visualization techniques and ways to report the data might be helpful."
 

Pricing and Cost Advice

"The primary reasons that erwin was selected were that it was much more affordable for us [than Embarcadero] and it was easily maintainable."
"There is either a one-year or three-year license. It is not a pay-as-you-go license like a SaaS solution. It’s more of a traditional licensing. They are a little bit on the pricier side."
"The price should be lower in order to be on the same level as its competitors."
"Price-wise, erwin Data Modeler is okay. You can purchase a single license and it is not very expensive."
"erwin has this option where you pay a one-time fee and you have the license for six years, which makes sense because I don't upgrade my database engine every other year. I have an application that depends on it. This is something weird about PowerDesigner. There are no additional costs beyond the standard licensing fee."
"We've continued to use the product for many years and compared it with others on the market. The pricing is reasonable considering what the solution offers and what we pay. There are cheaper tools, but they may not be as robust and easy to use, so it's worth the money."
"The solution is expensive."
"This company had bought the license for three years, and it's not an individual license. While you can buy a license for each individual, that would be very expensive. There is something called concurrent licenses where you can purchase licenses in bulk and 15 to 20 people can access the license and model. Concurrent licenses are scalable to the number of users and are proportional to the cost."
"They offer annual subscriptions for developing countries, which are not affordable for small or medium businesses."
"The product has a moderate pricing."
"It's about 13K to set up and 9K for the license for three months. I think it's about 20K a year, but we haven't firmed up on pricing yet because the price depends on how long we commit to the solution."
"Aim for the exact number of people who shall define/review approve and view the processes, as it will impact the cost."
"The price of iServer is reasonable compared to other solutions."
report
Use our free recommendation engine to learn which Enterprise Architecture Management solutions are best for your needs.
787,779 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
19%
Government
10%
Computer Software Company
9%
Manufacturing Company
8%
Educational Organization
35%
Financial Services Firm
11%
Government
11%
Computer Software Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about erwin Data Modeler by Quest?
Forward engineering, DDL generation, reverse engineering, and reporting are the most valuable features of the solution.
What needs improvement with erwin Data Modeler by Quest?
The solution's model mark could be better because it crashes sometimes.
What do you like most about iServer?
iServer has valuable features for workflow and document management.
What needs improvement with iServer?
They haven't introduced new features for the product's on-premise version since 2021, similar to the SaaS version. There could be features for process mining, process simulation, and analytics.
What is your primary use case for iServer?
We use the product for various critical functions within our environment, particularly in a government entity, where it assists in governance, workflow management, and generating reports and live d...
 

Also Known As

erwin DM
No data available
 

Overview

 

Sample Customers

 Premera, America Honda Motors, Aetna, Kaiser Permanente, Dental Dental Cali, Cigna, Staples
Barclays, Cathay Pacific, Deloitte, British Gas, MasterCard
Find out what your peers are saying about erwin Data Modeler by Quest vs. iServer and other solutions. Updated: May 2024.
787,779 professionals have used our research since 2012.