7. The Oracle example

The trend currently being followed by the majority of BI software manufacturers is to offer a complete package covering the entire software chain required to build a BI system comprising a warehouse and multi-dimensional data stores. These include Oracle, whose offering includes :

• data storage software with Oracle Application Server ;

• ETL (extract, transform, load) software with Oracle Warehouse Builder ;

• query, analysis and reporting software with Oracle Discoverer.

Here we present the general principle of the Oracle Warehouse Builder ETL, which enables you to define and build a target database from data sources (databases, files, etc.).

In this software, the creation of a BI system is organized within a project....