Oracle® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows > Configuring the DAC Server >

Process of Configuring the Connection Between the DAC Server and DAC Repository


Follow this procedure to configure the connection between the DAC server and the DAC repository.

To configure the connection between the DAC server and the DAC repository

  1. Launch the DAC client.
  2. From the menu bar, click Tools > DAC Server Management > DAC Server Setup.

    A confirmation dialog box asks you to confirm that you want to configure the DAC repository connection.

  3. Click Yes.

    The Server Configuration dialog box appears.

    Click for full size image
  4. In the Repository Connection Information tab, enter the appropriate information, as described below.

    NOTE:  The DAC repository details that you specify here must match the DAC repository details that you specified in the following tasks:

Field
Description

Connection type

Select the type of database in which you are storing the DAC metadata repository. Depending on what type you select, the connection details below change (see Connection fields below).

Connection fields (for example, Instance, TNS Name, Connection string/Database name.

Specify connection details for the database that stores the DAC metadata repository.

  • If you select Oracle (Thin), you are prompted below for an Instance (for example, mymachinename).
  • If you select Oracle (OCI8), you are prompted below for a TNS name (for example, mymachinename@host.com).
  • If you select DB2, you are prompted below for an Connection string.
  • If you select MYSQL, you are prompted below for a Database name (for example, mydacdatabase).

Table owner name

The database table name or instance (for example, DAC).

Password

The database or instance password (for example, DAC).

  1. Click Test Connection to make sure the DAC repository connection works.
  2. Click Save.
Oracle® Business Intelligence Applications Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.