erwin® Data Modelerby Quest®
Building the foundation for an optimized data journey

At a glanceerwin Data Modeler by Quest is an awardwinninggraphical data modeling solution helping leadingorganizations worldwide find, visualize, design, deploy
and standardize highquality enterprise data assets.
The gold standard for more than 30 years, erwin
Data Modeler has helped thousands of organizations
reduce costs and enable faster time to value when
designing, developing and delivering the data
sources their businesses rely on each day.

1. Data governance and complianceerwin Data Modeler serves as a foundation toestablish robust data governance frameworks toensure data quality, consistency, and compliancewith regulations. It provides the necessary tools to
integrate data from diverse sources and standardize
data definitions and formats. This approach mitigatesrisk, ensures regulatory compliance, and promotes
consistent data usage across the organization,
thereby reducing data silos and improving data
accessibility and interoperability.

2. Migration and modernization

erwin Data Modeler continues to invest in development toprovide the solutions that the market needs to optimize their datalandscape with the help of data modelling.

Solution focus
In a data driven world, effective data management
is paramount for any organization aiming toharness the full potential of its data assets. erwin
Data Modeler stands at the forefront, providing
comprehensive solutions that address the criticalchallenges that organizations face every day in four
major areas:

Ensuring accurate mapping, transformation andintegration of data across legacy systems andnew platforms, erwin Data Modeler supports a wide
variety of databases and cloud environments. It
offers a comprehensive view of the data architecture
to identify dependencies and optimize the migration
process. This reduces the risk of data loss, minimizes
downtime, and ensures data integrity throughout
the transition, directly contributing to more efficientand effective modernization projects. As a result,businesses can leverage new technologies andinfrastructures with confidence and agility.

3. Improved data visibility and understanding
erwin Data Modeler allows users to build
comprehensive data models that offer clear,visual representations of data structures andrelationships. This enhances data understanding
and communication across stakeholders, enabling
better decisionmaking and fostering collaboration.

4. Efficiency database design and optimization
To enhance database performance across anOrganization’s database landscape, erwin Data
Modeler enables efficient database design,development and optimization through advanced
modeling and validation tools. This also helps
to reduce development time and cost, ensurescalability and helps build more easily maintainabledatabase architectures.

Benefits:• Accelerate data-centric innovation
by mastering data architectures andinfrastructure• Heavily reduce the time needed foranalysis, development and maintenanceby increasing design quality andconsistency• Automate the documentation andmigration of schema between diverse
database technologies and deployment
platforms for scalability and adaptability
with new technologies• Centralize model development forconsistency, governance and maximum
reuse• Accelerate data source analysis andtarget schema design cycles in BI/analytics• Master data management & data
warehouse/data lake initiatives• Simplify integration and improveenterprise collaboration by reducing silos
with design implementation and metadatamanagement standards“I wouldn’t hesitate inrecommending erwin, that’sfor sure. It’s an easy-to-use,comprehensive modeling tool..
Data Modeler at government agency”

erwin Data Modeler product offerings
erwin Data Modeler Standard Edition is a
powerful yet easy-to-use tool designed forindividual users and small teams who need tocreate, visualize and manage database structures.
It offers comprehensive capabilities for database
design, including support for logical, physicaland conceptual modeling, all within its intuitive
interface. Ideal for organizations looking for a costeffective solution, Standard Edition helps to ensure
consistency, improve data governance and helps
users document and optimize their databases
effectively.
erwin Data Modeler Workgroup Edition is tailored
for teams and organizations that are looking foradvanced collaboration and governance features.
Building upon the capabilities of the Standard
Edition, Workgroup Edition includes version control,model change management, and role-based accessto ensure that teams can collaborate seamlessly
while maintaining data integrity and compliance.
This edition is perfect for organizations that needto coordinate efforts across multiple users andprojects, providing a centralized repository for
managing and sharing data models across theenterprise.
erwin Safyr Option extracts and converts datafrom ERP, CRM and other enterprise applications
for accurate modeling and analysis, and for the
consolidation of duplicate systems.

erwin ER360, a self-service visualization andcollaboration portal provides read-only accessto data models promoting collaboration among
stakeholders, enhancing data understanding anddata governance and accelerating data-driven
decision making through improved data-businessalignment.
erwin Data Modeler Mart on Cloud is a pure SaaS
service. Quest will build host instances in the cloud,ensuring that customer data is secure and private.
This allows for enhanced collaboration, DevOps
capabilities via Mart and web-based model andrepository administration, to name a few benefits.

