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

Configuring Databases for the Oracle BI Scheduler

This task is part of the Process of Configuring Oracle BI Scheduler.

The following procedures describe how to configure the back-end database and tables:

• Oracle Database Server

  See the topic Configuring Oracle Server Databases for the Oracle BI Scheduler

• Microsoft SQL Server

  See the topic Configuring SQL Server Databases for the Oracle BI Scheduler.

Configuring Oracle Server Databases for the Oracle BI Scheduler

The Data Source Name used in the Job Manager Scheduler configuration must match the Oracle database service alias created in Step 3 of Creating a Scheduler Database and Tables for Oracle Database Server.

To configure the Oracle database using Job Manager

1. From the Windows Start menu, select Programs > Oracle Business Intelligence > Job Manager.
2. In Job Manager, select File > Configuration Options.
3. In the Connection Pool section, enter the Oracle database service alias for the Data Source Name.

   Select the appropriate Database Type from the drop down list (for example, Oracle 10g R1).

4. Enter the username and password for the user S_NQ_SCHED created in Creating a Scheduler Database and Tables for Oracle Database Server.

   The Call Interface is updated automatically according to the Database Type chosen.

5. Exit the Job Manager.
6. Start the Oracle BI Scheduler Service from Windows Start Menu.

Configuring SQL Server Databases for the Oracle BI Scheduler

The Data Source Name used in the Job Manager Scheduler configuration must match an existing ODBC Data Source Name (DSN) for the SQL Server S_NQ_SCHED database used in Creating a Scheduler Database and Tables for SQL Server.

If you do not have a System DSN entry, create a new one as shown in the following procedure.

To configure the SQL Server database

1. From the Windows Start menu, select Settings > Control Panel > Administrative Tools > Data Sources (ODBC).
2. Start the ODBC Data Source Administrator.
3. Select the System DSN tab, and then click Add.
4. Select the driver SQL Server, and then click Finish.
5. In the wizard Create a New Data Source to SQL Server, do the following:
   1. Enter a name and description for the data source.
   2. Select your SQL Server from the drop down Server list, and then click Next.
   3. For server verification of the login ID authenticity, select the appropriate authentication for the S_NQ_SCHED SQL Server database that was created in Creating a Scheduler Database and Tables for SQL Server. Click Next.
6. Select the tick box Change the default database to and select the S_NQ_SCHED database from the drop down list. Click Next.
7. Update any language or log file settings if appropriate, and then click Finish.
8. To verify your connection settings, click the Test Data Source button, and then click OK.
9. Click OK to exit ODBC Data Source Administrator.