Try our new research platform with insights from 80,000+ expert users

erwin Data Modeler by Quest pros and cons

Vendor: erwin by Quest

4.3 out of 5

38 reviews
95% willing to recommend

255 followers

Pros & Cons summary

erwin Data Modeler by Quest visually represents databases and generates DDLs for implementation, facilitating versioning, integration, and collaboration across teams. It offers change-control and reverse engineering features but needs enhanced support for big-data platforms, multi-language capabilities, and an improved DDL editing process. Challenges include reverse engineering from Oracle Databases and lacking robust reporting and API management. Despite these, it efficiently handles complex data integration scenarios across multiple databases.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.

Prominent pros & cons

PROS

Erwin Data Modeler by Quest offers robust versioning capabilities, allowing users to keep multiple versions of data models and compare different versions over time.

It enhances database implementation efficiency by enabling the generation of accurate DDL from data models without the need for extensive review.

Data models in Erwin Data Modeler by Quest can be visually represented, making it easier to integrate and understand complex data relationships and the overall structure.

The tool facilitates the enforcement of naming standards and ensures consistency across data modeling practices within an organization.

Erwin Data Modeler by Quest supports forward and reverse engineering, simplifying the process of creating data models from existing databases and vice versa.

CONS

Erwin Data Modeler by Quest has difficulties keeping up with evolving big-data technologies and dynamic support for big-data platforms beyond Hive and Teradata is needed.

Translation features can be improved to support multi-language data models, preventing challenges in international collaboration.

The tool struggles with successfully reverse engineering Oracle Databases, causing additional steps to integrate physical data models.

Dynamic and inclusive reporting capabilities are lacking, with current options being manual and limited.

Complexities arise in merging data models when multiple data modelers are involved, causing complications in shared environments.

erwin Data Modeler by Quest Pros review quotes

SA

Sr. Manager, Data Governance at a insurance company with 501-1,000 employees

Jan 27, 2020

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.

Read full review

DN

Damian Niedzielski

Data Modeler at a logistics company with 10,001+ employees

Apr 16, 2020

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.

Read full review

DJ

David Jaques-Watson

Senior Consultant at a tech services company with 11-50 employees

Aug 17, 2021

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.

Read full review

erwin Data Modeler by Quest

Free Report: erwin Data Modeler by Quest Reviews and More

Learn what your peers think about erwin Data Modeler by Quest. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

816,406 professionals have used our research since 2012.

PR

Independent Consultant at a tech consulting company with 1-10 employees

Oct 19, 2020

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.

Read full review

BK

Beverly King De Loach

Architecture Manager at CIGNA Corporation

Jul 27, 2020

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.

Read full review

reviewer1376661

Sr. Data Engineer at a healthcare company with 10,001+ employees

Aug 4, 2020

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.

Read full review

reviewer1436250

Data Modeler at a government with 10,001+ employees

Oct 14, 2020

It's a safeguard for me because I'm always concerned that somebody is free handing it and will forget a key coming from the parent. The migrating keys are a great feature. Identifying relationships, non-identifying relationships, and being visually right there to understand the differences are great features. erwin is key to being able to visually understand whatever the customer is requesting. They'll give you words on a paper, but once they can actually view it as a picture, it really comes to life. The data comes to life to where they understand exactly what they're asking for.

Read full review

RH

EDW Architect/ Data Modeler at Royal Bank of Canada

Feb 6, 2020

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.

Read full review

reviewer1270548

VP Enterprise Data Architecture at a financial services firm with 5,001-10,000 employees

Jan 22, 2020

The most valuable feature is the physical or visual representation of the database, showing the tables, the columns, the foreign keys, and the ability to generate DDL, so you can physically implement databases.

Read full review

reviewer1580040

Director of BI & Analytics at a logistics company with 10,001+ employees

May 18, 2021

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

Read full review

Show 10 more reviews (out of 38)

erwin Data Modeler by Quest Cons review quotes

SA

Sr. Manager, Data Governance at a insurance company with 501-1,000 employees

Jan 27, 2020

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.

Read full review

DN

Damian Niedzielski

Data Modeler at a logistics company with 10,001+ employees

Apr 16, 2020

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.

Read full review

DJ

David Jaques-Watson

Senior Consultant at a tech services company with 11-50 employees

Aug 17, 2021

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.

Read full review

erwin Data Modeler by Quest

Free Report: erwin Data Modeler by Quest Reviews and More

