1 Oracle BI Applications Architecture

This chapter provides an overview of the Oracle Business Intelligence Applications architecture.

1.1 Oracle BI Applications Architecture

Figure 1-1 shows the Oracle BI Applications deployment architecture.

Figure 1-1 Oracle BI Applications Deployment Architecture

Components Deployed Into Manager Server "bi_server1"

• Oracle BI Applications Configuration Manager - This component is a Web application that enables you to perform system setups; functionally configure your BI Applications; and define, generate, run, and monitor load plans.

• Functional Setup Manager - (Depicted as FSM in Figure 1-1) This component is a Web application used by Configuration Manager for sequenced task implementation and task dependency management.

• Load Plan Generator - This component is a set of jar files used to create load plans in the ODI Repository.

• ATGLite - This component is a J2EE component used by Configuration Manager and Functional Setup Manager.

Components Deployed Into Managed Server "odi_server1"

• ODI Console - This component enables you to control and monitor ETL processes.

• ODI Agent - This component is a Java EE Agent, which handles schedules and orchestrates sessions.

Oracle BI Applications Repositories

• Business Analytics Warehouse - The Business Analytics Warehouse is a unified data repository for all customer-centric data, which supports the analytical requirements of the supported source systems. The Business Analytics Warehouse is supported only on Oracle Database.

• Business Intelligence Applications Components Repository (BIACOMP) - This is the repository for Configuration Manager and Functional Setup Manager. It contains load plan definitions as well as BI Applications product hierarchy, setup objects, such as parameters and domain mappings, and a list of functional tasks. This repository is supported only on Oracle Database.

• Business Intelligence Applications I/O Schema - This schema is a mirror schema and is used by all other components to read the BIACOMP schema. It supports read/write of configuration and functional setup data through ETL processes.

• ODI Repository for BI Applications - This repository contains the BI Applications-specific prebuilt ETL logic.

Client Tier

As depicted in Figure 1-1, the client host machine hosts the Configuration Manager and ODI Console, which users access through Web browsers. This tier also includes the Load Plan Generator Plug-in, a client version of the Load Plan Generator, which is deployed into ODI Studio and enables you to manage load plans from ODI Studio. The Load Plan Generator Plug-in requires ODI SDK to be installed.

Additional Tools

Golden Gate is an optional tool integrated with Oracle BI Applications. It enables you to optimize ETL loads and reduce impact on the source system, using a source-dependent data store.

For information about deploying Golden Gate in an Oracle BI Applications environment, see Oracle Business Intelligence Applications Administrator's Guide.

ETL Architecture

For information about ETL architecture, see the section titled "ETL Overview," in Oracle Business Intelligence Applications ETL Guide.