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
Recent Reviews

TrustRadius Insights

erwin Data Modeler has proven to be a valuable tool for users across various stages of the database development process. Data architects, …
Continue reading
Read all reviews
Return to navigation

Pricing

View all pricing
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?

71 people also want pricing

Alternatives Pricing

What is ER/Studio Data Architect?

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

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
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 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 and Ratings

(23)

Community Insights

TrustRadius Insights are summaries of user sentiment data from TrustRadius reviews and, when necessary, 3rd-party data sources. Have feedback on this content? Let us know!

erwin Data Modeler has proven to be a valuable tool for users across various stages of the database development process. Data architects, DBAs, and data modelers have used the software to design, develop, and deploy databases. The software enables users to create ER diagrams for both new databases and existing ones, incorporating change requests seamlessly. These ERD diagrams have been shared with end-users and developers to assist in application design. Additionally, erwin Data Modeler has facilitated SQL Server change management by allowing for table changes and generating reusable Alter scripts for production.

The software’s benefits extend beyond design and development tasks. It has played a crucial role in version control and release control within database environments. Users have found it helpful in discussing database designs with functional teams and DBAs, using ER diagrams as visual aids for effective communication. Organizations with multiple applications have benefited from erwin Data Modeler's support in implementing a comprehensive SDLC for database changes and version control. Moreover, the software has been selected as a standard data modeling tool by government agencies and organizations seeking to design, maintain, and implement databases. On a smaller scale, it has even been utilized to standardize record abbreviations and field names.

In summary, erwin Data Modeler offers a wide range of use cases that cater to the needs of data architects, DBAs, and data modelers at various stages of the database lifecycle. Its versatility in facilitating design, development, documentation, change management, and communication makes it a valuable asset for organizations aiming for efficient and standardized database operations.

Users have shared several recommendations for the software based on their experiences. Among these, three common recommendations stand out:

  1. Users find the software to be a reliable Data Model tool that supports various databases and data model approaches. They recommend using it for all data modeling needs.

  2. The software is praised for its user-friendly interface and ease of use, even for beginners with minimal training. Its intuitive design allows users to quickly navigate and utilize its features.

  3. It is suggested to explore the Academic edition of the software, especially for those who want to try it out without any financial commitment.

Additionally, users advise gaining a basic understanding of data types and attributes to effectively leverage the software's capabilities. They also appreciate how the software facilitates collaboration among team members by enabling the creation of data models for systems with different databases.

Attribute Ratings

Reviews

(1-2 of 2)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We are a big organization that supports multiple applications. We use erwin Data Modeler for database model design before it can actually make to the database.
We build ER diagrams out of requirement documents and then use these ER diagrams to discuss in meetings with functional and DBA teams. Once the design is approved, we further use erwin Data Modeler to make both logical and physical data models, include triggers and constraints in the model, and forward engineer deployment scripts for the DBA team.
erwin Data Modeler has greatly helped us maintain a SDLC for database changes and version control.
  • erwin Data Modeler helps generate deployment scripts for database deployments without the need to worry about programming syntax.
  • It helps you compare different models pretty easily and identify any discrepancies induced due to human error during deployment cycles.
  • I have a great experience of using erwin Data Modeler to generate database models straight out of database SQL file. This feature is called reverse engineering in erwin Data Modeler world.
  • erwin Data Modeler allows only 25 entities in a trial version. It really limits you when you want to try out the product before actually deciding to pay for licensing cost. It would be rather helpful if they limit the trial period by days instead.
  • The UI is pretty good but sometimes the large diagrams are hard to manage. A little improvement in that area would be helpful.
I have had a chance to use few other data modeling tools from Quest and Oracle, but I am most comfortable using erwin Data Modeler. They understand your data modeling needs and have designed the software to give you a feeling of completeness when you are designing a data model.
  • It has greatly improved version control of our database design and deployment part of SDLC.
  • We have improved our productivity and reduced reworks caused by deployment errors.
  • We have a way to track each database change back to requirements where the database change had originally originated.
