Defining an Optim Database Relationship Analyzer connection profile

You can use a data source connection created in the Data Source Explorer to define an Optim™ Database Relationship Analyzer connection profile.

Before you can define a data source in an Optim Database Relationship Analyzer connection profile, the Optim Designer machine must be connected to the Optim Database Relationship Analyzer metadata database.

You can define a connection profile only for a metadata database created with Optim Database Relationship Analyzer version 1.1.1 or later.

To define a data source connection as an Optim Database Relationship Analyzer connection profile:

  1. From the Optim Designer menu, click Window > Preferences to open the Preferences window.
  2. In the Preferences window options list, expand the Optim node and select Database Relationship Analyzer. The Database Relationship Analyzer Preferences page opens.
  3. On the Database Relationship Analyzer Preferences page, click Add. The Add a Database Relationship Analyzer Connection Profile window opens.
  4. Select a listed data source connection. After Optim Designer retrieves the schemas from the data source, the Choose a schema for the selected profile list is available.
  5. Select an Optim Database Relationship Analyzer metadata schema.
  6. Click Add to return to the Database Relationship Analyzer preferences page. The page will list the connection and metadata schema selected in the Add a Database Relationship Analyzer Connection Profile window.
  7. Click Apply or OK to save the Optim Database Relationship Analyzer connection profile.