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

Database Developers

Enterprise Architect supports a range of features for the development of databases, including modeling database structures, importing database structures from an existing database and generating DDL for rapidly creating databases from a model.



See Also

Create Logical Data Models

With Enterprise Architect the Database developer can build database diagrams using the built-in UML Data Modeling Profile

This supports the definition of Primary and Foreign keys, cardinality, validation, triggers, constraints and indexes

Logical Data Model

Generate Schema

By using Enterprise Architect's DDL generation function the Database Administrator can create a DDL script for creation of the database table structure from the model

Enterprise Architect currently supports:

  • JET-based databases
  • DB2
  • InterBase
  • Informix
  • Ingres
  • MySQL
  • SQL Server
  • PostgreSQL
  • Sybase Adaptive Server Anywhere and Adaptive Server Enterprise, and
  • Oracle 9i, 10g and 11g


Reverse Engineer Database

Using an ODBC data connection the Database Administrator can import a database structure from an existing database to create a model of the database

Generating the model directly from the database enables the DBA to quickly document their work and create a diagrammatic account of a complex database through the graphical benefits of UML

Reverse Engineering


Example Data Model Diagram


Learn More: