1. Installing Business Intelligence Applications
  2. Oracle BI Applications Architecture and Installation Overview

1 Oracle BI Applications Architecture and Installation Overview

This section provides an overview of the Oracle Business Intelligence Applications (Oracle BI Applications) architecture and installation process.

Topics:

Oracle BI Applications Architecture

Review the Oracle BI Applications deployment architecture, which is comprised of several components and repositories.

Oracle BI Applications Deployment Architecture Diagram

Description of architecture.png follows
Description of the illustration architecture.png

Components Deployed Into Manager Server "bi_server1"

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

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

Components Deployed Into Managed Server "odi_server1"

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

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

Oracle BI Applications Repositories

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

  • Oracle Business Intelligence Applications Components Repository (BIACOMP) — This is the repository for Configuration Manager. It contains load plan definitions as well as Oracle 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.

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

Client Tier

As depicted in the figure, the client host accesses the Configuration Manager and ODI Console through web browsers. Install ODI Studio on a developer client system. Install ODI SDK along with ODI Studio to work with Oracle BI Applications.

Additional Tools

Oracle GoldenGate is an optional tool integrated with Oracle BI Applications. You use this tool to optimize ETL loads and reduce impact on the source system, using a source-dependent data store.

To deploy Oracle GoldenGate in an Oracle BI Applications environment, see Setup Step: Install Oracle GoldenGate on Source and Target Systems in the Oracle Business Intelligence Applications Administrator's Guide.

ETL Architecture

To learn about ETL architecture, see About ETL Architecture in the Oracle Business Intelligence Applications ETL Guide.

Oracle BI Applications Installation Roadmap

Review the high-level roadmap for installing and configuring Oracle BI Applications.

  1. Review the Oracle® Fusion Middleware System Requirements and Specifications 12c (12.2.1.4.0).
  2. Review preinstallation and deployment requirements.
  3. Install these prerequisites:
    • Oracle Fusion Middleware Infrastructure 12.2.1.4.0
    • Oracle Analytics Server

      Refer to the Oracle BI Applications certification matrix on Oracle Technology Network for the supported version of Oracle Analytics Server.

    • Oracle Data Integrator 12.2.1.4
  4. Create Oracle Analytics Server schemas using Oracle Fusion Middleware Repository Creation Utility (RCU).
  5. Install Oracle BI Applications.

    In this step, you run the Business Analytics Applications Suite installer to install the binary files for Oracle BI Applications.

    1. Create Schemas for Oracle BI Applications
    2. Create BIApps Schema on Oracle Autonomous Transaction Processing (ATP)
    3. Upgrade OPatch
  6. Apply Oracle Fusion Middleware Platform patches.
  7. Configure Oracle Analytics Server and create BI Domain.
  8. Configure Oracle BI Applications.

    In this step, you configure Oracle BI Applications with the configuration script.

    You perform system setups to complete integration of the Oracle BI Applications components, and to prepare the system for functional configurations and data loads.

  9. Configure non-Oracle source databases.

    This step is required only if your source database isn't Oracle Database.

  10. If you're deploying Oracle Fusion Applications Cloud source system data, then follow the steps in Setting Up Fusion Applications Cloud Data Sources.
  11. If you're deploying Key Flex Fields for Financials, then before you execute this load plan, you must follow the steps in Setting Up Key Flex Fields for Financials Fusion Applications Source Data.