Skip to main content
TrustRadius
erwin Data Modeler

erwin Data Modeler

Overview

What is erwin Data Modeler?

erwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data…

Read more

Learn from top reviewers

Erwin - Still Good But Expensive

Rating: 6 out of 10
April 26, 2021
IncentivizedVetted ReviewVerified User
Erwin was used as a true enterprise data modeling tool, largely by a team of data architects and modelers, to ensure consistent modeling across the corporation. As a large org...
Continue reading
Verified user
Employee
erwin Data Modeler5 years of experience

Erwin's enterprise feature set compensates for the user interface

Rating: 10 out of 10
March 4, 2020
IncentivizedVetted ReviewVerified User
Erwin Data Modeler is an enterprise modeling tool often used by government agencies and organizations to design, maintain, and implement databases to support enterprise applic...
Continue reading
Verified user
Director
erwin Data Modeler15 years of experience

erwin Data Modeler is a winner, though a little boring to look at

Rating: 9 out of 10
February 24, 2020
IncentivizedVetted ReviewVerified User
We are using erwin Data Modeler now for the ERD diagram design. We then provide the ERD to end-users or developers so they can make utilize it while designing their applicatio...
Continue reading
Sean Zef
Analyst - Information Technology
Data Admin
Zef Enterprises, LLC
erwin Data Modeler2 years of experience

Erwin Data Modeler: Communication Enabler

Rating: 9 out of 10
December 3, 2019
IncentivizedVetted ReviewVerified User
Erwin Data Modeler was used by our DBA and Data Architecture to design new data models and document the existing physical databases by reverse engineering them.
Continue reading
Rina Falkovich
Advisor - Information Technology
Data Architect
Western Canada Lottery Corporation (WCLC)
erwin Data Modeler2 years of experience

Best Data Modeling Tool

Rating: 9 out of 10
January 25, 2019
IncentivizedVetted ReviewVerified User
We are using erwin Data Modeler for initial design, development and deployment phases. We use it to design ER diagrams for our new databases or incorporate change requests int...
Continue reading
Ravinder Gupta
Consultant - Information Technology
Senior Oracle Database Administrator
CGI
erwin Data Modeler9 years of experience
Log in with LinkedIn to see content from your network
Return to navigation

Pricing

View all pricing
erwin Data Modeler

erwin Data Modeler

N/A
Unavailable

What is erwin Data Modeler?

erwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data…

Entry-level set up fee?

  • Setup fee optional

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services

Would you like us to let the vendor know that you want pricing?

111 people also want pricing

Alternatives Pricing

ER/Studio Data Architect

ER/Studio Data Architect

$1,470.40
one-time fee per user
What is ER/Studio Data Architect?

ER/Studio is a database development and management tool from Embarcadero Technologies (acquired by Idera) in California.

ManageEngine ADAudit Plus

ManageEngine ADAudit Plus

$595
per year
What is ManageEngine ADAudit Plus?

ADAudit Plus offers real-time monitoring, user and entity behaviour analytics, and change audit reports that helps users keep AD and IT infrastructure secure and compliant.Track all changes to Windows AD objects including users, groups, computers, GPOs, and OUs.Achieve hybrid AD monitoring with a…

Return to navigation

Product Demos

ERwin Data Modeler for Microsoft SQL Azure

YouTube

CA ERwin Data Modeler: Soup to Nuts Demo

YouTube

SAPhir Demo 1.avi

YouTube

erwin Data Modeler r9 7 Basic Demo

YouTube

CA ERwin Data Modeler: Round Trip Demo

YouTube

005 Erwin Data Modeler Indexes

YouTube
View more demos
Return to navigation

Product Details

What is erwin Data Modeler?

erwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives, accomplishing this whil esupporting data governance and intelligence efforts.

erwin Data Modeler Screenshots

Screenshot of Screenshot of Screenshot of

erwin Data Modeler Video

erwin Data Modeler is the world’s No. 1 data modeling software, trusted by more than 50,000 data professionals in 60+ countries. With a unified, accurate view of any data from anywhere, enterprises can make better decisions for competitive advantage and growth.

erwin Data Modeler Competitors

erwin Data Modeler Technical Details

Deployment TypesOn-premise, Software as a Service (SaaS), Cloud, or Web-Based
Operating SystemsWindows, Linux, Mac
Mobile ApplicationNo

Frequently Asked Questions

erwin Data Modeler by Quest is a data modeling tool used to find, visualize, design, deploy and standardize high-quality enterprise data assets. It can discover and document any data from anywhere for consistency, clarity and artifact reuse across large-scale data integration, master data management, metadata management, Big Data, business intelligence and analytics initiatives, accomplishing this whil esupporting data governance and intelligence efforts.

SAP PowerDesigner, ER/Studio Data Architect, and Toad Data Modeler are common alternatives for erwin Data Modeler.

Reviewers rate Support Rating highest, with a score of 9.

