See how erwin Modeling acts as an information hub to share the core data definitions, business rules, and data structures across your organization – placing erwin at the Center of Data Management.

erwin Data Modeling provides a collaborative data modeling environment to manage enterprise data through an intuitive, graphical interface. It can help you:

  • Manage your complex enterprise data infrastructure
  • Increase quality and reduce maintenance and development costs
  • Align business with IT by documenting key data definitions and rules
Download a Free Trial

Key Features

erwin Data Modeler is the industry-leading data modeling solution that enables organizations to discover, design, visualize, standardize and deploy enterprise data through an intuitive, graphical facility built on industry standards and best practices. erwin Data Modeler combines a business and technical view of data assets through integrated conceptual, logical and physical models to provide a detailed foundation for collaboration between data stakeholders across the enterprise. erwin Data Modeler enables organizations to lower data management costs, optimize innovation and mitigate the risks associated with complex data driven initiatives by breaking down technology and organizational silos, deploying reusable design and analysis standards and governing the data modeling and definition process.

Visualization of Complex Data Structures

erwin provides a simple, graphic display to visualize complex database structures in an easy-to-manage interface.

Design Layer Architecture

erwin offers flexibility to create multiple model layers, from logical to physical, to even higher-level models. Users can create logical and physical models that are completely separate, or create logical and physical models that are linked, allowing you to choose the implementation style best suited to your needs.

Standards Definition

Reusable standards improve an organization’s ability to develop and manage their information assets in a cost and time-effective manner. erwin supports the definition and maintenance of standards through reusable model templates, the Domain Editor, the Naming Standards Editor and the Datatype Standards Editor.

Large Model Management

erwin helps you manage large enterprise-level models through subject areas and diagrams. These graphical views and model visualizations facilitate information exchange and collaboration among the different stakeholders in an organization. In addition, advanced features such as auto-layout, on-demand UI components, and “bird’s-eye” navigation allow you to easily visualize large models.

Complete Compare

This powerful feature automates complete bidirectional synchronization of models, scripts and databases, compares one item with the other, displays any differences and permits bidirectional selective update. If model changes are targeted for a database, erwin can automatically generate a database ALTER script, as desired.

Database Design Generation

erwin allows you to create database designs directly from visual models, increasing efficiency and reducing errors. Industry-leading database support includes optimized referential integrity trigger templates and a rich cross-database macro language, allowing modelers to customize triggers, scripts and stored procedures. Customizable templates facilitate the generation of a model’s complete physical design and definitions.

Data Warehouse and Data Mart Design

The performance, usability and value of a data warehouse are determined by its underlying design. erwin supports data warehousing-specific modeling techniques (such as Star Schema and Snowflake dimensional modeling), optimizing the data warehouse for your performance and analysis needs. It also captures and documents a rich set of information about the warehouse including data sources, transformation logic and data management rules.

“Bulk” Metadata Editing

The Bulk Editor provides cross-object, multi-instance metadata updates in a single, spreadsheet-style interface allowing for bulk updates, exports to Excel, and metadata queries.

Reporting & Publication

The Report Designer’s intuitive point-and-click interface can create HTML and text-based reports for both diagrams and metadata.

Integration & Metadata Exchange with Other Tools

It’s easy to integrate erwin with other projects and tools with import or export from a wide variety of sources, including BI tools, MDM hubs, other data modeling tools, Extract, Transform, Load (ETL) tools and Unified Modeling Language (UML) tools.

Read the full Data Sheet (PDF) for a more detailed list of features.

Additional Resources

erwin Partner Sandhill Consultants has developed the EM-SOS!™ (Enterprise Modeling Set of Standards) Framework. This framework, designed for erwin Data Modeler, streamlines the development of business driven data definitions and models, enabling their reuse, preventing redundancy and providing enforcement of corporate standards. To learn more, visit http://www.sandhillconsultants.com/emsoserwin.asp or read their EM-SOS! 2.0 Brochure.


Logical Data Model

Complete Compare


Operating System Support

erwin Data Modeler Standard Edition requires that you have the 32-bit or 64-bit version of one of the following systems of the latest release installed:

  • Microsoft Windows Vista SP2
  • Microsoft Windows Server 2008 SP2, R2
  • Microsoft Windows 7 SP1
  • Microsoft Windows 8.1
  • Microsoft Windows 10
  • Microsoft Windows Server 2012, R2
  • Microsoft Windows Server 2016

erwin Data Modeler Standard Edition supports the following database environments:

  • IBM DB2
  • IBM IDS (Informix)
  • MySQL
  • ODBC
  • Oracle
  • Progress
  • SAS
  • MS SQL Server
  • SAP ASE
  • SAP IQ
  • Teradata

erwin Data Modeler Standard Edition supports the following data sources for import:

  • Apache Hadoop Hive
  • Apache Hive Metastore
  • Cloudera Enterprise (Hadoop Hive)
  • Cloudera Impala (Hadoop Hive)
  • DataStax Enterprise (Hadoop Hive)
  • Hadapt Hadoop Hive
  • Hortonworks Hadoop Hive
  • MapR Hadoop Hive
  • IBM Netezza Database (via JDBC)
  • Pivotal Greenplum Database (via JDBC)

Other Products

Workgroup Edition

Our industry leading data modeling solution with collaborative governance capabilities for you data definition and modeling processes. It provides change management, conflict resolution, versioning, security and standardization for multi-user modeling. Through a central repository, model assets can be inventoried and re-used across the organization.

Learn More

Navigator Edition

Data models are relevant to many different audiences across the organization. The ability to permit others to visualize and analyze the details of model metadata is critical to successful collaboration of diverse project teams.

Learn More

Web Portal

A simple, customizable, web-based interface that allows both business and technical users across the organization to easily visualize the important metadata information that is stored in erwin Data Modeler and beyond.

Learn More

Data Governance

Building on a foundation of visual and comprehensive erwin data models, organizations can use erwin Data Governance to author and deploy business glossaries, define semantic and data flow lineages, standardize and document data sources and enable self-service data discovery in support of their enterprise data governance program.

Learn More

Safyr Option for ERP

erwin Safyr Option extracts metadata from a variety of ERP applications — including SAP, Salesforce, and Oracle. Translate often-challenging naming conventions in these systems into user-friendly values for modelers to search, browse and subset this metadata prior to creating erwin data models.

Learn More

CloudCore™

Data modeling and enterprise architecture integrated in the cloud for greater collaboration, agility and quality of enterprise data and architecture assets. erwin CloudCore™ combines erwin Modeling and Corso Agile EA in a single, integrated and collaborative platform.

Learn More