Oracle^® Business Intelligence Applications Installation and Configuration Guide > Installing and Configuring Oracle BI Applications on Windows >

Creating the Required Databases

This procedure provides instructions for creating databases to hold the following:

• the DAC metadata repository.
• the Oracle Business Analytics Warehouse.

You can store both the DAC metadata repository and the Oracle Business Analytics Warehouse in separate databases, or in the same database. For example, if you are using an Oracle database, you might use Oracle SQL Plus to create one or two database accounts.

NOTE:  You also need to know the database connection details for the OLTP database that stores your transactional data that you want to upload to the Oracle Business Analytics Warehouse. For example, you might have an Oracle database account called OLTP that stores the transactional data.

To create the required databases

1. (Optional) In your target database tool (for example, Oracle SQL Plus), create a database or database account for the DAC metadata repository. For example, in Oracle SQL Plus you might create a database account named 'DAC'.

   If you perform step 1, you specify the name of the DAC metadata repository database (for example, DAC) when you log into the DAC (for more information about logging into the DAC, see Creating the DAC Metadata Repository).

2. In your target database tool (for example, Oracle SQL Plus), create a database account for the Oracle Business Analytics Warehouse tables. For example, in Oracle SQL Plus you might create a database account named 'OLAP'.

   NOTE:  Make sure that you specify this database account when you create the data warehouse tables in the DAC (for more information, see Process of Creating Data Warehouse Tables).

   If you omit step 1, you specify the name of the Oracle Business Analytics Warehouse database (for example, OLAP) when you log into the DAC (for more information about logging into the DAC, see Creating the DAC Metadata Repository).