
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.
About this task
After you have installed the Data Warehouse feature, configure
it:
- If the option for automatic execution of scripts was not chosen
when the data warehouse component was installed, the installer only
creates batch files to set up the IBM Rational Insight data warehouse,
but does not run them. Run the batch file manually.
- The data warehouse with sample data is a backed up database file
that the installer places on the system. Restore this sample database
to the data warehouse.
Note: These steps are needed only if you chose to manually run
scripts when you installed the data warehouse server.
- Create the data warehouse:
- Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\dw directory.
- Run the install.bat batch file.
- When prompted, specify the parameters for the data warehouse.
To see a list of parameters and their explanations, see the related
links at the bottom of this page.
- Install the data warehouse with sample data:
Note: This
step is optional.
- Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\sampledw directory.
- Run the install.bat batch file.
- When prompted, specify the parameters for the data warehouse
with the sample data. To see a list of parameters and their explanations,
see the related links at the bottom of this page.