Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide > Installing and Configuring Siebel Data Warehouse > Database Parameters and Requirements for Siebel Data Warehouse >
SQL Server-Specific Database Requirements for Siebel Data Warehouse
This section lists requirements for SQL Server database usage.
NOTE: SQL Server users must make sure the SQL Server client software is installed.
NOTE: SQL Server databases with binary sort order or case-sensitive dictionary sort order are supported. Case-insensitive dictionary sort order is not supported.
SQL Server databases should be created with ANSI NULL option selected.
- In Enterprise Manager, select Database.
- Right-click and choose Database properties.
- Click the Options tab and select the box for ANSI NULL default.
In a SQL Server 2000 environment, when loading Analytics tables with international data, or loading more than one language, modify the DB Library Options setting.
To modify the DB Library Options setting
- In the program menu Microsoft SQL Server, launch the Client Network utilities.
- Select the DB Library Options tab.
- Clear the option Automatic ANSI to OEM.
NOTE: SQL Server 2000 automatically tunes many of the server configuration options, therefore an administrator is required to do little, if any, tuning. Although these configuration options can be modified, the general recommendation is that these options be left at their default values, allowing SQL Server to automatically tune itself based on run-time conditions.
To create the user accounts that access the database
- Assign these user accounts SSE_ROLE.
- Set these accounts to run the .dll commands (that is, set permissions to create tables).
Recommended SQL Server Database Parameters
If necessary, SQL Server components can be configured to optimize performance, as shown in Table 6.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Data Warehouse Installation and Administration Guide Published: 11 March 2004 |