Learn what your peers think about erwin Data Modeler by Quest. Get advice and tips from experienced pros sharing their opinions. Updated: November 2024.

816,406 professionals have used our research since 2012.

PR

Independent Consultant at a tech consulting company with 1-10 employees

Oct 19, 2020

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.

Read full review

BK

Beverly King De Loach

Architecture Manager at CIGNA Corporation

Jul 27, 2020

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.

Read full review

reviewer1376661

Sr. Data Engineer at a healthcare company with 10,001+ employees

Aug 4, 2020

erwin generally fails to successfully reverse engineer our Oracle Databases into erwin data models. The way that they are engineered on our side, the syntax is correct from an Oracle perspective, but it seems to be very difficult for erwin to interpret. What I end up doing is using Oracle Data Modeler to reverse engineer into the Oracle data model, then forward engineer the DDL into an Oracle syntax, and importing that DDL into erwin in order to successfully bring in most of the information from our physical data models. That is a bit of a challenge.

Read full review

reviewer1436250

Data Modeler at a government with 10,001+ employees

Oct 14, 2020

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.

Read full review

RH

EDW Architect/ Data Modeler at Royal Bank of Canada

Feb 6, 2020

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.

Read full review

reviewer1270548

VP Enterprise Data Architecture at a financial services firm with 5,001-10,000 employees

Jan 22, 2020

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.

Read full review

reviewer1580040

Director of BI & Analytics at a logistics company with 10,001+ employees

May 18, 2021

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.

Read full review

Show 10 more reviews (out of 37)

Product Categories

Product Categories

Enterprise Architecture Management

Business Process Design

Popular Comparisons

Popular Comparisons

Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest

LeanIX vs erwin Data Modeler by Quest

MEGA HOPEX vs erwin Data Modeler by Quest

SAP PowerDesigner vs erwin Data Modeler by Quest

iServer vs erwin Data Modeler by Quest

BiZZdesign HoriZZon vs erwin Data Modeler by Quest

Avolution ABACUS vs erwin Data Modeler by Quest

IDERA ER/Studio vs erwin Data Modeler by Quest

erwin Evolve by Quest vs erwin Data Modeler by Quest

Ardoq vs erwin Data Modeler by Quest

ADOIT vs erwin Data Modeler by Quest

IBM Rational System Architect vs erwin Data Modeler by Quest

AWS Well-Architected Tool vs erwin Data Modeler by Quest

SAP Enterprise Architecture Designer vs erwin Data Modeler by Quest

UNICOM System Architect vs erwin Data Modeler by Quest

See all alternatives

Product Categories

Product Categories

Enterprise Architecture Management

Business Process Design

Popular Comparisons

Popular Comparisons

Sparx Systems Enterprise Architect vs erwin Data Modeler by Quest

LeanIX vs erwin Data Modeler by Quest

MEGA HOPEX vs erwin Data Modeler by Quest

SAP PowerDesigner vs erwin Data Modeler by Quest

iServer vs erwin Data Modeler by Quest

BiZZdesign HoriZZon vs erwin Data Modeler by Quest

Avolution ABACUS vs erwin Data Modeler by Quest

IDERA ER/Studio vs erwin Data Modeler by Quest

erwin Evolve by Quest vs erwin Data Modeler by Quest

Ardoq vs erwin Data Modeler by Quest

ADOIT vs erwin Data Modeler by Quest

IBM Rational System Architect vs erwin Data Modeler by Quest

AWS Well-Architected Tool vs erwin Data Modeler by Quest

SAP Enterprise Architecture Designer vs erwin Data Modeler by Quest

UNICOM System Architect vs erwin Data Modeler by Quest

See all alternatives

Related questions

57

Which would you choose - SAP PowerDesigner or erwin Data Modeler (DM)?

125

Can you recommend a graphic illustration tool to model the architecture of IT systems?

23

When evaluating Architecture Management, what aspect do you think is the most important to look for?

85

Tools to Develop and Manage IT Infrastructure Road-maps

84

Sparx system comparing with ARIS and IBM blueworks.

174

What EA tool would you advise us to use?

157

What are some business benefits associated with enterprise architecture?

44

Any experience on newer/low-cost cloud based EA Modelling Tools?

117

How to model an enterprise architecture? What tools and templates can I use?

36

How to export IBM Rational System Architect data into Alfabet Enterprise Architecture Management (by Software AG)?