Bookshelf Home | Contents | Index | PDF     

Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring Oracle Business Intelligence Scheduler > Creating Oracle BI Scheduler Databases and Tables >

Creating Oracle BI Scheduler Database and Tables for Specific Databases

This task is part of the process of Creating Oracle BI Scheduler Databases and Tables.

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

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

Creating a Scheduler Database and Tables for Oracle Database Server

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 Net configuration tool, create an Oracle Service to the current S_NQ_SCHED database with this user ID and password.
  4. Using the SQL*Plus Worksheet or the SQL*Plus tool, open the file SAJOBS.Oracle.sql and execute it to create Oracle Business Intelligence Scheduler tables.
  5. Open the file SAACCT.Oracle.sql and execute it to create the Accounting table.

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 SQL Server Enterprise Manager.

    Make sure that you have enough free disk space to accommodate Oracle Business Intelligence Scheduler Tables (a minimum of 500 MB for Oracle Business Intelligence applications).

  2. Using S_NQ_SCHED as the current database, use SQL Query Analyzer to open the file SAJOBS.MSSQL.sql and execute it to create the Oracle Business Intelligence Scheduler tables.
  3. Open the file SAACCT.MSSQL.sql and execute it to create the Accounting table.
  
Oracle Business Intelligence Infrastructure Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.