Oracle Business Intelligence Infrastructure Installation and Configuration Guide > Configuring BI Publisher Reporting Tool >

Configuring BI Publisher for Scheduler


This procedure is performed in the Oracle BI Publisher screen's Admin tab.

NOTE:  The scheduler mentioned here is not the Oracle Business Intelligence Scheduler. It is the scheduler used only by BI Publisher.

To configure the BI Publisher for the scheduler

  1. Where you want to store the scheduler schema, create a database user.

    Assign the user the privileges to open a session and create database objects.

  2. Go to the BI Publisher page Admin tab and click on Scheduler Configuration.
  3. Enter the database and created user information, as shown in the following example:

    Database Type

    Oracle 10g

    Connection String

    jdbc:oracle:thin:@machine01.domain:1521:ora102

    Username

    XMLPSCH2

    Database Driver Class

    oracle.jdbc.driver.OracleDriver

  4. Click on Test Connection to verify the validity.
  5. Click on Install Schema button and wait for confirmation.
  6. If you have multiple servers connecting to the same repository and scheduler schema, check the Clustering box.

Figure 2 shows the relationship between Oracle BI Enterprise Edition and BI Publisher.

Figure 2. Diagram of the relationship between Oracle BI Enterprise Edition and BI Publisher
Click for full size image

To access BI Publisher under Windows

  • Navigate to Start > Programs > Oracle Business Intelligence > Oracle BI Publisher.

    The browser pointing to http://localhost:9704/xmlpserver opens.

Oracle Business Intelligence Infrastructure Installation and Configuration Guide Copyright © 2007, Oracle. All rights reserved.