Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Installation and Configuration Guide > Installing Siebel Analytics Software in the UNIX Environment > Installing and Configuring Siebel Analytics Components >
Database Tables and the Siebel Analytics Scheduler
The Scheduler supports several commercial databases with ODBC connections, such as the following:
- Microsoft SQL Server 7 and 2000
- Oracle 7.3, 8.x, 8i, 9i
- IBM DB2UDB V6 and V7
For a complete list of supported databases, see Siebel System Requirements and Supported Platforms.
There is a one-to-one relationship between the back-end database and the Scheduler. Therefore, the following conditions must be met:
- The Scheduler needs to be configured to use a database, and the database must be available for use, before the Scheduler service will start.
- Do not configure multiple Siebel Analytics Scheduler services to use a single database.
NOTE: Before you create a database and tables, you must have an administrative sign-on account.
To create a database and tables for Microsoft SQL Server
- Create a database named S_NQ_SCHED using Enterprise Manager. Make sure that you have enough free disk space to accommodate Siebel Analytics tables (a minimum of 500 MB for Siebel Analytics applications).
- Using S_NQ_SCHED as the current database, use Query Analyzer to open the file SAJOBS.MSSQL7.sql and execute it to create the Siebel Analytics Scheduler tables.
- Open the file SAACCT.MSSQL7.sql and execute it to create the Accounting table.
To create a database and tables for Oracle
- Proceed in one of the two following ways:
- Create a new database named S_NQ_SCHED, and create a user named S_NQ_SCHED.
- In one of your existing databases, create a user named S_NQ_SCHED.
- Provide your own password to the user S_NQ_SCHED.
- Using the Oracle client configuration tool, create an Oracle Service to the current S_NQ_SCHED database with this user ID and password.
- Using the SQL Worksheet, open the file SAJOBS.Oracle.sql and execute it to create Siebel Analytics Scheduler tables.
- Open the file SAACCT.Oracle.sql and execute it to create the Accounting table.
To create a database and tables for IBM DB2
- Create a database named S_NQ_SCHED with a valid user ID and password.
- Using Command Center, open the file SAJOBS.DB2.sql and execute it to create Siebel Analytics Scheduler tables.
- Open the file SAACCT.DB2.sql and execute it to create the Accounting table.
Updating the Scheduler Configuration
- After the tables have been created, update the Scheduler configuration using the command:
schconfig.exe
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Installation and Configuration Guide, Version 7.5, Rev. C Published: 18 April 2003 |