Integration capabilities
erwin Data Modeler offers extensive support for anarray of database platforms, making it a versatile toolfor organizations with diverse data environments.
Whether you’re working with traditional relational
databases like Oracle, SQL Server and DB2, ormodern NoSQL and cloud-based databases suchas MongoDB, Cassandra and Amazon Redshift,erwin Data Modeler provides robust capabilities
for designing, managing and optimizing your dataassets. This broad compatibility ensures that you
can create consistent, high-quality data models
across different systems, simplifying complex data
landscapes and enabling seamless integration andmigration efforts.

SYSTEM REQUIREMENTS
Verify that you have installed one of the following
operating systems:• Microsoft Windows 10• Microsoft Windows 11• Microsoft Windows Server 2016
• Microsoft Windows Server 2019
• Microsoft Windows Server 2022
NOTE: Running the erwin API in a 64-bit environment
requires some changes to the workstation registry. For more
information about changing the registry, see the erwin Data
Modeler WE Implementation and Administration Guide.

The following requirements must be met orexceeded for erwin Data Modeler to install andrun correctly:• Windows-based work station• 16 GB RAM• 100 GB of disk space
NOTE: The minimum screen resolution supported is 1024 x768. Also, ensure that your display settings are always set
to 100%. If your screen resolution is less than the minimum
supported, some portions of the screen may not be visible.

For full details on system requirements, please
visit the erwin Bookshelf here.

Which edition makes sense for you?
Now let’s take a look at a comparison of the feature sets of the different versions of erwin Data Modeler so thatyou can determine which one makes the most sense for the particular needs of your organization.

erwin Data
ModelerStandard Edition

erwin Data
ModelerWorkgroup
Editionerwin Data
Modeler
Navigator

Visualization of ERD data structures✓✓✓

Visualization of JSON data structures✓✓✓

Reverse-engineering of existing databases/DDLscripts of ERD and NoSQL✓✓

Schema generation to database/DDL script✓✓

Native, JDBC and ODBC support for a wide range ofcloud and on-prem database platforms✓✓

Create, update and delete model metadata✓✓

Search and browse model metadata✓✓

Transform and/or de-normalize ERD structures toJSON like documents✓✓

Model and database comparison andsynchronization✓✓

Ability to save models in a variety of formats✓✓

Model publication and metadata reporting in PDF,
HTML and text-based reports through intuitive pointand-click interface✓✓✓

Compatible with either 64-bit Microsoft Windows
operating systems✓✓✓

Complete naming and data-type standards support/definition✓✓

Node-locked (workstation) or concurrent licensing✓✓

Feature✓✓erwin DataModelerStandard Editionerwin DataModeler
Workgroup
EditionFile-based model exchange (import/export)
options to/from a wide variety of data management
environments, including erwin Data Intelligence byQuest Software✓✓

RE Scheduler to automate the offline reverseengineering of databases into data models✓✓

ODBC query tool for creating and running custom
model and metadata reports✓✓

FeatureRepository-based model storage and metadata
sharing capability available on-prem or SaaS
subscription in the cloud✓Multi-user collaboration and conflict resolution✓

Change management and version control✓

User permission and security management controls✓

Full configurable modeling compliance feature thatassures model quality and completeness✓Business Glossary to associate business terms withmodel artifacts to provide business context and alignwith data governance✓Centralized storage and reuse of naming standards
in the modeling repository✓

Modern web-based repository administration✓One-click push of data modeling data definition
language (DDL) and request to GitHub/Git repository
via Mart✓Automated round-trip exchange and sync of data
models and data intelligence artifacts betweenerwin Data Modeler and erwin Data Intelligence✓

Harvesting to erwin ER360✓erwin Data
ModelerNavigator✓Why erwin Data Modeler?

About Quest• Support of any data, anywhere – Take a unified
approach to harmonizing platform inconsistencies
and delivering a single source of the truth forenterprise business data.

Quest creates software solutions that make thebenefits of new technology real in an increasingly
complex IT landscape. From database and systems
management, to Active Directory and Office 365
management, and cyber security resilience, Quest
helps customers solve their next IT challenge now.
Quest Software. Where next meets now.

• Self-service discovery – Extract information
locked in off-the-shelf, cloud-based systems
without the need for specialized knowledge ofresources.
• Automated generation of erwin data models –Automatically generate native models with erwin
Data Modeler, integrating ERP/CRM application
metadata with other organizational data toeffectively visualize data assets.
• Easy browsing and understanding – Complex,
technical infrastructures ofthese systems canbe browsed and understood more easily withtechnical names translated into intuitive, userfriendly business terms.
• Reduced data management silos – Break down
the data management silos that naturally occur
when new technology or new deployment models
are adopted.

Quest © 2024 Quest Software Inc. ALL RIGHTS RESERVED.

Quest, Quest Software and the Quest logo are trademarks of Quest Software Inc. For a complete listof Quest marks, visit https://www.quest.com/legal/trademark-information.aspx. All other trademarks areproperties of their respective owners.
Datasheet-erwin-DataModeler-RS-93392