OBIEE - Federated Query / Multi-Database or Cross-Database Join

> Reporting and Data Access Tools > Oracle Business Intelligence (OBIEE/Siebel Analytics) > OBIEE - BI Server (OBIS|nqsserver|nqs)

1 - About

Data can 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 or what version of database software each runs under.

When the BI Server accesses heterogeneous databases, it handles automatically

  • database operations such as
  • and required transformation, such as:
    • data type casting
    • or applying multiple complex functions.

The BI server can access a large of data sources included XML.

This capability is also called:

  • Federated Query
  • Federation
  • Multi-Database Access
  • Cross-Database Join
Advertising

3 - Example

An example : OBIEE - Federated Query with Excel Sheet where you have two data source :

  • one Excel used to store the quota
  • an other Oracle where the datawarhouse is located

4 - DWH and OLTP reconciled

A datawarehouse is never completely up-to-date because an extraction is performed periodically.

OBIEE is able to :

  • perform a query against your OLTP application system to retrieve the data from the last extraction
  • perform a query against the DWH system
  • and to merge the two query in on result