Siebel Analytics Installation and Configuration Guide > Accessing Analytics Through Siebel Applications > Changing the Preconfigured Database Connections >

Changing the Database Type

If you are using other database types, follow these steps to change the database type.

To change the database type

  1. On a Windows computer, open the Siebel Analytics Administration Tool in offline mode.
  2. NOTE:  For information on how to use the Siebel Analytics Administration Tool, access the Administration Tool online help.

    By default, the username 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.

  3. In the Physical layer, double-click on a database connection to open the Properties window.
  4. Use the Data Source Definition drop-down list to choose the database type. After making the database type change, click OK.
  5. Expand the database connection to view the connection pool. Double-click the Connection Pool and select the appropriate Call Interface.
  6. The default recommended call interface will be 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 use 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 your environment.

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

  7. Repeat Step 2 through Step 4 for each database connection appropriate for your Siebel Analytics applications.
  8. 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 eBusiness Applications).

  9. Save the repository.

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

 Siebel Analytics Installation and Configuration Guide, Version 7.5, Rev. C 
 Published: 18 April 2003