How to Reverse Engineer a Database or a Script › How to Reverse Engineer a Model from a Database or a Script › Select Model Details

Select Model Details

The New Model dialog is displayed when you create a model and when you reverse engineer a database or a script. In addition, the dialog is displayed during Complete Compare, when you select to reverse engineer the right model. The first step for creating a model is to select the type of model you are creating and the target database you plan to use. Your selection enables the application to display editors for the objects relevant to the selected type of model and database.

If you are creating a model, start from Step 1 of this procedure. If you are reverse engineering, start from Step 4.

Follow these steps:

1. Open CA ERwin Data Modeler.
2. (Optional) Complete the following steps to connect to a Mart:
   1. Click Connect to Mart.

      The Connect to Mart dialog opens. You can connect to a Mart only if you have bought CA ERwin DM Workgroup Edition.

   2. Enter your credentials and click Connect.

      Your user name is displayed on the status bar, indicating that you are connected to a Mart.

3. Click File, New Model.

   The New Model dialog opens.

4. Complete the following fields to create a model:
   1. Select Logical, Physical, or Logical/Physical.
   2. If you have selected Physical or Logical/Physical, select the target database and its version number.
   3. Select a template for Template. Click OK.

      A new blank model appears. You can select a template that includes a theme. If you are reverse engineering, the theme is applied to the objects in the new model. If you are creating a model, the theme is applied as you create the model objects.

5. Complete the following fields to create a model that is same as the template model:
   1. Select Match template.
   2. Click Browse Files or Browse Mart and select a template model from your local computer or Mart. Click OK.

      A new model, which is of the same type as the template model is created. The objects in the selected template model appear in the new model. The target database and the theme of the template model are applied to the new model. Similarly, if you are reverse engineering, the new model inherits the same type, target database, and the theme.

6. Complete the following fields to create a model that is based on a template and matches the selected target server and model type:
   1. Select Physical or Logical/Physical.
   2. Select Match template target server.
   3. Click Browse Files or Browse Mart and select a template model from your local computer or Mart. Click OK.

      The objects in the selected template model appear in the new model, as appropriate for the selected database and model type. The theme of the template model is applied to the new model.

Back to Top