Oracle Business Intelligence and Data Warehousing Practice Notes and Knowledge Repository

  • About Me

    Hello Friends,

    This is Santosh Kumar Gidadmani, a Business Intelligence and Data Warehouse Enthusiast passionate about blogging articles in the BI, Data warehousing, space. This is my attempt to share my experience and knowledge on Oracle BI & Data Warehousing Subjects.

  • OBIEE 11g Certified Implementation Specialist

  • Oracle Partner Network Certified Specialist

  • Visit My Profiles

  • Enter your email address to subscribe to this blog and receive notifications of new posts by email.

    Join 73 other followers

  • Blog Hits Since Nov 2010

    • 364,321 Hits
  • Live Traffic

  • Visitors Country

    Since-Mar'12Free counters!

Archive for the ‘OBIEE 10g Delivers’ Category

OBIEE 10g Delivers Configurations

Posted by Santosh Kumar Gidadmani on August 25, 2011

Oracle Business Intelligence delivers is the interface used to create alerts based on Oracle Business Intelligence Answers results. You can use delivers to detect specific results and notify the appropriate person or group through web, wireless, mobile, and other voice communication channels.

Delivers works in tandem with Oracle Business Intelligence Scheduler. IBots deliver reports and alerts to end users. IBots are configured and submitted for execution using Delivers. Scheduler is an extensible application and server that manages and schedules jobs.

High level steps:

Deploy Scheduler Tables
Create Scheduler Admin User in RPD
Configure the Job Manager
Run the Crypto tools Script
Configure Instanceconfig.xml file
Run the Scheduler services
Create IBots

Deploy Scheduler Tables

To configure the scheduler services to run, first we need to have the jobs table deployed in the schema.
We find this script in the Installed Obiee drive: OracleBIserverSchema run the file. Run this file in SQLPLUS command.

Create a user in the RPD with Administrator rights. (Example: Schadmin)

Configure the Job Manager

Logon to Job Manager and update the DNS name created in the ODBC, schema User ID and Password.

Add the scheduler user created with administrator right in the general tab;

Run the Crypto tools Script

Add the Scheduler Admin User to the credential store
Open the command prompt
Type: cryptotools credstore -add -infile installed drive:/oracle BIdata/web/config/credntialstore.xml (credentialstore file path)
Credential Alias: admin
Username: Schadmin (Scheduler Admin User)
Password: Schadmin
Do you want to encrypt the password? y/n: Y
Passphrae for the encryption:sceret
Do you want towrite the passphrase to the xml? y/n:Y
File “Oracle Bidata_home/web/config/credentilstore.xml.Do you want ti overwrite it? y/n: Y

Configure Instanceconfig.xml file

It is important to make sure that two important codes are present in the instanceconfig.xml file.

<Alerts> <ScheduleServer>D-5319:9705</ScheduleServer> </Alerts>
<CredentialStore> <CredentialStorage type="file" path="D:OracleBIDatawebconfigcredentialstore.xml" passphrase="secret"/> </CredentialStore>

Run the BI Services

Run the three services including Oracle BI Scheduler.

Create a Simple IBot

After saving the IBot successfully, you will see the alert created on the dashboard.

– Santosh

Posted in Delivers Configurations, OBIEE 10g, OBIEE 10g Delivers | 3 Comments »

%d bloggers like this: