Configuring the Oracle BI Repository Connections
4-78
Oracle Business Intelligence Applications Installation Guide for Informatica PowerCenter Users
4.
Use the Database field to specify your database type.
5.
Save the repository.
6.
Click Yes to Check Global Consistency.
7.
Repeat steps 1-6 for each OLTP data source that you want to deploy (for example,
Oracle EBS OLTP, PeopleSoft OLTP, and Siebel OLTP).
8.
Click OK when the Warnings are displayed.
4.15.2.2 How to specify connection details for connection pools
You need to specify the connection details for the Oracle Data Warehouse connection
pool, and the connection pool for each OLTP data source that you want to deploy.
To configure the Oracle BI Repository connection pools
1.
Using the Oracle BI Administration Tool, open the OracleBIAnalyticsApps.rpd
file.
For the location of the OracleBIAnalyticsApps.rpd file, see
Section 4.16,
"Deploying the Metadata Repository and Presentation Catalog."
2.
In the Physical pane:
a.
Expand the Oracle Data Warehouse node, and double-click the Oracle Data
Warehouse Connection Pool to display the Connection Pool dialog.
Summary :
4.15.2.2 How to specify connection details for connection pools You need to specify the connection details for the Oracle Data Warehouse connection pool, and the connection pool for each OLTP data source that you want to deploy.
Tags :
oracle,connection,oltp,data,pool,repository,specify,warehouse,deploy,click,want,pools,details