Posts

Showing posts from October, 2018

ORACLE BI(OBIEE) Federation

Image
Modelling Federated Data using Oracle Business Intelligence (OBIEE) This is one of the most powerful features of OBIEE. Data exist in many different places. Instead of moving data to a single database, the  BI Server  can access multiple databases simultaneously to answer a single query, regardless of whether the databases are from different vendors. When the BI Server accesses heterogeneous databases, it handles automatically, database operations such as (sort and  join  ) and required transformation. The BI server can access a large of  data sources ( Relational Database Systems, Oracle, Peoplesoft Enterprise, JD Edwards Enterprise One, Oracle e-Business Suite, and SAP R/3 and mySAP, OLAP Sources like   Hyperion  Essbase ,  and   SAP BW  Infocubes etc.,.)  included XML. This capability is also called  Federation/Multi-Database Access/Cross-Database Join. In  OBIEE  terms, Data Federation involves bringing in the metadata from multiple sources into t