Configuring the Oracle BI Repository Connections
Installing and Setting Up Oracle BI Applications
4-75
Figure 42
BI Repository Physical Layer in Oracle BI Administration Tool
The Oracle Data Warehouse physical database has two predefined connection pools:
Oracle Data 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 Data Warehouse Repository Initblocks Connection Pool.
You need to
configure the Oracle Data 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.
For information about configuring configuration pools, see
Section 4.15.2, "How to
Configure the Oracle BI Repository Connections"
.
You can also set up dynamic data source names, which allow an Administrator to set
one instance of Analytics server to connect to different data warehouses depending on
the user. For more information about how to set up dynamic data source names, see
Section 4.15.4, "How to Configure Dynamic Data Source Names"
.
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 data warehouse database.
You configure Static variables in Oracle BI Administration Tool using the Variable
Manager (choose Manage, then Variables, and expand the Variables\Static node). For
more information about configuring Static variables, see
Section 4.15.3, "How to
Configure Oracle BI Repository Variables"
.