Data Model Import wizard

Use the Data Model Import wizard to import data models from another tool to a project in the Data Project Explorer.

Select page

Use this page to specify the data model to import and where you want the generated model to be saved in the Data Project Explorer. The text box provides additional information about the model format that you select.

Model format
Select the format of the model that you want to import.
Model
Specify the model to import. Click Browse to see the available models for the model format that you specified.
Target project
Specify the project that you want to import the data model to. Click Browse to see the available projects in the Data Project Explorer.
Model type
Specify whether you want to import the data model as a physical data model or a logical data model. The Auto detect option identifies the model type and generates the data model to import according to the model type set in the source tool.
File name
Type a name for the model file that you want to import and save to the target project.

Options page

Use this page to specify the options for importing the data model. The text box provides additional information about the options that you can set for the model format that you selected.

Options and Values
This table lists the options for the model in the first column. You can set the values for these options in the second column. The values that are displayed are the default values for each option.
Validity check
Select the type of validity check that you want run on the model file that is generated during the import. The validity check verifies that the data model follows the semantic rules for the model format. The default is Basic validity check. You should select No validity check only if you are sure that the model is valid.
Target database
For physical data models, select the target database for the generated model.
DDL

For CA ERwin or CA Gen physical data models targeting DB2 for z/OS or DB2 for Linux, UNIX, and Windows only: Select a DDL script that contains additional database-specific properties; for example, storage properties. The DDL script must follow correct DB2 for z/OS or DB2 for Linux, UNIX, and Windows syntax.

When you select a DDL script or set of scripts from the file system, the wizard merges the information in the source model with the information in the DDL scripts when it creates the physical data model in the workbench. To select a single DDL script, choose the Select a DDL file option. To select multiple DDL scripts, choose Select a DDL file directory, and all of the DDL scripts that are contained in that directory are used during the import.

Select Overwrite model properties from DDL to use the properties in the DDL scripts instead of the properties in the imported data model, if there are conflicts.

Select Generate DDL on finish to optionally generate a DDL script that contains all of the merged imported properties. The DDL script is saved in the target data design project for modification as needed.

If there are errors in either the model or the DDL scripts, they are shown on the Summary page and the Finish button is disabled.

Correct any errors and verify the options that you specified, and then click Finish to import the data model.


Feedback