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

Changing the Default Analytics DSNs


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

Table 46.  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 Server 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 operational application database tableowner name and the Siebel Data Warehouse tableowner name. Update the tableowners so that the various initialization blocks work properly.

Siebel Analytics Installation and Configuration Guide