Siebel Analytics Installation and Configuration Guide > Accessing Siebel Analytics Through Siebel Applications > Process of Configuring the Siebel Analytics Repository >

Changing the Default DSNs

The database DSNs and user names have been configured to use the specific static repository variables shown in Table 13. The default values should be changed to conform with the database DSNs in your environments.

Table 13.  Static Repository Variables and Their Values
Variable
Value
OLAP_DSN
SIEBEL_OLAP
OLTP_DSN
SIEBEL_OLTP
OLAP_USER
SIEBEL
OLTP_USER
SIEBEL
TBO
SIEBEL
OLAPTBO
SIEBEL

For more information on repository variables, see Siebel Analytics Server Administration Guide.

To update the default DSN values

  1. In the Siebel Analytics Administration Tool, navigate to Manage Variables > Repository > Static list.
  2. Double-click on each variable and update the value in the Default Initializer column.
  3. Update two additional variables, TBO and OLAPTBO.

    These variables are used for the Siebel eBusiness application database table owner name and the Siebel Data Warehouse table owner name. Update the table owners so that the various initialization blocks work properly.


 Siebel Analytics Installation and Configuration Guide, Version 7.7, Rev. A 
 Published: 11 March 2004