Tuesday 1 December 2015

TRAINING (OBI-2) - DIFFERENCE BETWEEN OBIEE & OBIA



DIFFERENCE BETWEEN OBIEE & OBIA


Oracle Business Intelligence - Enterprise Edition (OBIEE)



Oracle Business Intelligence (OBI) is a technology platform that enables customers to make faster, more informed business decisions by offering best breed enterprise analytics solutions using interactive dashboards, powerful operational reporting, content and metadata search, native access to Big Data sources, sophisticated in-memory computing.

Below are some of the technology component of OBIEE.
  • Administration tool                              > Semantic layer
  • Answers(10g) or Analysis (11G)           > Reports
  • Dashboard                                          > Dashboards
  • Delivers                                              > scheduling reports
  • Job Manager                                       > To monitor scheduled reports
  • Catalog Manager                                 > Deploy (Dev to Test or Test to Prod)
  • ODBC Client                                        > to write and execute SQL
  • System Management (10G) or EM(11G)>To integrate and monitor server performance
  • WLS(11g) or IIS(10g) or OC4J (10g)    > Web Server
  • Console                                              > Security
  • BI publisher                                        > pixel formatting reports


Oracle Business Intelligence Applications (OBIA)

Oracle BI Applications (OBIA) are built on the Oracle BI Suite Enterprise Edition OBIEE. OBIA are prebuilt BI solutions designed for heterogeneous environments and to gain insight from a range of data sources and applications including Siebel, Oracle E-Business Suite, PeopleSoft, and third party systems such as SAP.

OBIA is a predefined work of ETL and Reporting. OBIA is bundled with predefined work like ETLs (SDE, SIL, mappings etc), Symantic layer (rpds), Dashboards & reports (Web Catalog). 

Below are the details and usage of prebuilt items which came delivered with OBIA application.
1.) SDE (Source Dependent Extraction) > OLTP to Staging Area
2.) SIL (Source Independent Loading)   > Staging Area to Data WareWarehouse
3.) DAC (DW Administration Console)   > Scheduling Tool of ETL (SDE & SIL)
4.) Pre Build Semantic Layer              > RPD
5.) Pre Build Reports & Pre Build Dasboards > Web Catalog
6.) OBAW (Oracle Business Analytics Warehouse) > Data Model (Set of tables around 950) 

Below are the list of some of the OBIA Product module offerings:

- Oracle Financial Analytics
- Oracle HR Analytics
- Oracle Marketing Analytics
- Oracle Order Management Fulfillment Analytics
- Oracle Vertical (Industry Specific) Analytics

No comments:

Post a Comment