OBIEE 11g: Configure Oracle BI Scheduler E-Mail Settings

Hi Folks,

iBot _Mail Configuration for OBIEE 11g

Before sending dashboard reports as mailing contents in iBots we have to configure the mailing details.


We have to configure in two xml files.
1. instanceconfig.xml
2. biee-domain.xml

1. instanceconfig.xml
The instanceconfig.xml file will be located in the fallowing path
    BI installation Drive\instances\instance1\config\OracleBISchedulerComponent\ coreapplication_obisch1

The below screen shot gives the information about instanceconfig.xml before configuration

 Provide SMTP Server and Sender Details in xml file as specified below
 SMTP Server as smtp.emailsrvr.com under the tag localhost
Sender as obieemanu@gmail.com under the tag
      defaultuser@defaultmailserver.com


The below screen shot gives the information about instanceconfig.xml after configuration

2. biee-domain.xml
The biee-domain.xml file will be located in the fallowing path

      BI installation Drive\user_projects\domains\bifoundation_domain\config\fmwconfig
The below screen shot gives the information about biee-domain.xml before configuration

Provide smtpServerName and emailAddressOfSender in xml file as specified below

smtpServerName as smtp.emailsrvr.com
emailAddressOfSender as obieemanu@gmail.com
 The below screen shot gives the information about biee-domain.xml after configuration

After completion for configuring instanceconfig.xml and biee-domain.xml mails we have to deploy the mail details in Enterprise Manager under the link http://localhost:7001/em as below
Configure Email settings:

1. Login to Fusion Middleware Control Enterprise manager (http://yourservername:7001:/em) using Admin user credentials

2. Navigate to Mail tab (Business Intelligence > coreapplication > Deployment>Mail

3. Click Lock and Edit Configuration to enable changes to be made.


4. Complete the elements with the following information.
 

• SMTP Server – SMTP server of your email (e.g. mail.obieemanu.com)


• Port – Port of the SMTP server (e.g. 25)

• Display name of sender – Any name

• Email address of sender – Sender’s email address (e.g. manu@obieemanu.com

• Username – Same as the sender’s email (e.g. manu@obieemanu.com)

• Password – password of your email

• Confirm password – confirm the same password as above

• Number of retries upon failure – any number

• Maximum recipients

• Addressing method To, Blind Copy Recipient (Bcc) – if you want to receive a BCC, select it.

5. Click Apply, and then click Activate Changes.

6. Return to the Business Intelligence Overview page and click Restart.
Creating an Agent to send mails:

Since we are going to configure just to test the email settings we did in the above, we create this agent as simple as possible.

1.Login to OBIEE Web (http://yourservername:7001/analytics)

2.Click New in the Global header and then select Agent and Actionable Intelligence

3.In the Schedule tab and then select Once from the Frequency list box.

4. In the Delivery content tab, select the content you want to deliver clicking the Browse button.

5. In the Recipients tab, add emails (you can add external users mails as well) whom do you want to receive a mail with delivery content.

6. Save the agent and Run it. If it runs successfully recipient get the mail with pdf attachment (we selected pdf format in the Delivery content tab).

Thank You,