1. User's Guide
  2. Managing Database Connections
  3. Adding Database Connections

Adding Database Connections

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

To add a database connection:

  1. From Oracle Hyperion Enterprise Performance Management Workspace with the BI Catalog open, select Tools, and then Database Connection Manager.
  2. Click New.
  3. In Database Connection Properties, enter the requested values:
    • Database Connection Name—Name to identify the database connection
    • Type—Data source type
    • Server—Data source server name. For Fusion Apps, enter Essbase_FA_Cluster.
    • User ID—User ID for the data source
    • Password—Password to access the data source
    • Application/Database— Click Add Application button to add application and database names.

      The applications and corresponding databases are displayed in a tree view; the applications are listed as parents and the databases are listed as children. You can search on an application or database.

      For a data source associated with a database, select the database, and then click OK.

      For data sources that are not associated with a database, only applications are listed. For a data source that is not associated with a database, select the application, and then click OK

  4. Click OK to save your changes.