The data warehouse holds the configuration information
of the product data sources. It also holds the normalized operational
data store, and the transformed fact and dimension tables, all of
which are loaded through the ETL process. If you chose the automatic
installation option while installing the Rational® Common Reporting data warehouse, the data warehouse for the ETL process
is already prepared and no further action is required.
Before you begin
- Ensure that you have installed the data warehouse component of Rational Common Reporting on the data warehouse server.
- If you intend to run the ETL processes on a machine different
from the one of which the data warehouse server is installed, ensure
to install the database client of the data warehouse on the machine
to be used for the ETL processes.
Procedure
- If you chose the manual installation option while installing
the Rational Common Reporting data warehouse, create a database by running the script
that is placed by the installer on the computer when installation
program for Rational Common Reporting is run. The instructions for locating the script and the
steps for running the script are explained in the Configuring the
data warehouse section of the Installing and Upgrading topics (related
links at the bottom of this page).
- For database users having access to the data warehouse,
grant the following access privileges: select, insert, update, delete,
analyze table, compute, stored procedure execution, and stored function
execution. For information about granting privileges to users, see
the database product documentation.