Defining a DB alias

Use the New DB Alias wizard to define a DB alias. A DB alias is a set of specifications that allows Optim™ to identify, locate, and access a particular database. The DB alias also qualifies the names of objects referenced, defined, or accessed using Optim.

Before you define a DB alias, an Optim directory project that will contain the DB alias must be defined in the Data Project Explorer. You must also use the Optim Distributed option in the Optim preferences to define the location of the Optim pr0cnfg utility in the Optim installation.

You must also use the Data Source Explorer to define a connection profile for the database connection. You can only define a DB alias for databases supported by Optim.

Defining a DB alias from a connection profile

When you define a DB alias from a connection profile, the New DB Alias wizard is populated with properties from the connection profile.

To define a DB alias from a connection profile:

  1. From the Data Source Explorer, expand the Database Connections folder.
  2. Right-click the connection to the data source for the DB alias and click Create Optim DB Alias. The New DB Alias wizard opens.
  3. Complete the steps of the wizard.
    • You must select an Optim directory project that will contain the DB alias.
    • You must enter information about the DBMS associated with the DB alias as well as connection information.

Defining a DB alias from the File menu

To define a DB alias from the File menu:

  1. Click File > New > Other. The New wizard opens.
  2. Expand the Optim folder, select DB Alias, and click Next. The New DB Alias wizard opens.
  3. Complete the steps of the wizard.
    • You must select an Optim directory project that will contain the DB alias.
    • You must enter information about the DBMS associated with the DB alias as well as connection information.

Defining a DB alias from an Optim directory project

To define a DB alias from an Optim directory project:

  1. From the Data Project Explorer, expand the Optim directory project that will contain the DB alias, expand the Optim Directory folder, right-click DB Alias, and click New. The New DB Alias wizard opens.
  2. Complete the steps of the wizard.
    • You must enter information about the DBMS associated with the DB alias as well as connection information.