Installing the data warehouse on Windows® systems

Windows Install the Rational® Common Reporting databases on the data warehouse server.

About this task

The data warehouse server hosts the databases for the data warehouse, sample data warehouse, and content store.

Procedure

  1. Start the launchpad.exe file.
  2. Read the release information and ensure you have read the installation document.
  3. To begin the installation, click Install IBM Rational Common Reporting.
  4. Select Rational Common Reporting and click Next.
  5. Read the license agreements and if you accept, click I accept the terms in the license agreement, and click Next.
  6. Select Create a new package group, and click Next. By default, Rational Common Reporting is installed in C:\Program Files\IBM\RCPR.
  7. Select Data Warehouse, and the two data warehouse components (Data Warehouse and Data Warehouse with Sample Data), and click Next.
  8. In the Installation mode list, select Automatic: Create the databases for me.
  9. In the Database type list, select the type of database.
  10. Enter the required information for the database in all the fields.
    Note: You must be the owner of the directory where you want the tablespaces to be created.
    • DB2®: The database application location must be the directory up to but not including the bin directory of DB2; for example, C:\Program Files\IBM\SQLLIB.
    • Oracle Server: The database application location must be the ORACLE_HOME value up to but not including the bin directory; for example, C:\apps\oracle\product\11.1.0\db_1 and the and ORACLE_BASE value up to the base installation directory; for example, C:\apps\oracle.
    • Microsoft® SQL Server 2005: The database application location must include the instance folder; for example, C:\Program Files\Microsoft SQL Server\MSSQL.1.
  11. If you are using DB2, click Verify user. If the connection fails, make sure that the DB2 server is running and the administrator user name and password you entered are correct. If you are using Oracle or Microsoft SQL Server, ignore this step.
  12. Click Next. If the Next button remains unavailable, verify the following items:
    • If the database is installed at a location that is not the default location, the database application location points to the correct location.
    • The database name does not exist in the current database instance. By default, the data warehouse name is RIDW and the sample data warehouse name is SAMPLEDW.
    • The database server is running.
  13. Select Use a default directory to store the databases and make sure you have enough disk space and the access permission to store databases. If you do not want to install the databases to the default directory, click Browse to select another location. Click Next.
    Note: If you specify a different name and location for the databases, you need to perform additional manual steps for configuring the application.
  14. Read the change to license enforcement for versions 1.0.0.2 and later, and specify how you want to configure the license keys.
    • If you have installed and configured the Rational License Server, click Configure IBM Rational Common Licensing. In this case, the Rational Common Reporting server will be automatically configured to point to the Rational License Server for the Rational Common Reporting license keys.
    • If you are yet to install the Rational License Server, click I will configure the license server after the install or update. In this case, you must install and configure the Rational Common Reporting license keys yourself.
  15. Click Install. The installer copies the scripts required for database creation to the file system and automatically executes them to create and populate the databases.
  16. Click Finish.

Feedback