108 ) erwin Data Modeler features

 

Overview of erwin Data Modeler

erwin Data Modeler (by Quest Software) is an industry-standard enterprise data modeling solution designed to discover, design, visualize, standardize, and deploy complex data architectures (including relational databases, data warehouses, NoSQL, and Big Data platforms).

Key Features

• Multi-Tiered Modeling: Supports conceptual, logical, and physical data models to bridge the gap between business semantics and technical database designs.

• Forward and Reverse Engineering: Automatically generates database schemas, DDL scripts, and migration codes from models (forward engineering), or extracts structural models out of existing legacy databases and scripts (reverse engineering).

• "Complete Compare" Mechanism: A robust bidirectional synchronization feature that compares models against live databases or other models, highlights differences, and generates selective update/ALTER scripts.

• Centralized Repository (erwin Mart): Enables multi-user collaboration, conflict resolution, version control, change auditing, and integration with source code repositories like GitHub.

• Standardization & Reusability: Enforces naming and data-type standards, model templates, and domains to maintain consistency across enterprise projects.

• Data Governance & Catalog Integration: Automatically harvests metadata, definitions, and naming standards to feed directly into the erwin Data Intelligence suite and enterprise data catalogs.

How it is Different from Other Tools

• Broad Multi-Platform & Hybrid Support: Unlike native database GUI tools or lightweight diagramming utilities, erwin natively bridges traditional relational structures (Oracle, SQL Server, Snowflake, Teradata) with emerging NoSQL environments (MongoDB, Cassandra, Couchbase) within a unified interface.

• Deep Enterprise Integration Ecosystem: It does not operate in a vacuum; it connects data modeling directly to data governance, data catalogs, and business glossaries rather than stopping purely at database design.

• Advanced Enterprise Collaboration (erwin Mart): While many tools support basic local file saving or basic team sharing, erwin offers a dedicated repository framework with granular role-based permissions, concurrent multi-user editing, and precise conflict resolution.

Why it is Different from Other Tools (The Value Proposition)

• The Gold Standard for Enterprise Scale: erwin has been a trusted market leader for decades. It is purpose-built to handle massive, hyper-complex enterprise environments (such as Fortune 500 financial or healthcare systems) where a simple flowchart maker or basic database workbench fails.

• Impact Analysis & Risk Reduction: Because of its deep automated lineage tracking and change-comparison tools, architects can safely test modifications and see downstream impacts before executing risky production updates, minimizing downtime and data corruption.

• Bridging Business and Technical Users: It bridges data literacy gaps by providing distinct user access layers—from technical physical schema modeling for database administrators down to read-only browser-based views and business glossaries for executive stakeholders.

10	ERWIN qsns
11	Erwin - Data modeler workspace	is the space where the Tables are created and connected
12	Erwin - Domains	A domain is like a custom datatype an independent model object that you can use to quickly assign properties to an attribute or column
13	Erwin - types of relationships	Identifying relationship. Non-identifying relationship. Subtype relationship. Many-to-many relationship. Recursive relationship.
14	Erwin - which erwin features did you use	1. Name hardening 2. Domains for Data types 3. Naming standards( abbrevations) 4. Fwd & reverse engineering 5. Merge data models 6. complete compare 7. sub type and super type
14.1	Erwin - which feature used to merge the subtype tables to supertype
15	Erwin - Forward and reverse engineering steps	Forward engr steps : Actions > schema > Generate scripts Reverse engnr steps : Actions > reverse engnr > logical / physical > Database (or) script file > connect > ok   https://bookshelf.erwin.com/bookshelf/public_html/2019R2/Content/User%20Guides/erwin%20Help/foward_engineering_schema_generation.html
16	Erwin - Complete compare feature	Complete Compare is a powerful tool that lets you view and resolve the differences between two models, or a model and a database or script file Actions > complete compare wizared > source target models select > compare > final > resolve differenceces
17	Erwin - Naming standards	Use the Naming Standard Editor to create naming standards and develop a glossary that contains glossary words, their abbreviations, and alternate abbreviations. Access the Model Explore> open Naming Standard Editor > Define naming standards for logical and physical models> Create abbreviations
18	Erwin - Name hardening	Name hardening is a mechanism in Erwin Data Modeler that prevents physical model names from changing when logical names change
19	Erwin - querying tool
20	Erwin - subject areas	Click Model, Subject Areas. The Subject Area Editor opens. Click New. A new subject area
21	Erwin - identifying and non identifying relationships differences...........	Identifying : Represented by a solid line, the primary key of the parent migrates to the primary key area of the child entity or table eg : Book & chapter tables , Country and state tables Non-identifying : The child entity is not dependent on the parent entity for its identity and can exist without it .. eg : supplier & product list ,

ERWIN - how maintain versions

 
Two types of model versions exist:

Delta Version: A delta version is created when you initially save a new model or when you save changes to an existing model.

If you do not want to maintain multiple versions, you can clear the Maintain multiple versions check box. If you clear the checkbox, then erwin� Data Modeler does not create a delta version for any incremental save. erwin� Data Modeler updates the current version every time you save the model.

Named Version:

A named version is created from a delta version, or from another named version. A named version represents a milestone in the development of the model, or at least a version that you want to keep indefinitely. When you save the changes in a named version, the changes are saved in the same version.

The Based upon field in the Edit Catalog pane displays the version number from which the Named version is created.

=========================================================================

Create a Delta Version

You create a delta version when you save a model initially or when you incrementally save an existing model.

Follow these steps:

1. Click File, Mart, Open >
   > The Open Model dialog opens. > Select a model and click OK.
   > The model opens.
   >Make necessary changes to the model.
   >Click File, Mart, Save.
   
   
1. A delta version of the model is created with the incremental changes.

=========================================================================Create a Named Version

A named version of a model represents a milestone in the development of the model. You create a named version to keep that model version indefinitely.

Follow these steps:

1. Click File, Mart, Catalog Manager   .

   > The Catalog Manager opens. > Select a model version,
   >right-click and click Mark Version. 

1. A named version is created with a default name.
   > Edit the name of the named version (new name ) and press enter.

3. A new named version is created in the catalog.

=========================================================================

Compare Model Versions

Compare two model versions of a data model to view the differences between them.

Follow these steps:

1. Click File, Mart, Catalog Manager.  > The Catalog Manager dialog opens.
   Hold the Ctrl key and select two model versions of a model and
   > click Version Compare. >Click Compare.

3. The Complete Compare wizard opens. >.

4. The Resolve Difference dialog opens. Review the differences and use the tools on the toolbar to work with and manage the changes. > Finish  > Click Close.

6.  =========================================================================