Skip Headers

Oracle Fusion Middleware Administrator's Guide for Oracle Business Intelligence Publisher (Oracle Fusion Applications Edition)
Release 11g (11.1.1)
Part Number E20837-01
Go to Table of Contents
Contents
Go to previous page
Previous
Go to next page
Next

Scheduler Configuration Reference

This appendix covers the following topics:

Introduction

The Oracle Business Intelligence Platform Installer configures the connection to the scheduler and installs the scheduler schema to your selected scheduler database. The WebLogic JMS queues are set up and the scheduler is up and running after installation is complete and the servers have been started.

This information in this appendix is provided for reference for manually configuring the scheduler and for setting up ActiveMQ as an alternative JMS provider.

For conceptual information about the scheduler, information for installing and configuring additional managed servers, and a description of the scheduler diagnostics page, see Configuring the Scheduler.

Configuring BI Publisher for ActiveMQ

The scheduler is configured by default to use WebLogic JMS. The scheduler also supports ActiveMQ as an alternative JMS provider. Use these guidelines in conjunction with the ActiveMQ documentation to configure BI Publisher if you choose to use ActiveMQ as the JMS provider.

Install ActiveMQ

It is recommended that you install ActiveMQ version 5.2.0 or later. This can be installed in Windows, Unix or Linux. Follow the installation steps documented athttp://activemq.apache.org/

Register ActiveMQ as a JNDI Service

When you start ActiveMQ, the queues can be accessed using JNDI service.

The default URL to access this service is:

failover://tcp://localhost:61616

To change this configuration, update the activemq.xml configuration file found in apache-activemq-x.x.x\conf for example: apache-activemq-5.2.0\conf .

Update the BI Publisher Scheduler Configuration Page

Perform the following:

  1. On the BI Publisher Administration page, under System Maintenance, click Scheduler Configuration.

  2. Under the JMS Configuration region, select ActiveMQ.

  3. Enter the ActiveMQ JNDI URL. For example: failover://tcp://localhost:61616

  4. Enter the threads per processor (for example: 5).

  5. Enter the path to a shared temporary directory.

  6. Click Test JMS to test the connection.

  7. Click Apply to apply the changes to this page.

The ActiveMQ URL is dynamically applied. The queues and topics are automatically created in ActiveMQ and are ready for scheduling. You can confirm the queues by checking them in the Scheduler Diagnostics page. Alternatively, you can check the status in the ActiveMQ Web console: http://localhost:8161/admin.

Manually Configuring the Quartz Scheduler

BI Publisher includes the Hyperion-branded DataDirect Connect for JDBC drivers to setup a connection to install and use the scheduler tables in your database. These drivers can be used as an alternative to the native JDBC drivers provided by your database vendor. When you choose a database for which a DataDirect driver is available, BI Publisher automatically enters the database driver class information in the setup screen for you. There is no additional setup required for the driver files.

If you choose to use a data direct driver not provided by the BI Platform Installer, you must download, install, and configure the driver manually.

Recommendations for Using DataDirect Connect or Native Database Drivers

DataDirect Connect for JDBC drivers are provided for the following databases:

Note: Some database options listed here and in the Scheduler page may not be supported in this release. See System Requirements and Certification for the most up-to-date information on supported hardware and software.

The following table displays the driver recommendations for the supported scheduler databases:

Database Native JDBC Driver DataDirect JDBC Driver
Oracle 10g, Oracle 11g Recommended Supported
IBM DB2 v8.1, v9.1 Supported Recommended
Microsoft SQL Server 2000, 2005 Supported Recommended
Sybase Adaptive Server Enterprise Supported Recommended
MySQL 4.1.10a-NT, 5.0 Supported Not Supplied

Set Up a User on Your Scheduler Database

To set up the connection to your scheduler database, you must ensure you have created a user on your selected database. BI Publisher will use this user to connect to the database. Depending on your database type, this user may require specific privileges. These are detailed in the database-specific sections below.

Entering Connection Information for Your Scheduler Database and Installing the Schema

