Bookshelf Home | Contents | Index | Search | PDF

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

Changing the Default DSNs

---

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

Table 8.  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, refer to Siebel Analytics Server Administration Guide.

To update the default DSN values

In the Siebel Analytics Administration Tool, navigate to Manage Variables > Repository > Static list.
Double-click on each variable and update the value in the Default Initializer column.
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.

Bookshelf Home | Contents | Index | Search | PDF