Please note : This help page is for an older version of Enteprise Archtiect. The latest help can be found here.

Data Modeling Toolbox

The Data Modeling Toolbox provides a basic set of elements for database modeling and database design, in conjunction with the UML Data Modeling Profile.

Data Modeling Toolbox page

Image

Detail

See also

datamodelinggroup

In the data model, a:

·Table defines a table
·View represents a database view
·Procedure represents stored procedures
·Sequence represents a database Sequence
·Function represents a database Function
·Database Connection helps you to configure a connection to the database you are modeling, for testing, import and export of schema, and comparison of differences between database and model using the Database Builder
 
When you drop this icon onto the diagram the system prompts you to indicate whether to create the connection for an Access database, a Firebird database or an ODBC database
 
For the first two options, when you click on the OK button the system prompts you to select the file to create the connection to
 
If you select the ODBC database option, the Select Data Source dialog displays; click on the Machine Data Source tab and select the data source (project on a database)
 
After you have defined the data source, when you double-click on the element the Database Builder view opens for the current database model

 

 

Table

Views

Stored Procedures

Sequences

Database Functions

 

The Database Builder

Notes

·To add an element to the currently-open diagram, click on the appropriate icon and drag it into position on the diagram; set an element name and other properties as prompted
·To add a relationship, click on the appropriate icon, then click on the start element in the diagram and drag to the end element

 

Learn more