Adding Database Connections

When you create a database connection, it is appended to the list in the Database Manager dialog box.

  To add a database connection

  1. In EPM Workspace, select Explore. Then select Tools, then Database Connection Manager.

  2. Click New.

  3. In Database Connection Properties, enter a Database Connection Name.

  4. Select a data source Type.

  5. The remaining values will differ, based on the data source selected. See Table 2 to view values that display for each data source.

  6. To add application and database names, click, Application icon, and make your selections. See Selecting an Application and Database Name.

    Note:

    The Application Lookup button displays a tree view of the applications and corresponding databases; the applications are listed as parents and the databases are listed as children. You can search on an application or database. For data sources that are not associated with a database, only applications are listed.

  7. Click OK.

  8. The database connection profile is appended to the list in Database Connection Manager Dialog.