Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Installation and Configuration Guide > Installing Siebel Analytics Software in the Windows Environment > Siebel Analytics Scheduler Tables (Stand-Alone Only) >
Creating Database Tables for Siebel Analytics Scheduler
If you are not using Siebel Analytics Scheduler, you do not need the information in this section.
The Scheduler supports several commercial databases with ODBC connections. For a complete list of supported databases, see System Requirements and Supported Platforms for Siebel Analytics on Siebel SupportWeb.
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 starts.
- 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:
- 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.
Bookshelf Home | Contents | Index | Search | PDF |
Siebel Analytics Installation and Configuration Guide Published: 09 September 2004 |