Configuring the Microsoft SQL Server data warehouse

Windows 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:
Note: These steps are needed only if you chose to manually run scripts when you installed the data warehouse server.
  1. Create the data warehouse:
    1. Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\dw directory.
    2. Run the install.bat batch file.
    3. 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.
  2. Install the data warehouse with sample data:
    Note: This step is optional.
    1. Go to the C:\Program Files\IBM\Rational Insight\datawarehouse\sampledw directory.
    2. Run the install.bat batch file.
    3. 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.

Feedback