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 extract, transform, and load (ETL) process.
If you chose the automatic installation option while installing the IBM® Rational® Insight data warehouse,
the data warehouse for the ETL process is already prepared. No further
action is required.
Before you begin
- Ensure that you have installed the data warehouse component of Rational Insight 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.
About this task
If you chose the manual installation option while installing
the Rational Insight data
warehouse, create an empty database by running the script that is
placed by the installer on the computer when installation program
for IBM Rational Insight 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.