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.
  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 for your operating system.
  5. Make sure you have Java Runtime Environment set up on your system. See Updating the path for Java on Windows (optional) for more information.
  6. Install the client component (the Essbase Integration Services Console) from the DB2 OLAP Server CD-ROM for Windows.
  7. Configure a data source using ODBC. See Configuring relational 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 Creating, upgrading, and deleting OLAP Metadata Catalogs for more information.
  9. Set up the sample applications. See Setting up the sample application for DB2 OLAP Integration Server.