Getting started: Administrator

If you are an administrator, these tasks are a good place to get started.

About this task

Procedure

  1. Plan the deployment:
    1. Identify a machine for the data warehouse.
    2. Identify a machine for the report server.
    3. Identify a machine for the ETL server.
  2. Install and configure Rational® Integrated Data Warehouse on the data warehouse machine:
    Note: The installation program needs to be run on the actual database machine where the database is being hosted.
    1. If the database server installation did not include the client services, install the database client.
    2. For all other server that will be connecting to the warehouse, install the associated relational database management system client.
    3. Use the installer to install and automatically configure the Rational Integrated Data Warehouse.

      For DB2®, the installation is done on the DB2 named instance. If this instance does not exist, automatic installation is not possible. For SQL Server, you can specify the default instance or a named instance but make sure the authentication is set to mixed mode.

  3. Install the Rational Common Reporting Report Server:
    1. If you want to run the reporting server on an existing instance of WebSphere® Application Server, ensure that the existing instance is version is 6.1.0.15 or higher.
    2. If you are hosting the content store locally, install the database server and client. If your content store is hosted remotely, install the database client if the database server installation did not include the client services.
    3. If the data warehouse and content store do not use a database from the same vendor, install the database client of the data warehouse database.
    4. Use the installer to automatically install the report server.
  4. Configure the Rational Common Reporting Report Server:
    1. Set up the connections between the report server and the product data sources.
    2. Test-run the sample reports.
    3. Create users for accessing the data source.
  5. Install and configure the Rational Common Reporting development tools:
    1. Install the database client.
    2. Use the installer to install the report development component.
    3. Catalog Rational Integrated Data Warehouse.
    4. Set up the data source connections.
    5. Configure the data sources to run the extract, transform, and load (ETL) jobs.
  6. Customize the data warehouse and the ETL framework.
    1. Customize ETL builds
    2. Organize the XML data configuration files.
    3. Customize the data warehouse

Feedback