Try our new research platform with insights from 80,000+ expert users
erwin Data Modeler by Quest Logo

erwin Data Modeler by Quest Reviews

4.3 out of 5
Badge Leader
255 followers
Start review

What is erwin Data Modeler by Quest?

Featured erwin Data Modeler by Quest reviews

erwin Data Modeler by Quest mindshare

Product category:
As of March 2025, the mindshare of erwin Data Modeler by Quest in the Enterprise Architecture Management category stands at 11.0%, up from 10.0% compared to the previous year, according to calculations based on PeerSpot user engagement data.
Enterprise Architecture Management

PeerAnalyst reports based on erwin Data Modeler by Quest reviews

TypeTitleDate
CategoryEnterprise Architecture ManagementMar 8, 2025Download
ProductReviews, tips, and advice from real usersMar 8, 2025Download
Comparisonerwin Data Modeler by Quest vs LeanIXMar 8, 2025Download
Comparisonerwin Data Modeler by Quest vs Sparx Systems Enterprise ArchitectMar 8, 2025Download
Comparisonerwin Data Modeler by Quest vs MEGA HOPEXMar 8, 2025Download
Suggested products
TitleRatingMindshareRecommending
Sparx Systems Enterprise Architect3.914.2%87%99 interviewsAdd to research
LeanIX4.216.3%95%21 interviewsAdd to research
 
 
Key learnings from peers

Valuable Features

Room for Improvement

ROI

Pricing

Popular Use Cases

Service and Support

Deployment

Scalability

Stability

Review data by company size

By reviewers
By visitors reading reviews

Top industries

By visitors reading reviews
Financial Services Firm
19%
Manufacturing Company
10%
Government
9%
Computer Software Company
7%
Insurance Company
6%
Retailer
6%
Healthcare Company
5%
Energy/Utilities Company
5%
University
3%
Real Estate/Law Firm
3%
Educational Organization
3%
Construction Company
3%
Non Profit
2%
Comms Service Provider
2%
Performing Arts
2%
Media Company
2%
Transportation Company
2%
Logistics Company
2%
Hospitality Company
1%
Legal Firm
1%
Outsourcing Company
1%
Recreational Facilities/Services Company
1%
Pharma/Biotech Company
1%
Wellness & Fitness Company
1%
Aerospace/Defense Firm
1%
Leisure / Travel Company
1%
 

erwin Data Modeler by Quest reviews

Sort by:
AW
Data Architect at a energy/utilities company with 10,001+ employees
Verified user of erwin Data Modeler by Quest
Jan 10, 2025
Product version discussed: version fourteen
Reverse engineering capability revolutionizes data modeling

Pros

"One of the best aspects of the tool is its reverse engineering capability. "

Cons

"One of the best aspects of the tool is its reverse engineering capability. "
DN
Data Modeler at a logistics company with 10,001+ employees
Verified user of erwin Data Modeler by Quest
Apr 16, 2020
Product version discussed: 2018 r1
Makes our data modeling staff more productive and has helped standardize data modeling efforts

Pros

"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. "

Cons

"Complete Compare is set up only to compare properties that are of interest to us, but some of the differences cannot be brought over from one version of the model to another. This is despite the fact that we are clicking to bring objects from one place to another. Therefore, it's hard to tell at times if Complete Compare is working as intended without having to manually go into the details and check everything. If it could be redesigned to a degree where it is easier to use when we bring things over from one site to another and be sure that it's been done correctly, that would be nice to have. We would probably use the tool more often if the Complete Compare were easier to use."
Find out what your peers are saying about erwin Data Modeler by Quest. Updated March 2025
841,152 professionals have used our research since 2012.
SA
Sr. Manager, Data Governance at a insurance company with 501-1,000 employees
Verified user of erwin Data Modeler by Quest
Jan 30, 2020
Allows us to bring in data from dozens of platforms and search holistically across all of them

Pros

"When you're getting down to the database level, where you're building a design and you're creating DDL out of it, or you're going in the other direction where you're reaching into system catalogs and bringing things back, that starts to really require specialization. Visio isn't going to reverse-engineer that for you. Those features in erwin are valuable."

Cons

"One of the things I've been talking to the erwin team about through the years is that every data model should have the ability to be multi-language... When I was working at Honda, it became very difficult to work with the Japanese teams using just one model. You can have two models, one in English and one in Japanese, but that means you have to keep the updates back and forth, and that always increases the risk of something not being updated."
RH
EDW Architect/ Data Modeler at Royal Bank of Canada
Verified user of erwin Data Modeler by Quest
Feb 6, 2020
Product version discussed: 9.64.01
We can input large files in one shot using the Bulk Editor feature

Pros

"The solution’s code generation ensures accurate engineering of data sources, as there is no development time. Code doesn't even have to be reviewed. We have been using this solution for so long and all the code which has been generated is accurate with the requirements. Once we generate the DDLs out of the erwin tools, the development team does a quick review of the script line by line. They will just be running the script on the database and looking into other requirements, such as the index. So, there is less effort from development side to create tables or build a database."

Cons

"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."
PeerSpot user
Director of BI & Analytics at a logistics company with 10,001+ employees
Verified user of erwin Data Modeler by Quest
Jul 12, 2021
Product version discussed: 2020 R2, 64-Bit
Standardizes our practices, supports a wide variety of databases, and allows us to create logical data models

Pros

"It allows us to create logical data models. We can represent a database model in business terms, which is very useful for us. "

Cons

"In terms of improvements, support could have been better in terms of installation, especially of workgroups. We struggled quite a bit to get it up and running. Collaboration could have been better from an installation perspective, but it is trivial as compared to what we use it for. Other than that, I don't have much feedback. It works pretty well, and the fact that we've been using it for more than a decade shows that it is quite solid. "
RP
Senior Data Architect at a financial services firm with 10,001+ employees
Verified user of erwin Data Modeler by Quest
Jul 4, 2021
Support for Snowflake helps our teams adhere to internal standards that couldn't be satisfied with other tools

Pros

"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. "

Cons

"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."
BK
Architecture Manager at CIGNA Corporation
Verified user of erwin Data Modeler by Quest
Jul 27, 2020
Product version discussed: 2020 R2
The ability to generate database code from a model for a wide array of data sources cuts development time

Pros

"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."

Cons

"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."
TH
Architecture Sr. Manager, Data Design & Metadata Mgmt at a insurance company with 10,001+ employees
Verified user of erwin Data Modeler by Quest
Dec 1, 2020
Product version discussed: 2020 R1
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

Pros

"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. "

Cons

"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."