Siebel Reports Guide > Integrating Oracle BI Publisher with Siebel Business Applications > Process of Enabling and Configuring Report Scheduling >

Setting Up the Database Schema for the Oracle BI Publisher Server

The task is a step in Process of Enabling and Configuring Report Scheduling.

To set up the database schema for the Oracle BI Publisher Server

1. Create the scheduling database on the Oracle BI Publisher Server by following the instructions in Oracle Business Intelligence Publisher Administrator's and Developer's Guide, Release 10.1.3.4 available on Oracle Technology Network (http://www.oracle.com/technetwork/indexes/documentation/index.html) to:
   • Set up a new database instance.
   • Create a user with privileges to add tables.
   • Create the database connection.

• Install the schema by doing the following:
  1. Log in to the Oracle BI Publisher Enterprise application with administrator privilege.
  2. Click the Admin tab, and then select Scheduler Configuration.
  3. Select the database type applicable to your deployment and provide information as shown in the following table.

     Database	Enter
     Oracle	Connection String->jdbc:oracle:thin:@[host]:[port]:[SID] dbtableowner is nothing but user name and password host-is nothing but databaseserver port-is nothing but LM_DB_port [SID]-is nothing but dbinstance Data base driver class: oracle.jdbc.OracleDriver
     MSSQL	connection string:jdbc:hyperion:sqlserver://databaseserver:LM_DB_port;DatabaseName=databasename username:username password:password Data base driver class: hyperion.jdbc.sqlserver.SQLServerDriver
     db2	Connection String: jdbc:hyperion:db2://BIPServerHostName:port;DatabaseName=<DATABASENAME> username:username password:password

  4. Click Test Connection to make sure that the connection works.
  5. Click Install Schema.

     The tables are automatically created.

2. Restart both the Oracle BI Publisher Server and the Siebel Server (or servers).