How to Integrate OBIEE 11G with SIEBEL CRM | The Big Data - Business Intelligence by Sandeep Venu

Enter key word

How to Integrate OBIEE 11G with SIEBEL CRM



Overview


This is intended for anyone that needs to embed an OBIEE 11g dashboard in Siebel 8.  At a high level, you will need to:
  1. Congifure the Siebel Screen
  2. Modify the instanceconfig.xml obiee config file to enable iframe support.
  3. Modify the web.xml obiee config file to enable iframe support.
  4. Restart the OBIEE Components.
  5. Create the Host record in Siebel.
  6. Create the Symbolic URL record in Siebel.
  7. View the OBIEE dashboard in Siebel.
 Step details and screenprints below... 

 

Configure the Siebel Screen

Add a new Siebel Screen/View/Applet.   Look at the oob Sales Dashboard View (and the Screen/applet it's related to).   Use these as guidelines to configure your new siebel screen/view/applet.  You can use the same Analytics SSObusiness component, but you will need to add a new calculated field.  In this example, the calculated fields value is'CustomSalesDashboard' (with the single quotes).   This will need to be the same value you use as the name of the Symbolic URL record you add in the step below.   Compile and restart the Siebel App.



Modify Instanceconfig.xml

Locate the instanceconfig.xml file at the location:
[BIHOME]\instances\[Instance]\config\OracleBIPresentationServicesComponent\coreapplication_obips1\

Update the instanceconfig.xml file to add the highlighted entry within the "security" tag.  Possible values are 'allow', 'prohibit' and 'sameDomainOnly':
<Security>
<InIFrameRenderingMode>allow</InIFrameRenderingMode>

Modify Web.xml

Edit the web.xml file at the following location:
[BIHOME]\oracleBI1\bifoundation\web\app\WEB-INF\ 
Add the following highlighted entry to the file.  The syntax is the opposite of what the syntax for instanceconfig.xml is, since the 'never' means to never block the rendering within IFrame.  You can choose 'never' to always allow rendering in the IFrame, or 'differentDomain' to only allow rendering if it is in the same domain.  
<servlet-mapping>
<servlet-name>RelatedContent</servlet-name>

<url-pattern>/RelatedContent</url-pattern>
</servlet-mapping>
<context-param>
<param-name>oracle.adf.view.rich.security.FRAME_BUSTING</param-name>
<param-value>never</param-value>
</context-param>

<login-config>
<auth-method>CLIENT-CERT</auth-method>
</login-config>

Restart OBIEE System Components

Now that you've completed both steps, restart the OBIEE System Components using opmnctl (Stop opmnctl and Start opmnctl).  If you need to find this, you'll find it in your start menu on the server under the 'Oracle Business Intelligence' folder, called 'Stop BI Services' and 'Start BI Services' respectively.


Create the Host record in Siebel


 


Create the Symbolic URL record in Siebel


 


View the OBIEE Dashboard in Siebel



SHARE

About Sandeep Venu

    Blogger Comment
    Facebook Comment

0 comments:

Top Links

Upgrading BI Publisher

Add Google Search

OBIEE- LDAP

Change Admin Password

Best Practices

ORACLE 11GR2

Host Files

Customization

OBIEE-SIEBEL

Bug Fixes

Setting Default

OBIEE Installation failed

OBIEE Installation

Oracle Databse

Oracle In Linux

Loopback Adapter

Weblogic Failed

Yum Commands

Weblogic Admin

Linux Static IP

OBIEE LDAP

Admin Paswword

Scaling

Weblogic Starting Error

Localizing BI

Physical Schemas

Multimedia Dashboard

Video in OBIEE

Variables in OBIEE

Ago 30 Days

Email Link

ODI Installation

AGO Function

Sort Pivote table

OBIEE Patch

Reset Sys password

Date Calculation

Add Row in Report

Increase Row limit

OBIEE with Essbase

Reset Weblogic

BIP Login Error

MDS and BI Platform

ORA 28001 Error

ORA 12560 TNS Protocal Error

ORA 12154 TNS Error

OBIEE ON AIX

Pre Requsite

AIX Commands

Commands