4.5 Configuring OAS Version 25.0 Connection Pool

This section describes how to configure the Oracle Analytic Server (OAS) version 25.0 Connection Pool. To configure the Connection Pool of the repository, follow these steps:
  1. Open the same Repository (as in the previous step) on the Windows machine. The Oracle BI Administration Tool - FCCM81210.rpd window is displayed.
  2. Expand the FCCM folder in the Physical section.
  3. Double-click Connection Pool to open the Connection Pool Properties window.
  4. Enter the following in the Data Source Name text box of the Connection Pool Properties window after modifying <Database Server Host Name> and <Database Name> Data Source Name = (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=<Database Server HostName>)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED) (SERVICE_NAME=<Database Name>))).
  5. Enter the Atomic Schema user name and password in respective fields.
  6. Click OK.
  7. Expand the folder.
  8. Right-click on any one table name and select View Data.
  9. Perform similar changes in the Connection Pools for all remaining folders in the Physical Layer by providing the following schema details for all Connection Pools:
    • KYC Analytics > Atomic Schema

      Note:

      Both the initial block and the connection pool must point to the Atomic Schema.
    • UIC_73 > CaseMng Connection Pool >Atomic SchemaUIC_73 > Security Connection Pool > Atomic Schema
    • TA > Atomic Schema
    • CTRBI > Atomic Schema
    • ORCL > Atomic Schema
    • FCCM > Atomic Schema
    • FSI_TF > Atomic Schema
  10. From the File menu, select Save. A confirmation message is displayed.
  11. Click Yes. The message: Consistency check did not find any errors, warning or best practices violations is displayed..
  12. Click OK.