The process of configuring the data warehouse for IBM® Rational® Insight depends
on the relational database management system being used to host the
data warehouse.
Configuring the DB2 data warehouse If you chose to manually run scripts when you installed the
data warehouse server, additional steps are needed to configure the
data warehouse. Make sure that the batch files for setting up the
data warehouse are run successfully. Optionally, restore the data
warehouse with the sample data to the data warehouse and use it as
your IBM Rational Insight data
warehouse; the data warehouse with the sample data contains data with
which you can test Rational Insight.
Configuring the Microsoft SQL Server data warehouse If you chose to not automatically run scripts when you installed
the data warehouse server, additional steps are needed to configure
the data warehouse. By default, Windows® authentication
is used for the Microsoft® SQL
Server instance and database. Therefore, you need to ensure that the
users of the report server connecting to the database and executing
queries are valid Windows users
of the data warehouse server. Also, you need to ensure that the batch
files for setting up the data warehouse run successfully. Optionally,
restore the data warehouse with the sample data and use it as your IBM Rational Insight data warehouse;
the the data warehouse with the sample data contains data with which
you can test Rational Insight.
Configuring the Oracle Server data warehouse Make sure that the batch files for setting up the data warehouse
run successfully. Optionally, restore the data warehouse with the
sample data to the data warehouse and use it as your IBM Rational Insight data warehouse;
the data warehouse with the sample data contains data with which you
can test Rational Insight.