Siebel Analytics Installation and Configuration Guide > Configuring the Siebel Analytics Application Repository >

Changing the Analytics Database Type

If you are using other database types than the default shipped with Siebel Analytics, follow these steps to change the database type.

To change the database type

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

   NOTE:  For information on how to use the Server Administration Tool, see Siebel Analytics Server Administration Guide.

   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.

   NOTE:  Be sure to change the default password before migrating to production.

2. In the Physical layer, double-click a database connection to open the Properties window.
3. Use the Data Source Definition drop-down list to choose the database type.

   After making the database type change, click OK.

4. Expand the database connection to view the connection pool.

   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 DSN name has been preconfigured to VALUEOF(OLAP_DSN) for the OLAP database and VALUEOF(OLTP_DSN) for the OLTP database. The user name has been preconfigured to be VALUEOF(OLAP_USER) and VALUEOF(OLTP_USER) as well. The default password is db2. You should update the password according to your environment.

   For more information on how to manage database connections, see Siebel Analytics Server Administration Guide.

5. Repeat Step 2 through Step 4 for each database connection appropriate for your Siebel Analytics applications.

   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 do not fail for Siebel operational applications).

6. Save the repository.

NOTE:  If you use AIX, HP-UX, or Solaris, copy the repository file to the AIX, HP-UX, or Solaris machine.