Oracle BI Applications 11.1.1.8.1 Architecture Components

• Source systems

• Oracle Business Intelligence Enterprise Edition

• Oracle Business Analytics Warehouse

• Oracle BI Applications components repository

• Oracle BI Applications Oracle Data Integrator repository

• Oracle BI Applications Configuration Manager

• Functional Setup Manager

• Oracle Data Integrator

• Oracle GoldenGate

Source Systems

• Source systems are online transactional processing (OLTP) databases that hold the source data that is loaded into the Oracle Business Analytics Warehouse (OBAW) via  extract, transform, and load (ETL) processing.

• Source systems for Oracle BI Applications include:

– Oracle E-Business Suite Applications

– Oracle’s Siebel Applications

– Oracle’s PeopleSoft Applications

– Oracle’s JD Edwards Applications

– Other non-Oracle systems

Oracle Business Intelligence Enterprise Edition

• Oracle Business Intelligence Enterprise Edition (Oracle BI EE) is a business intelligence platform that is used to access and present data in easy-to-understand formats,

such as tables and graphs.

• Oracle BI Applications is built on the Oracle BI EE platform to deliver targeted information about your organization’s data with Oracle BI EE’s dashboards, reports, graphs,

scorecards, and analyses

Oracle Business Analytics Warehouse

The Oracle Business Analytics Warehouse (OBAW) is a prebuilt data warehouse data model that was designed using dimensional modeling techniques to support the analysis

requirements of Oracle BI Applications. It includes:

• A universal data warehouse design that enables you to integrate data from different source systems

• Multiple instance support that enables you to use one data warehouse deployment for multiple source system instances

• Conformed dimensions that enables you to view the data from different subject areas

Oracle BI Applications Repositories

• Oracle BI Applications Oracle Data Integrator repository

– Contains the Oracle BI Applications-specific prebuilt ETL logic

• Oracle BI Applications components repository

– Repository for Configuration Manager and Functional Setup Manager

– Contains load plan definitions, Oracle BI Applications product hierarchy, setup objects, such as parameters and domain mappings, and a list of functional tasks

Oracle BI Applications Configuration Manager

Configuration Manager is a web application that you use to set up and maintain an Oracle BI Applications environment. You use Configuration Manger to:

• Configure offerings, which are the products you have purchased (for example, Oracle Financial Analytics)

• Configure functional areas, which are the component parts of the offering (for example, Accounts Receivable is a functional area of Oracle Financial Analytics)

• Monitor and manage Oracle BI Applications setup data

• Monitor and manage load plans, which you use to perform extract, transform, and load (ETL) processes

• Migrate configuration data across environments using the import and export options

Functional Setup Manager

Functional Setup Manager is a web application that works in conjunction with Configuration Manager to enable you to:

• Manage and perform functional configuration tasks for offerings

• Deploy an offering and its functional areas

• Manage a list of configuration tasks, which you can assign to different functional developers

• Monitor task implementation status

Oracle Data Integrator

• Oracle BI Applications uses Oracle Data Integrator (ODI) as its data integration platform.

• ODI is a comprehensive, unified ETL tool for building, deploying, and managing complex data warehouses.

• ODI performs high-volume, high-performance batch and real-time loads, as well as data validation.

• In an Oracle BI Applications environment, ODI works in conjunction with Oracle BI Applications Configuration Manager, which provides:

– A user interface for managing load plans

– Access to ODI Console, a web application that enables you to view objects in the ODI repository, and control and monitor ETL processes

Oracle GoldenGate

Oracle GoldenGate is a data replication tool that you can use to create a replicated OLTP schema or schemas, facilitate change-data capture, and aid in ETL and transactional system

performance.

• Provides an OLTP mirrored schema on the OBAW database instance using replication

– This replicated source-dependent schema (SDS) is then used as a source during ETL.

• Provides less network input/output (I/O) during ETL because the source data for extract is in the same physical instance/machine as the OBAW target tables

• Shortens the length of time that ETL takes by minimizing the impact to the OLTP database