Physical Implementation Standards

Following is the list of technologies used in DW/BI system implementation on which we are having long time experience.

General Overview

Sources

  • Any structured or non-structured data source (any database, flat files…)

Target and Repository

  • Oracle Database 11g – Enterprise Edition recommended

ETL/ELT

  • Oracle Data Integrator 11g
  • Oracle Warehouse Builder 11g
  • Informatica

OLAP

  • Oracle Essbase 11g

Analytics & Reporting

  • Oracle Business Intelligence Suite enterprise Edition (OBI EE)
  • SAP Business Objects
  • Compatible with other reporting tools

Oracle Technology Stack

Here we are going to describe recommended Oracle Tools/Technology stack used for DW/BI system implementation based on Oracle platform.

Database: Oracle Database Enterprise Edition (With Partition Option)

Oracle Database 11g is a comprehensive database platform for data warehousing and business intelligence that combines industry-leading scalability and performance, deeply-integrated analytics, and embedded integration and data-quality — all in a single platform running on a reliable, low-cost grid infrastructure.

Oracle Database 11g provides best-of-breed functionality for data warehouses and data marts, with robust partitioning functionality, proven scalability to 100’s of TBs, and innovative query-processing optimizations. Oracle Database 11g also provides a uniquely integrated platform for analytics; by embedding OLAP, Data Mining, and statistical capabilities directly into the database, Oracle delivers all of the functionality of standalone analytic engines with the enterprise scalability, security, and reliability of the Oracle Database.

ETL: Oracle Data Integrator

Oracle Data Integrator (ODI) is a best-of-breed data integration platform focused on fast bulk data movement and handling complex data transformations.

Oracle Data Integrator is fully integrated with the Oracle technology stack, including Oracle Database, Exadata Database Machine, Oracle WebLogic Server, Business Intelligence, and Oracle Applications. ODI is the strategic data integration platform for Oracle.

Oracle Data Integrator is built on several components all working together around a centralized metadata repository. These components – graphical modules, runtime agents and web-based interfaces – in conjunction with other advanced features make ODI a lightweight, legacy-free, state of the art data integration platform. This technical brief describes the Oracle Data Integrator architecture in detail.

Reporting & Analysis: Oracle Business Intelligence Enterprise Edition

Generally speaking there is no specific limitations on customer selection of front end user tool for Reports viewing, ad-hoc queries, dashboards etc.

Data model should be modeled by design principles which are not subject to specific front end tools in order to support future scalability.

In this case, we have Database and ETL tool on Oracle platform and therefore logical choice for front end tool (client tool) would be Oracle BI EE set of tools.

Besides large set of functionalities and possibilities, one of main advantages is architecture synergy since all products are from same vendor and can be easily integrated and maintained

Here is a broad overview of Oracle BI components, from an end-user perspective.

Reporting & Analysis

Oracle BI EE consists of following components:

Oracle BI Presentation Services. Oracle BI Presentation Services consists of the following interfaces:

  • Oracle Business Intelligence Answers
  • Oracle Business Intelligence Delivers,
  • Oracle Business Intelligence Interactive Dashboards
  • MS Office Plugins

Oracle Business Intelligence Answers: Oracle BI Answers provides answers to business questions. This interface allows users with the appropriate permissions to build and modify reports, also called requests, that let end users explore and interact with information, and present and visualize information using charts, pivot tables, and reports. Your organization may also have purchased prebuilt reports specific to your industry.

The results of an Oracle BI Answers request can be formatted, saved, organized, and shared with others. A report can be configured to refresh results in real-time.

Reports created with Oracle BI Answers can be saved in the Oracle BI Presentation Catalog and integrated into any Oracle BI home page or dashboard. Results can be enhanced through options such as charting, result layout, calculation, and drilldown features.

Oracle Business Intelligence Interactive Dashboards: Interactive Dashboards provide points of access for analytics information. When an end user accesses Oracle BI, the user’s default dashboard is typically the first page that appears. Dashboards are typically used to display reports that contain content specific to the needs of individual users or groups. Historical and current data sources can be merged into a single dashboard. Users with the appropriate permissions can place results from Oracle BI Answers into dashboards for use by end users.

Oracle Business Intelligence Delivers: Oracle BI Delivers is the interface used to create Oracle Business Intelligence Alerts based on analytics results. Specific results can be detected within reports and the appropriate people notified immediately through Web, wireless, and mobile communications channels. Oracle BI Delivers uses intelligence bots called iBots to detect specific results. iBots are software-based agents, driven by schedules or events that can access, filter, and perform analytics on data based on specified criteria. Users with the appropriate permissions can use Oracle BI Delivers to set up the conditions to trigger an alert. For example, if a user should be notified when a particular event occurs, such as customer account going critical, an alert can be created that will notify the user through a number of delivery options, such as email or cell phone.