2020-01-22T10:49:00Z
Miriam Tover - PeerSpot reviewer
Service Delivery Manager at PeerSpot (formerly IT Central Station)
  • 1
  • 28

What do you like most about erwin Data Modeler (DM)?

Hi Everyone,

What do you like most about erwin Data Modeler (DM)?

Thanks for sharing your thoughts with the community!

17
PeerSpot user
17 Answers
Tracy Hautenen Kriel - PeerSpot reviewer
Architecture Sr. Manager, Data Design & Metadata Mgmt at a insurance company with 10,001+ employees
Real User
Top 5Leaderboard
2021-02-03T23:45:11Z
Feb 3, 2021

It's difficult to name one thing I like most about erwin DM. The integration with DIS is key to helping an organization understand their data, and the forward engineering of ddl automates code generation, reducing manual effort, increasing consistency with governed naming conventions, and enabling faster delivery. I think the thing I like most about erwin DM is the centralized data model repository, which transparently shares information with all Data Modelers while protecting the intellectual property in data models.

Search for a product comparison
SA
Senior Data Warehouse Architect at a financial services firm with 1,001-5,000 employees
Real User
Top 10Leaderboard
2020-12-29T10:56:00Z
Dec 29, 2020

The logical model gives developers, as well as the data modelers, an understanding of exactly how each object interacts with the others, whether a one-to-many, many-to-many, many-to-one, etc.

Jose Luis Leon - PeerSpot reviewer
Data Management & Automation Manager at a consultancy with 11-50 employees
Reseller
Top 5Leaderboard
2020-10-19T09:50:00Z
Oct 19, 2020

The ability to collaborate between different members across the organization is the most valuable feature. It gives us the ability to work on the same model, regardless of where we are physically.

Pam Rivera - PeerSpot reviewer
Independent Consultant at a tech consulting company with 1-10 employees
Real User
2020-10-19T09:50:00Z
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.

Scott Pennah - PeerSpot reviewer
Data Architect at Teknion Data Solutions
Real User
2020-10-15T11:35:00Z
Oct 15, 2020

We use the macros with naming standards patterns, domains, datatypes, and some common attributes. As far as other automations, a feature of the Bulk Editor is mass updates. When it sees something is nonstandard or inaccurate, it will export the better data out. Then, I can easily see which entities and attributes are not inline or standard. I can easily make changes to what was uploaded to the Bulk Editor. When taking on a new project, it can save you about a half a day on a big project across an entire team.

SJ
Data Modeler at a government with 10,001+ employees
Real User
Leaderboard
2020-10-14T06:37:00Z
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.

Learn what your peers think about erwin Data Modeler by Quest. Get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
655,113 professionals have used our research since 2012.
Richard Halter - PeerSpot reviewer
President at a tech services company with 51-200 employees
Real User
Top 5Leaderboard
2020-07-26T08:19:00Z
Jul 26, 2020

It reduces monthly savings by hundreds of thousands of dollars. Think about a company like Costco and all of the points of sale systems in Costco, all of the systems, the applications, but if all the applications in Costco all had their own data model, trying to integrate those, upgrade them and manage their different versions of the same model throughout the store, is an absolute nightmare. It's phenomenally expensive. This helps reduce that cost significantly. I'm talking on the orders of hundreds of thousands of dollars.

Beverly King De Loach - PeerSpot reviewer
Architecture Manager at CIGNA Corporation
Real User
2020-07-05T09:38:00Z
Jul 5, 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.

Tracy Hautenen Kriel - PeerSpot reviewer
Architecture Sr. Manager, Data Design & Metadata Mgmt at a insurance company with 10,001+ employees
Real User
Top 5Leaderboard
2020-06-30T08:17:00Z
Jun 30, 2020

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.

WP
Sr. Data Engineer at a healthcare company with 10,001+ employees
Real User
2020-06-25T10:53:00Z
Jun 25, 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.

DB
Technical Consultant at a insurance company with 1,001-5,000 employees
Real User
2020-06-25T10:53:00Z
Jun 25, 2020

Any tool will do diagramming but I think the ability to put the stuff up in a graphical fashion, then think about it, and keep things consistent is what's valuable about it. It's too easy when you're using other methods to not have naming consistent standards and column consistent definitions, et cetera.

DN
Data Modeler at a logistics company with 10,001+ employees
Real User
2020-04-13T06:27:00Z
Apr 13, 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.

