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
The BI server can access a large of data sources included XML.
This capability is also called:
An example : OBIEE - Federated Query with Excel Sheet where you have two data source :
A datawarehouse is never completely up-to-date because an extraction is performed periodically.
OBIEE is able to :