Siebel Analytics Platform Installation and Configuration Guide > Configuring the Siebel Analytics Data Sources >

Changing the Siebel Analytics Database Connection Pool Settings

Analytics License: All licenses.

Operating Systems: All.

Databases: All databases.

This topic is part of the Roadmap for Configuring Siebel Analytics Platform.

The database you use with Siebel Analytics may require that you change the Siebel Analytics database connection pool settings.

While testing the Siebel Analytics Server installation, you may also need to change connection pool settings for items such as the name of the database, the user ID and password, and other settings for the several repositories bundled with applications versions of Siebel Analytics.

To change the Analytics database connection pool settings

1. On a Windows computer, open the Server Administration Tool in offline mode.

   NOTE:  By default, the user name for the repository is Administrator, and the password for the repository is SADMIN. However, your administrator may have changed the default password.

2. In the Physical layer, double-click a database connection to open the Properties window. Expand the database connection to view the connection pool.
3. Double-click the Connection Pool and select the appropriate Call Interface.

   The default recommended call interface is automatically updated based on your connection type. Check the supported call interfaces before changing the default one.

   The preconfigured Connection Pool values are shown in the following table:

   Connection Pool	Default DSN Name
   OLAP Database	VALUEOF(OLAP_DSN)
   OLTP Database	VALUEOF(OLTP_DSN)
   OLAP User Name	VALUEOF(OLAP_USER)
   OLTP User Name	VALUEOF(OLTP_USER)
   User Password	db2

   Update the user password according to your environment. For more information on how to manage database connections, see Siebel Analytics Server Administration Guide.

4. For each database connection of your Siebel Analytics applications, repeat Step 3 of this procedure.

   NOTE:  If you are running Oracle, make sure that all Initialization Block connection pools are configured to use the correct logon, in order to prevent logon failures (for example, Pharma Initialization Blocks) for Siebel operational applications.

5. Save the repository.
6. For UNIX deployments, copy the repository file to the UNIX machine.