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

Creating Analytics Scheduler Databases and Tables

Analytics License: Platform only.

Operating System: Windows only.

Databases: All databases.

This task is part of the Process of Configuring Scheduler Server for Stand-Alone Analytics. You can either create a new database in which to store the tables or use an existing database.

NOTE:  Before you create a database and tables, you must have an administrative sign-on account.

To create a database and tables for use by Analytics Scheduler

1. Make sure that you have a valid administrative account to create a database and tables.
2. Create the database, or use an existing database.
3. Create the Scheduler tables by executing SAJOBS.xxx.sql (where xxx is the database type).

   Use the appropriate procedure for your back-end database, as shown in Creating Analytics Scheduler Databases and Tables for a Relational Database.

   If you are using usage statistics, create the table in SAACCT.xxx.sql.

Table 24 gives brief descriptions of the database tables used by Siebel Analytics Scheduler.

In addition to the database tables shown in Table 24, Analytics Scheduler uses the S_NQ_ACCT table.

NOTE:  The S_NQ_ACCT table. is independent of Scheduler.

If usage tracking is enabled in NQSConfig.INI, Siebel Analytics Server generates Usage Tracking data files. A sample JavaScript is provided, which extracts information from the Usage Tracking files and loads them to a table in the relational database. The S_NQ_ACCT table stores all the information regarding Accounting Data. (For information about usage tracking, see Siebel Analytics Server Administration Guide.)