George Halkias - PeerSpot reviewer
Technology Manager at a pharma/biotech company with 10,001+ employees
Real User
2020-03-22T06:49:00Z
Mar 22, 2020

The most valuable features are being able to visualize the data in the diagrams and transform those diagrams into physical database deployments. These features help, specifically, to integrate the data. When the source data is accumulated and modeled, the target model is in erwin and it helps resolve the data integration patterns that are required to map the data to accommodate a model.

Gena Nelson - PeerSpot reviewer
Enterprise Data Architect at a energy/utilities company with 1,001-5,000 employees
Real User
2020-02-13T07:51:00Z
Feb 13, 2020

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.

RH
EDW Architect/ Data Modeler at Royal Bank of Canada
Real User
2020-02-02T10:42:00Z
Feb 2, 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.

SA
Sr. Manager, Data Governance at a insurance company with 501-1,000 employees
Real User
2020-01-27T06:40:00Z
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.

LouisDevenuto - PeerSpot reviewer
VP Enterprise Data Architecture at a financial services firm with 10,001+ employees
Real User
2020-01-22T10:49:00Z
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.

Related Questions
SN
User at personal
Nov 30, 2021
Hey community,Which of these products (SAP PowerDesigner or erwin Data Modeler (DM)) is better and why?Thanks.
See 2 answers
Evgeny Belenky - PeerSpot reviewer
Director of Community at PeerSpot (formerly IT Central Station)
Nov 29, 2021
Hi @George McGeachie, @Carel Van Der Merwe, @Peter Vlekkekn, @Tracy Hautenen Kriel , @Sharon Allen, @Jose Luis Leon ​and @Pam Rivera, Can you please share your professional opinion/experience with our community?
Tracy Hautenen Kriel - PeerSpot reviewer
Architecture Sr. Manager, Data Design & Metadata Mgmt at a insurance company with 10,001+ employees
Nov 30, 2021
15 years ago was the one time I chose to use PowerDesigner over Erwin Data Modeler was for a project where we have hundreds of pl/sql ETL scripts that needed to be run in a specific order for specific tables. PowerDesigner had the ability to store the pl/sql within  the data model and prioritize/order the script run sequence. This meant that we could count on PowerDesigner to automatically generate the ddl and pl/sql code in the correct run order, rather than manually maintaining a spreadsheet with the script order and running each script manually, a VERY labor intensive process. I don't know if PowerDesigner still has that capability.  With all of the ways we have to program and perform ETL, Erwin Data Modeler has been my tool of choice for any other project throughout the years. Protecting intellectual property and transparently sharing data model information with other modelers by saving the the models in a centralized location (i.e. Model Mart) is important for any company. Making the data model diagrams transparently accessible via Web Portal is another important step in ensuring both technical and business users understand the structure and relationships of the data contains within a data store. Lastly, making the data model metadata available via the Erwin Data Intelligence Suite enables both technical and business users to completely understand everything about the data and data store: Business Glossary, Reference Data, Governance, Data Quality, Data Mapping, and especially automating data lineage and impact analysis.
it_user434868 - PeerSpot reviewer
Senior Director of Delivery at a tech services company with 51-200 employees
Jan 5, 2022
Hi, We all know it's really hard to get good pricing and cost information. Please share what you can so you can help your peers.
2 out of 17 answers
SA
Sr. Manager, Data Governance at a insurance company with 501-1,000 employees
Jan 27, 2020
We came up with a two-part concept with our licensing. Our data architects have named licenses that only they can use. We have four named licenses today. But we also bought three concurrent licenses, two that are just for developers and the DBAs, and one that's a "read-only" that anybody can use. It's a little bit difficult for me to tell you how many people use those, but probably no less than 10 and possibly upwards of 25. We pay for maintenance on a yearly basis. There are no additional costs for the Workgroup Edition, which has the server component. That is the edition where you can save your models back to a database, which we installed on SQL Server, but I think you can install it on any of several different platforms.
RH
EDW Architect/ Data Modeler at Royal Bank of Canada
Feb 2, 2020
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.
Download Free Report
Download our free erwin Data Modeler by Quest Report and get advice and tips from experienced pros sharing their opinions. Updated: November 2022.
DOWNLOAD NOW
655,113 professionals have used our research since 2012.