Book a Demo

Please note : This help page is not for the latest version of Enterprise Architect. The latest help can be found here.

Prev Next

Create a Data Model from a Model Pattern

The easiest way to create a Data Modeling workspace is to use the predefined Database Model Patterns, available through the Model Wizard. Enterprise Architect provides a Pattern for each DBMS supported by the system.


Display the Model Wizard window using any of the methods outlined here.

In the Model Wizard window, select the 'Model Patterns' tab. In the 'Technology' panel, select 'Database'.


Design > Model > Add > Model Wizard

Context Menu

Right-click on Package | Add a Model Using Wizard

Keyboard Shortcuts



Browser window caption bar menu | New Model from Pattern

Create a Data Model



See also

Add to Package

Displays the name of the selected root Package.


Click on 'Database'.


If necessary, expand the Database Engineering group of Patterns.

Click on the checkbox against each Database Management System you are supporting in the model.


Click on this button to select the checkboxes for all Database Engineering model types and the Entity Relationship diagram, to include them all in the model.


Click on this button to clear all selected checkboxes so that you can re-select certain checkboxes individually.


Click on this button to add to the Browser window the Packages and diagram for each Database Management System you are modeling.

What each Data Modeling Pattern provides

  • A summary diagram of the model
  • A Report Specification Artifact element (on the summary diagram) that can be used to quickly document the data model
  • A Package for each of the Logical and Physical models
  • Within the Physical Model Package, a predefined hierarchy of sub-Packages, one for each object type supported by the DBMS being modeled (such as Tables, Views, Procedures and Functions); these automatically organize the database objects as they are added
  • The DBMS type for the workspace
  • A default owner
  • A Data Modeling diagram in each Package with the connector notation set to IDEF1X


  • Once a data modeling workspace has been created, you can begin to develop your model in one of two ways:
         -  Through the Database Builder, which is a purpose-built view that supports database modelers
         -  Through the Browser window and diagrams, which is the traditional method that might suit users
             who are experienced UML modelers

Learn more