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.

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.

Procedure

Create the data warehouse:
  1. Go to the C:\Program Files\IBM\RCPR\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.
    Note: Rational Common Reporting users must enter the default parameters when manually running the scripts.

Feedback