Using Database Relationship Analyzer physical data models

You can create physical data models based on a group of related tables defined in an Optim™ Database Relationship Analyzer metadata database.

The Optim Database Relationship Analyzer group discovery process allows you to create a group that references related tables in a relational database schema. To use the group in a Database Relationship Analyzer physical data model, you must define an Optim Database Relationship Analyzer connection profile that specifies the Optim Database Relationship Analyzer metadata database and metadata schema that includes the group.

To define a Database Relationship Analyzer physical data model, select the Optim Database Relationship Analyzer connection profile that includes the group, select the group that will provide the tables for the model, and then select the connection to the database that contains the tables defined in the group.

Setting up Optim Database Relationship Analyzer

To use Optim Database Relationship Analyzer in Optim Designer, do the following steps:

  1. Install the Optim Database Relationship Analyzer server and perform the group discovery process for relational data you will use in Optim Designer.
  2. Use the Data Source Explorer to define a data source connection to the Optim Database Relationship Analyzer metadata database.
  3. Use the Optim preferences to define a connection profile based on the Optim Database Relationship Analyzer data source connection and a metadata schema. You can define a connection profile only for a metadata database created with Optim Database Relationship Analyzer version 1.1.1 or later.