Oracle^® Business Intelligence Applications Installation and Configuration Guide > Configuring the Oracle BI Repository for Oracle Business Analytics Warehouse >

Configuring the Oracle BI Repository Connections

You need to configure the Oracle BI repository variables and connection pools to connect to your database.

Oracle BI repository uses three databases defined in the Physical layer:

• Oracle Data Warehouse
• Oracle EBS OLTP
• Siebel OLTP

The Oracle Business Analytics Warehouse physical database has two predefined connection pools:

• Oracle Business Analytics Warehouse Connection Pool. The Oracle Business Analytics Warehouse Connection Pool is the main connection pool in the Oracle BI repository. You need to configure this connection pool to connect to your physical data warehouse. The connection is used by the session initialization blocks. You can use this connection pool to set up a dynamic data source name.
• Oracle Business Analytics Warehouse Repository Initblocks Connection Pool. You need to configure the Oracle Business Analytics Warehouse Repository Initblocks Connection Pool to connect to the your physical data warehouse. The connection is used by the repository level initialization blocks. Repository level initialization blocks cannot be configured to use the dynamic data source name.

The Siebel OLTP and Oracle EBS OLTP databases have two predefined connection pools each. The actual databases in the RPD will depend on the modules licensed by the customer. The connection pools and their functions within each database are listed below.

You also need to configure the following Static variables:

• OLAP_DSN. The value of the OLAP_DSN static variable is set to the data source name for the warehouse database.
• OLAP_USER. The value of the OLAP_USER static variable is set to the database user name for the warehouse database.
• OLAPTBO. The value of the OLAPTBO static variable is set to the database table owner for the warehouse database.

The Siebel OLTP and Oracle EBS OLTP databases have two predefined connection pools each. The actual databases in the RPD will depend on the modules licensed by the customer. The connection pools and their functions within each database are listed below.

• Oracle EBS OLTP:
  • Oracle EBS OLTP DBAuth Connection Pool. The Oracle EBS OLTP DBAuth Connection Pool is used if database authentication is required.
  • Oracle EBS OLTP Connection Pool. The Oracle EBS OLTP Connection Pool is used to connect to the Oracle EBS OLTP system.

    You also need to configure the following Static variables:

  • ORA_EBS_OLTP_DSN. The value of the ORA_EBS_OLTP_DSN static variable is set to the data source name for the Oracle EBS OLTP database.
  • ORA_EBS_OLTP_USER. The value of the ORA_EBS_OLTP_USER static variable is set to the database user name for the Oracle EBS OLTP database.
• Siebel OLTP
  • Siebel OLTP DBAuth Connection Pool. The Siebel OLTP DBAuth Connection Pool is used if database authentication is required.
  • Siebel OLTP Connection Pool. The Siebel OLTP Connection Pool is used to connect to the Siebel OLTP system.

    You also need to configure the following Static variables:

  • OLTP_DSN. The value of the OLTP_DSN static variable is set to the data source name for the Siebel OLTP database.
  • OLTP_USER. The value of the OLTP_USER static variable is set to the database user name for the Siebel OLTP database.

To configure the Oracle Data Warehouse, Oracle EBS OLTP, and Siebel OLTP physical databases

1. Using the Oracle BI Administration Tool, open the OracleBIAnalyticsApps.rpd file in the $SAHome\OracleBI\Server\Repository folder.
2. In the Physical pane, double-click the Oracle Data Warehouse object.
3. In the Database list, click your database type.
4. Save the repository.
5. Click Yes to Check Global Consistency.
6. Repeat steps 1-5 for the Oracle EBS OLTP and Siebel OLTP data warehouse objects
7. Click OK when the Warnings are displayed.

To configure the Oracle BI repository connection pools

1. Using the Oracle BI Administration Tool, open the OracleBIAnalyticsApps.rpd file in the $SAHome\OracleBI\Server\Repository folder.
2. In the Physical pane:
   1. Double-click the Oracle Data Warehouse Connection Pool within the Oracle Data Warehouse.
   2. Repeat step 2 for the other connection pools listed above.
3. Repeat Step a through Step d for the other connection pools listed above.
4. Save the repository.
5. Click Yes to Check Global Consistency.
6. Click OK when the Warnings are displayed.

To configure the Oracle BI repository variables

1. Using the Oracle BI Administration Tool, open the OracleBIAnalyticsApps.rpd file in the $SAHome\OracleBI\Server\Repository folder.
2. On the Manage menu, click Variables.
3. In the Variables Manager window, click Static.
4. Edit the OLAP_DSN, OLAP_USER, and OLAPTBO variables, and close the Variables Manager window.
5. On the Manage menu, click Security
6. In the Security Manager window, click Users, and then:
   1. Double-click on Administrator user, and type a new password.
   2. Double-click on SADMIN, and type a new password.
   3. Save and close the Security Manager.
7. Save the repository.
8. Click Yes to Check Global Consistency.
9. Click OK when the Warnings are displayed.