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:
- From the Optim Designer
menu, click to open the Preferences window.
- In the Preferences window options list, expand the Optim node
and select Database Relationship Analyzer. The Database Relationship Analyzer Preferences page opens.
- On the Database Relationship Analyzer Preferences page,
click Add. The Add a Database
Relationship Analyzer Connection Profile window opens.
- 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.
- Select an Optim Database
Relationship Analyzer metadata schema.
- 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.
- Click Apply or OK to
save the Optim Database Relationship
Analyzer connection profile.