Creating a Database Relationship Analyzer physical data model

You can use the New Database Relationship Analyzer Physical Data Model wizard to create a physical data model based on a group of related tables defined in an Optim™ Database Relationship Analyzer metadata database.

The Optim Database Relationship Analyzer metadata database must be have a connection profile defined in the Database Relationship Analyzer preferences.

The source database that contains the tables selected in the Database Relationship Analyzer group must have a connection profile defined in the Data Source Explorer.

To create a Database Relationship Analyzer physical data model:
  1. In the Data Project Explorer, right-click the Data Models folder and click New > Database Relationship Analyzer Physical Model. The New Database Relationship Analyzer Physical Data Model wizard opens.
  2. Complete the steps of the wizard.

    You must select a Database Relationship Analyzer connection profile and a Database Relationship Analyzer group that will provide relationship mapping for the model. You must also select and connect to the source database for the model. The source database must contain all tables in the Database Relationship Analyzer group selected for the model.

The physical data model is created and displayed in the Data Models folder.