If you are an administrator, these tasks are a good place
to get started.
Procedure
- Plan the deployment:
- Identify a machine for the data warehouse.
- Identify a machine for the report server.
- Identify a machine for the ETL server.
- 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.
- If the database server installation did not include
the client services, install the database client.
- For all other server that will be connecting to the
warehouse, install the associated relational database management system
client.
- 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.
- Install the Rational Common Reporting Report Server:
- 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.
- 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.
- 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.
- Use the installer to automatically install the report
server.
- Configure the Rational Common Reporting Report Server:
- Set up the connections between the report server and
the product data sources.
- Test-run the sample reports.
- Create users for accessing the data source.
- Install and configure the Rational Common Reporting development tools:
- Install the database client.
- Use the installer to install the report development
component.
- Catalog Rational Integrated Data Warehouse.
- Set up the data source connections.
- Configure the data sources to run the extract, transform,
and load (ETL) jobs.
- Customize the data warehouse and the ETL framework.
- Customize ETL builds
- Organize the XML data configuration files.
- Customize the data warehouse