I have used few other data modeling tools like Toad Data Modeler and SQL Developer Data Modeler. erwin Data Modeler is easy to use and has additional features that make overall data modeling productive and easy to manage.
Oracle Linux, Red Hat Enterprise Linux (RHEL), Suse Linux, Veeam Backup & Replication, Oracle GoldenGate, ClickUp, Asana, Microsoft Office 365, HPE StoreOnce, HPE 3PAR StoreServ Storage, Red Hat JBoss Enterprise Application Platform, Oracle Database, Oracle Database 12c, Oracle WebLogic Application Server, Oracle Enterprise Manager Cloud Control, Veeam ONE, Control-M, Toad for Oracle, SQL Developer, Adobe Flash, Adobe Photoshop, Adobe Illustrator CC
No
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
  • Vendor Reputation
  • Existing Relationship with the Vendor
  • Third-party Reviews
Prior experience was the single most important factor in why we chose the product in our initial phase of project planning.
We are very pleased with the product and our evaluation process. I don't think we need to change something in that context.
  • Creating ER Diagrams.
  • Generating SQL scripts from the data models.
  • Comparing data model with another model or SQL script.
I had a lot of experience using erwin Data Modeler for designing data models. I think it's pretty intuitive and easy to use. It has enough features to represent your database requirements in form of a model.
January 25, 2019

Best Data Modeling Tool

Ravinder Gupta | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
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 into existing. We then forward engineer deployment scripts for erwin directly and deploy it to various database environments. This has helped us version control and release control in our database environments. It is also easier to discuss with functional team by presenting them with ER diagram block instead of talking to them in database language.
  • Reverse Engineering: I love the way we can import an SQL file containing schema meta data and generate ER diagram out of it. This is specifically useful if you are implementing erwin Data Modeler for an existing database.
  • Forward Engineering: We use this feature very frequently. Where we do database changes in our physical and logical data models and then generate deployment scripts for the changes made.
  • Physical vs Logical Models: I like to have my database model split into physical and logical models and at the same time still linked to each other. Any changes you make to logical model or physical model shows up in the other.
  • For large models, it gets tedious to print the diagram in a single pdf. I have to often make adjustment and if i use the fit model feature, it kind of changes the alignment of entities in my ER diagram. Erwin may let us make pdf of the model as is.
  • I have used reverse engineering using for Oracle schemas. It will be very good if it supports reverse engineering for more vendors, so i can use erwin data modeler for database conversion activities too.
If you have a database environment that gets frequent schema object change requests. erwin Data Modeler is a great tool for version control and release control. Also, it's very useful to communicate between database and application teams.
  • erwin Data Modeler had been a great tool for our database development and application DBA teams. The thorough data modeling and release control helps us to back trace any issues which are pointed to us at a later stage in the development cycle.
  • Initially, some of the team members saw it as an extra effort to maintain data models while they can simply create scripts without models. But overtime, people have realized how it avoids problems and discrepancies over time.
Toad is usually a great suite of products. I am a fan of Toad for Oracle particularly. But for data modeling, the ease and features that erwin Data Modeler offers are unbeatable.
No
  • Price
  • Product Features
  • Product Usability
  • Product Reputation
  • Prior Experience with the Product
Prior Experience with the product. I have used this product in past and few other data modeling products, I strongly recommended to chose erwin Data Modeler.
I don't really think I would change anything in the selection process. Well, would like to discuss a better corporate discount though :)
  • Reverse Engineering: It sounds like a big term, but creating models from SQL scripts is super easy.
  • Comparing two schema SQLs. This highlights the differences and helps you incorporate the differences in your model.
  • I haven't really had experience of anything to be classified as Cubersome while using this product.
The product is well designed and intuitive to use. The number of buttons and options can look a bit overwhelming initially but they come very handy when you get used to product.
Return to navigation