biee11g Configuring an Oracle data source

Note: Changes to the database only need to modify the view layer

Two different ways:

(1) Configure in the Tnsname.ora file in the Oracle client directory that BIEE comes with

Copy and paste the Admin folder under E:\app\Administrator\product\11.2.0\dbhome_2\network to the BIEE installation directory BIEE The Oracle client TNS Configuration directory: $BIEE _ Home/oracle_bi1/network under

(2) Enter connection information directly in the connection pool, take care to remove the space and line break

ORCL =(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = localhost) (PORT = 1521)) (Connect_data = (SERVER = dedicated) (SER Vice_name = ORCL )))

Put the red to the data source in the RPD physical layer connection pool

Example:

BI Management--"file--" open--"online

Connection Pool Right-click property to view user name and password

biee11g Configuring an Oracle data source