The most common users of erwin Data Modeler are from Enterprises (1,001+ employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews From Top Reviewers

View all reviews
(1-4 of 4)

Erwin's enterprise feature set compensates for the user interface

Rating: 10 out of 10
Incentivized
March 04, 2020
Verified User
Director in Professional Services
Information Technology and Services Company, 10,001+ employees
Vetted Review
Verified User
erwin Data Modeler
15 years of experience
Use Cases and Deployment Scope
Erwin Data Modeler is an enterprise modeling tool often used by government agencies and organizations to design, maintain, and implement databases to support enterprise applications. Government agencies and organizations usually select a standard data modeling tool in which they can consistently implement databases and maintain them. It provides a standard software toolset that all projects can use.
Pros
  • Generation/management of DDL.
  • Enforces standard naming conventions.
  • Builds logical and physical data models.
Cons
  • User interface
  • Many options available to learn.
Likelihood to Recommend
Erwin Data Modeler is an enterprise-level tool and should be considered for managing large DB implementations or when aligning to an existing organization's naming standards/definitions/data types is needed. This is a key tool for a Data Architect to design databases. It is possible the cost would not make it ideal for small projects where scripts could be easily managed by scripts.
Return on Investment
  • Standardization of Data Models
  • Generate Data Dictionaries
Support Rating
8
CA customer support and our account manager have been able to support us with any issues that we have had, from managing our serial keys to issues we logged tickets to resolve. There are aspects of key management that have made it difficult over the years but support usually has worked with us.

erwin Data Modeler great for simple use cases

Rating: 5 out of 10
Incentivized
May 10, 2019
Verified User
Employee in Information Technology
Automotive Company, 10,001+ employees
Vetted Review
Verified User
erwin Data Modeler
1 year of experience
Use Cases and Deployment Scope
We currently use erwin Data Modeler on a very small scale. We use it to standardize record abbreviations and field names.
Pros
  • It is reliable in the use case we have, to rename and standardize fields accurately.
  • erwin has as very great customer service team.
Cons
  • Interface is very old seeming
  • Small text and multiple buttons makes the user interface difficult to maneuver
Likelihood to Recommend
erwin has many capabilities that our company does not use to the full potential. We simply use it as a naming conversion tool to standardize our field names.
erwin Data Modeler Feature Ratings
Return on Investment
  • Erwin has provided us with a tool to standardize our field names and record names to our business.
Alternatives Considered
erwin was the only option available when I joined the company. I am unaware of any alternatives.

Erwin - Still Good But Expensive

Rating: 6 out of 10
Incentivized
April 26, 2021
Verified User
Employee in Information Technology
Airlines/Aviation Company, 10,001+ employees
Vetted Review
Verified User
erwin Data Modeler
5 years of experience
Use Cases and Deployment Scope
Erwin was used as a true enterprise data modeling tool, largely by a team of data architects and modelers, to ensure consistent modeling across the corporation. As a large organization it helped address the needs of multiple developers often needing to work within the same model at the same time. It also provided centralization an assured developers were working with the correct version of the model.
Pros
  • Easy to reverse engineer existing databases to bring them into the model or account for drift.
  • Intuitive interface for developers just starting out with the tool.
  • Large number of options on how to display a data model visually, which is critical when dealing with very large models.
Cons
  • Cost is the single largest barrier to entry with this tool.
  • Would like to see a greater variety of export options available for use outside of the tool, for example as a vector graphic.
  • Support has been uneven at times.
Likelihood to Recommend
I have two reservations for ranking erwin higher than I have. One is the cost of the tool. For smaller shops, it can be a tough pill to swallow and difficult to convince management of its value. The other is that I consider erwin to be essentially on par with embarcadero. That being said, erwin is excellent if you need centralized management of your models. This naturally lends itself to a larger shop, but this management is still valuable for smaller companies as well so long as a good process is in place.
erwin Data Modeler Feature Ratings
Return on Investment
  • Reduced rework from when models were maintained individually.
  • Reduced the amount of time to generate and compare models during development.
  • Massively reduced the amount of time to reverse engineer 3rd party data models for analysis.
Alternatives Considered
I was unable to find embarcadero or Datanamic DeZign in the list of other products, but those are two others I have used, along with Visio over the years for data modeling. Erwin is one of the premier tools in the space. I would rate it as a top tool, comparable to embarcadero in most respects, with either being an excellent choice if price is no object. However, for smaller shops, having something is better than nothing, and DeZign is a solid data modeling tool that simply does not have all the bells and whistles of an erwin or embarcadero.
Other Software Used

erwin Data Modeler is a winner, though a little boring to look at

Rating: 9 out of 10
Incentivized
February 24, 2020
SZ
Sean Zef
Data Admin
Zef Enterprises, LLC (Computer Software, 1-10 employees)
Vetted Review
Verified User
erwin Data Modeler
2 years of experience
Use Cases and Deployment Scope
We are using erwin Data Modeler now for the ERD diagram design. We then provide the ERD to end-users or developers so they can make utilize it while designing their applications. We are also using it for some SQL Server change management. For example, when end-users request table changes, we then reverse engineer the existing DB or table, make the change, and then have erwin Data Modeler generate an Alter script that we can reuse once promoted to Production.
Pros
  • ERD diagrams
  • Publishing those ERDs for end-user consumption either on the web or PDF.
Cons
  • The GUI is a little clunky, even on the 2020 version
  • Overwhelming amount of options, which is good eventually
Likelihood to Recommend
Erwin Data Modeler great when trying to model a relational DB that is well established and mainstream. A little less useful for something like Amazon Athena, which kind of makes sense. It makes handy diagrams that have lots of information but is also not very visually appealing to view. Further, it's a little obtuse to figure out initially, again due to option overload - sometimes I wish it had a 'simple' and 'advanced' view. It is excellent for automating diagrams and generating changes for existing DBs.
Return on Investment
  • Would be painful to map databases without it, would likely be whiteboard otherwise.
  • It's kind of expensive, but licensing options are flexible and allow concurrent users.
Alternatives Considered
Not listed, but I've only used alternatives built into something like the Squirrel SQL editor. That one is semi-functional but lacking many features and, in some instances, just plain wrong. The only pro there is that it's freely available and works over ODBC. I've tried some of the other free ones like Creately but didn't have much success.
Support Rating
10
They helped us renew our license and upgrade from 9.1 to 2020, which also allowed us to Decom our license server. Further, once we upgraded they gave a free overview class where my team could ask questions and see the new features. They've extended the offer to the future if we ever need a refresher. I haven't asked about any real technical issues yet, but I'm sure it would be a similar experience.
Return to navigation