Importing Individual ERwin Files

PowerDesigner provides a wizard to help you import individual ERwin files.

  1. Select File > Import > ERwin File.
  2. Browse to the directory that contains the ERwin file, select it, and then click Open.
  3. If the ERwin file contains only a physical model, you will be prompted to choose whether to import references as triggers. Select Yes or No to begin the import.

    Alternatively, if the ERwin file contains a logical model or a combined logical and physical model, the ERwin model import dialog box opens:



    The options available depend on the type of ERwin model that you are importing. PowerDesigner supports data modeling at the conceptual, logical, and physical levels. The full set of options is as follows:

    • A conceptual data model can be created when you are importing an ERwin logical model. It provides a platform-independent representation of a system, giving an abstract view of its static data structures, and permitting real normalized data structures with many-to-many and inheritance relationships.

    • A logical data model can be created when you are importing an ERwin logical model. It allows you to resolve many-to-many and super/sub-type relationships, de-normalize your data structures, and define indexes, without specifying a particular RDBMS.

    • A physical data model can be created when you are importing an ERwin physical model. It is a representation of a real database and associated objects running on a server with complete information on the structure of the physical objects, such as tables, columns, references, triggers, stored procedures, views, and indexes.

    Select the checkbox for each type of model that you want to create.

  4. If your ERwin model contains a logical model, and you want to create a conceptual data model, then you can choose to merge identical data items. This is a powerful metadata management technique that is not available in the ERwin environment.

    For example, your ERwin logical model may contain multiple entities that contain an attribute "address". By default, PowerDesigner will create a separate data item for each of these entity attributes. However if you select the Merge identical data items checkbox, then a single data item will be created, and adjustments to it will automatically cascade down to all the associated entity attributes.

  5. If your ERwin model contains a physical model, then you can choose whether to Implement referential integrity by triggers.
  6. Click OK to begin the import. When the process is complete, the imported models will appear in the Browser.