BIP 10G/11G - Scheduler (Quartz) Configuration

Card Puncher Data Processing

BIP 10G/11G - Scheduler (Quartz) Configuration

About

BIP Scheduler configuration.

A database user is required to hold the scheduler metadata. It must have the privileges “connect and resource”.

Schema

Objects

List of the tables

Table Name (10g|11g)
QRTZ_BLOB_TRIGGERS
QRTZ_CALENDARS
QRTZ_CRON_TRIGGERS
QRTZ_FIRED_TRIGGERS
QRTZ_JOB_DETAILS
QRTZ_JOB_LISTENERS
QRTZ_LOCKS
QRTZ_PAUSED_TRIGGER_GRPS
QRTZ_SCHEDULER_STATE
QRTZ_SIMPLE_TRIGGERS
QRTZ_TRIGGERS
QRTZ_TRIGGER_LISTENERS
XMLP_APPINFO Only 11g
XMLP_SCHED_DATA Only 11g
XMLP_SCHED_DELIVERY Only 11g
XMLP_SCHED_JOB
XMLP_SCHED_OUTPUT
XMLP_SCHED_SUBSCRIPTION Only 10g

Installation and configuration

11g

The BIP scheduler configuration is automatically made during the initial OBIEE installation and the scheduler schema is in the BIPLATFORM schema.

10g

  • Create a database user to hold the tables
sqlplus sys/sys_password@database as sysdba;
create user BIP_QUARTZ identied by BIP_QUARTZ quota unlimited on users;
grant connect, ressouce to BIP_QUARTZ;
  • In the admin page, you can find the link “System Maintenance / Scheduler Configuration” to configure the Scheduler. Enter this parameters.
Database Type Oracle
Connection String jdbc:oracle:thin:@host_of_database:1521:sid_of_database
Username Password BIP_QUARTZ/BIP_QUARTZ
Database Driver Class oracle.jdbc.driver.OracleDriver

After you fill all the parameters, test the connection with the “Test Connection Button”.

If you have a successfull message, click on the “Install Schema” button to install the schema. You must see this successful message after a few seconds :

Schema installed successfully. The scheduler settings have been saved.

To complete, click the “Apply Bouton”.

Documentation / Reference





Discover More
Card Puncher Data Processing
BIP 10G - Configuration with OBIEE 10G

When you have to configure BIP to work completely with OBIEE, you will have then three main tasks to perform: the configuration of the security through the OBIEE BI Server the configuration of the...
Obi Edition
OBIEE 11G - BIPlatform Schema

The Business Intelligence Platform schema (BIPlatform) is a metadata repository such as MDS. The BIPlatform schema is created with the help of RCU. Prefix Software ANNOT For annotations CACLMGR...



Share this page:
Follow us:
Task Runner