Following are the general steps for setting up the Scheduler database. Please also refer to the subsequent section that is specific to your database.

  1. Log in to BI Publisher with Administrator credentials and select the Administration tab.

  2. Under System Maintenance, click Scheduler Configuration.

  3. In the Scheduler Selection region, select Quartz.

    Note: The option "Enterprise Scheduler Services" is reserved for a future release.

  4. Enter the following fields for the Database Connection:

  5. Click Test Connection to ensure that BI Publisher can connect to the database. If the connection fails, ensure that you have entered the fields as shown and set up your database appropriately.

  6. Click Install Schema to install the BI Publisher scheduler schema to your database.

Entering Connection Information for an Oracle Database

Prerequisite: Ensure that the database user you enter has "connect" or "create session" and "create table" privileges and that the user has been assigned a quota (otherwise the quota will be 0).

For example, the following sample creates the user "bipuser":

SQL> CREATE USER bipuser
   2  IDENTIFIED BY welcome
   3  DEFAULT TABLESPACE USERS
   4  TEMPORARY TABLESPACE TEMP
   5  QUOTA 20G ON USERS
   6  QUOTA 1M ON TEMP;
  
User created. 

 SQL> GRANT CREATE SESSION TO bipuser; -- or "GRANT CONNECT TO bipuser;"

 Grant succeeded. 

 SQL> grant create table to bipuser; 
 
 Grant succeeded.

Enter the following to use the Oracle native driver to connect to your Oracle database:

Field Entry
Database Type: Select Oracle 11g or Oracle 10g from the list.
Connection String: Enter the following connection string parameters:
jdbc:oracle:thin:@<hostname>:<port>:<oracle SID>
For example:
jdbc:oracle:thin:@mydatabaseserver.com:1521:bipscheduler
Database Driver Class: oracle.jdbc.driver.OracleDriver

Entering Connection Information for IBM DB2

Prerequisite: Ensure that the user that you enter to configure the scheduler has been set up with a 32 K page size tablespace. If not, create the table and assign it to the user. The user must also have "Connect to database" and "Create tables" privileges.

Enter the following to use the DataDirect driver to connect to an IBM DB2 v8 or IBM DB2 v9 database:

Field Entry
Database Type: Select IBM DB2 v9 or IBM DB2 v8 from the list.
Connection String: Enter the following connection string parameters:jdbc:hyperion:db2://<hostname>:<port>;DatabaseName=<DATABASENAME>
For example:
jdbc:hyperion:db2:// mydatabaseserver.com:1433;DatabaseName=bipscheduler
Database Driver Class: hyperion.jdbc.db2.DB2Driver

Entering Connection Information for Microsoft SQL Server

Prerequisite: Ensure that your Microsoft SQL Server is set up with mixed mode authentication. Also ensure that the user you enter to configure the scheduler has the "db_owner" role.

Enter the following to use the DataDirect driver to connect to a Microsoft SQL Server 2000 or 2005 database:

Field Entry
Database Type: Select Microsoft SQL Server 2000 or Microsoft SQL Server 2005 from the list.
Connection String: Enter the following connection string parameters:
jdbc:hyperion:sqlserver://<hostname>:<port>;DatabaseName=<DATABASENAME>
For example:
jdbc:hyperion:sqlserver:// mydatabaseserver.com:1433;DatabaseName=bipscheduler
Database Driver Class: hyperion.jdbc.sqlserver.SQLServerDriver

Entering Connection Information for a Sybase Adaptive Server Enterprise Database

Prerequisite: Ensure that you set the "ddl in tran" mode to true in the database. Consult the Sybase documentation or contact your database administrator for instruction how to enable this option.

Enter the following to use the DataDirect driver to connect to your Sybase Adaptive Server Enterprise database:

Field Entry
Database Type: Select Sybase Adaptive Server Enterprise from the list.
Connection String: Enter the following connection string parameters:
jdbc:hyperion:sybase://<hostname>:<port>;DatabaseName=<DATABASENAME>
For example:
jdbc:hyperion:sybase://mydatabaseserver.com:4100;DatabaseName=bipscheduler
Database Driver Class: hyperion.jdbc.sybase.SybaseDriver