Siebel Analytics Platform Installation and Configuration Guide > Configuring Siebel Analytics Scheduler Server >

Creating Analytics Scheduler Databases and Tables for a Relational Database

Analytics License: Platform only.

Operating Systems: All.

This task is part of the Process of Configuring Scheduler Server for Stand-Alone Analytics.

The following procedures describe how to create a database and tables for specific relational databases:

• Microsoft SQL Server
• Oracle
• IBM DB2

  NOTE:  Teradata is not supported in this version of Scheduler.

Creating a Scheduler Database and Tables for SQL Server

Databases: MS SQL Server only.

Use the following procedure to create a Scheduler database and tables for Microsoft SQL Server.

NOTE:  For usage statistics, create the table in SAACCT.MSSQL.sql.

To create a database and tables for Microsoft SQL Server

1. 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).
2. Using S_NQ_SCHED as the current database, use Query Analyzer to open the file SAJOBS.MSSQL.sql and execute it to create the Siebel Analytics Scheduler tables.
3. Open the file SAACCT.MSSQL.sql and execute it to create the Accounting table.

Creating a Scheduler Database and Tables for Oracle

Databases: Oracle only.

Use the following procedure to create a Scheduler database and tables for Oracle.

NOTE:  For usage statistics, create the table in SAACCT.Oracle.sql.

To create a database and tables for Oracle

1. 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.
2. Provide your own password to the user S_NQ_SCHED.
3. Using the Oracle client configuration tool, create an Oracle Service to the current S_NQ_SCHED database with this user ID and password.
4. Using the SQL Worksheet, open the file SAJOBS.Oracle.sql and execute it to create Siebel Analytics Scheduler tables.
5. Open the file SAACCT.Oracle.sql and execute it to create the Accounting table.

Creating a Scheduler Database and Tables for IBM DB2

Databases: IBM DB2 only.

Use the following procedure to create a Scheduler database and tables for IBM DB2.

NOTE:  For usage statistics, create the table in SAACCT.DB2.sql.

To create a database and tables for IBM DB2

1. Create a database named S_NQ_SCHED with a valid user ID and password.
2. Using Command Center, open the file SAJOBS.DB2.sql and execute it to create Siebel Analytics Scheduler tables.
3. Open the file SAACCT.DB2.sql and execute it to create the Accounting table.