OBIEE 11g Architecture

OBIEE 11g Architecture 

Domains in OBIEE

Web Logic Server Domain

•      J2EE App Server used across the board for all 11g BI applications

•      Contains :

  Managed Server: Set of J2EE Applications used for “functioning” the BIEE system

 Admin Server: Set of J2EE Applications used for “administering” of BI EE system

·         Oracle Process Manager and Notification Server (OPMN) domain

•      Used to start/Stop system components (BI Svr, BI Pres Svr, BI Schdlr, BI ClustrCntrl)

•      Can be accessed from CMD or from EM page (GUI)

 Admin Server Components

•     WLS Admin Console

•      Admin GUI for WLS,Security and J2EE Components

•     Fusion Middleware-EM Control (FMW EM)

•      Admin GUI to Manage the BI Domain

•      JMX Beans

•      Java components that provide programmatic access for managing a BI domain.

Managed Server Components

•      BI Plugin: Sends web http requests to BI Presentation Services

•      BI Security: Integrates BI Server and FMW sec platform (using webservice calls)

•      BI Action Services: Dedicated web services for Action framework

•      BI Web Service SOA: Provides Web services for objects in the BIEE Presentation Catalog, to invoke analysis, agents, and conditions.

•      BI Office: Provides the integration between Oracle Business Intelligence and Microsoft Office products

BIEE Domain System Components

•     BI Server

–     Provides capabilities to query and access data as well as services for accessing and managing the RPD file (BIEE Metadata).

•     BI Presentation Services

–     Provides the framework and interface for the presentation of business intelligence data to Web clients. It maintains an Oracle BI Presentation Catalog service on the file system for the customization of this presentation framework.

•     BI Scheduler     

–      Provides framework for scheduling and delivering reports to users (used by delivers)

•     BI Javahost

–     Enables BI Presentation Services to support various components: Java tasks for BI Scheduler, BI Publisher, and Graph generation.

•     BI Cluster Controller

–     Used for distributing requests to BI server and ensure load balancing

•     Files

–     Repository file (e.g. SampleSales.rpd)

–     Config Files (nQconfig.ini, instanceconfig.xml,)

–     Log Files (nqserver.log, nqquery.log, nqscheduler.log, sawlog0.log etc)

–     Presentation catalog (<MW_HOME>\OracleBIPresentationServicesComponent\coreapplication_obips1\catalog)

Uploading RPD in OBIEE 12 C

Uploading RPD in OBIEE 12 C

 

C:\Oracle\Middleware\Oracle_Home\user_projects\domains\bi5\bitools\bin>data-mode

l-cmd.cmd uploadrpd -I C:\Oracle\Middleware\Oracle_Home\bi\bifoundation\server\t

est.rpd -SI ssi -U weblogic

Password:

RPD Password:

Service Instance: ssi

Creating an ODBC source for database

Click on Add and choose the driver

 

 

Creating a system DSN to open an online rpd

Click on Add and choose Oracle BI Server/Server name

Uncheck Clustered DSN

Click on Next and enter BI server login ID and port number

Find port number by logging into em

Business Intelligence>biinstance>Availablity>Processes