My Oracle Support Banner

Security Integration of OBIEE 12c/Oracle Analytics Server with Oracle E-Business Suite (EBS) (Doc ID 2825669.1)

Last updated on NOVEMBER 28, 2023

Applies to:

Business Intelligence Suite Enterprise Edition - Version 12.2.1.4.0 and later
Oracle E-Business Suite Technology Stack - Version 12.2 and later
Oracle Analytics Server - Version 5.5.0 and later
Information in this document applies to any platform.

Purpose

This paper provides the documented steps to integrate Oracle Analytics Server 105.x with Oracle E-Business Suite 12.2.x security.

These steps are only applicable for EBS Integration while accessing /analytics and /xmlpserver. This document would NOT work for accessing /dv/ui Data Visualization URL. Data Visualization ONLY supported fusion middleware based  Authentication and Authorization - DV does not support Initialization Block based Security. So the steps are not valid for Visual Analyzer/DV access.

OBIEE 12c: Does Data Visualization Support Authorization Via Initialization Blocks? (Doc ID 2130407.1)

Scope

The method described in this doc makes changes to the method of EBS security integration as documented in the Oracle BI Integrator’s guide.
If the method described in this document achieves the required Oracle Analytics Server certification status, then the main Oracle Analytics Server documentation may change to reflect the information in this document. Therefore it is important to check the publication status on this document as it may be superseded in the future by the official Oracle Analytics Server documentation.


This document is aimed at Oracle Business Intelligence professionals familiar with Oracle Analytics Server 5.x.

There are some limitations of this approach. The limitations include (but are not limited to):

 

This approach has been tested against the following release versions
  • Oracle Analytics Server 5.x

 

Details

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Purpose
Scope
Details
 Pre-requisites
 STEP1. RPD Configuration With EBS Datasource
 1.1 Creation of Connection Pools
 Connection Pool with Connect Script
 Connection Pool without Connect Script
 1.2 Setting Up Session Variables for Authentication
 Step1.1
 Step1.2
 Step1.3
 Step1.4
 STEP 2 Updating authenticationschemas.xml settings
 STEP 3 Updating instanceconfig.xml settings
 STEP 4 Creation of Application Roles 
 STEP 5. Creation of LibOvd Adapter to Populate E-Business Suite Users
 1. Creation & Deployment of Java data source for with EBS connection detail
 2. Creating EBS User Views
 3. Preparation of LibOvd Adapter XML
 4. Adapter Creation Using libovdadapterconfig script
  5. Setting Identity Provider Attributes in Enterprise manager Console
 6. Restart complete bi domain
 
7. Validation of Adapter using WLST
 8. Testing LibOVD adapter
 8.1 EM Console
 8.2 OAS Console
 
 STEP 6 BIPublisher Configuration
 6.1 Disabling Saw Auth Init Block Only for Xdo To False for Managed Server(s)
 Option 1
 Option 2
 6.2 Configure BI Publisher to use the Server Security Model
 STEP 7 Specify LogOff URL in OBIEE when Integrated with EBS
 STEP 8 Verify EBS OAS SSO Integration
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.