Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring the Siebel Business Analytics Repository for Siebel Customer-Centric Enterprise Warehouse >

Configuring the Siebel Business Analytics Repository Connections

You need to configure the Siebel Business Analytics repository variables and connection pools to connect to your database.

Siebel Business Analytics repository uses three connection pools to the Physical layer:

• Siebel Data Warehouse Connection Pool. The Siebel Data Warehouse Connection Pool is the main connection pool in the Siebel Business Analytics 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.
• Siebel Data Warehouse DBAuth Connection Pool. The Siebel Data Warehouse DBAuth Connection Pool is used if database authentication is required.
• Siebel Data Warehouse Repository Initblocks Connection Pool. You need to configure the Siebel 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.

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 database warehouse.
• OLAP_USER. The value of the OLAP_USER static variable is set to the database user name for the database warehouse.
• OLAPTBO. The value of the OLAPTBO static variable is set to the database table owner for the database warehouse.

To configure the Siebel Business Analytics Data Warehouse database connection

1. Open the SiebelBusinessAnalytics.rpd in the $SAHome\SiebelAnalytics\Repository folder

   where $SAHome is the path of Siebel Business Analytics Server installation folder.

2. In the Physical pane, double-click the Siebel Business Analytics Data Warehouse.
3. In the Database list, click your database type.
4. Save the repository.
5. Click Yes to Check Global Consistency.
6. Click OK when the Warnings are displayed.

To configure the Siebel Business Analytics repository connection pools

1. Open the SiebelBusinessAnalytics.rpd in the $SAHome\SiebelAnalytics\Repository folder.
2. In the Physical pane
   1. Double-click the Siebel Data Warehouse Connection Pool.
   2. Type the database source name in the Data source name box.
   3. Type your database User ID in the User name box.
   4. Type your password in the Password box.
3. Repeat Step a through Step d for the Siebel Enterprise DBAuth Connection Pool and Siebel Data Warehouse Repository Initblocks Connection Pool connection pools.
4. Save the repository.
5. Click Yes to Check Global Consistency.
6. Click OK when the Warnings are displayed.

To configure the Siebel Business Analytics repository variables

1. Open the SiebelBusinessAnalytics.rpd in the $SAHome\SiebelAnalytics\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.