Oracle 10g Data Warehousing

Chapter 13. Oracle Warehousing Tools

Which Tool

So far we have built and managed our database using the SQL*Plus interface or Oracle Enterprise Manager. But there are a number of tools available to the user, DBA, and designer to facilitate easy warehouse creation and access to information. We will now look at three of these tools, which are available from Oracle.

• Warehouse Builder

• Discoverer

• Reports

Oracle Warehouse Builder is a tool that helps the DBA design and manage the data warehouse, whereas Oracle Discoverer and Reports are end-user tools for querying your data warehouse.

Oracle Warehouse Builder

Oracle Warehouse Builder (OWB) is Oracle’s tool for designing and deploying data warehouses, data marts, and business intelligence applications. It is ...