DB2 OLAP Server Installation Guide

Installing DB2 OLAP Integration Server on Windows

DB2 OLAP Integration Server is an add-on feature of DB2 OLAP Server. You can install it when you install DB2 OLAP Server, or you can install it separately.

To install the DB2 OLAP Integration Server separately:

1. Get ready to install. Verify that you have the necessary software product components and that the server and client computer systems on which you will install DB2 OLAP Integration Server meet system requirements.
2. Check for any migration issues. If you have existing applications that use the Relational Storage Manager, you must migrate them to the Multidimensional Storage Manager before installing DB2 OLAP Server Version 8.1.
3. Install DB2 OLAP Server if you have not already done so.
4. Install the server component of DB2 OLAP Integration Server from the DB2 OLAP Server CD-ROM.
5. Configure the Java Runtime Environment; see Setting up Java on Windows for more information.
6. Install the client component (the Essbase Integration Services Console) from the DB2 OLAP Server CD-ROM.
7. Configure a data source using ODBC. See Chapter 8, Configuring data sources for DB2 OLAP Integration Server. On the computer running DB2 OLAP Integration Server, create Open Database Connectivity (ODBC) connections to an OLAP Metadata Catalog data source and to the relational data source that you use for creating OLAP models and metaoutlines.
8. Create an OLAP Metadata catalog. See Chapter 9, Creating OLAP Metadata Catalogs for DB2 OLAP Integration Server for more information.
9. Set up the sample applications. See Samples for DB2 OLAP Integration Server.