DB2 OLAP Server Installation Guide

Configuring the OLAP metadata catalog on Windows systems

To configure an OLAP Metadata Catalog on Windows NT or Windows 2000, start ODBC Administrator and then create a connection to the data source that contains the OLAP Metadata Catalog database.

This example creates a DB2 data source. Dialog boxes for other RDBMSs will differ.

1. On the Windows desktop, open the Control Panel window and perform one of the following steps:
   • On Windows NT, double-click the ODBC icon to open the ODBC Data Source Administrator dialog box.
   • On Windows 2000, double-click the Administrative Tools icon, and then double-click the Data Sources (ODBC) icon to open the ODBC Data Source Administrator dialog box.
2. In the ODBC Data Source Administrator dialog box, click the System DSN tab.
3. Click Add to open the Create New Data Source dialog box.
4. In the driver list box of the Create New Data Source dialog box of ODBC Administrator, select an appropriate driver--for example, IBM DB2 ODBC Driver--and click Finish to open the ODBC IBM DB2 Driver - Add dialog box.
5. In the ODBC IBM DB2 Driver - Add dialog box Database alias drop-down list, select the name of the database for your OLAP Metadata Catalog (for example, TBC_MD in the sample application). The name of the selected database is automatically displayed in the Data Source Name text box.
6. If you want to change the name of the data source, select the name displayed in the Data Source Name text box, press Enter, and type the name you want to use for the data source. For example, you might type the following name to indicate that you are using the driver to connect to the first OLAP Metadata Catalog:

   OLAP Catalog #1 
   

   You would type the following name to indicate that you are connecting to the sample application OLAP Metadata Catalog database:

    TBC_MD
   

7. In the Description text box, type an optional description that indicates how you use this driver and click Add. For example, type the following words to describe the OLAP Metadata Catalog:

   My first models and metaoutlines
   

   You might type the following words to describe the sample application OLAP Metadata Catalog database:

   Sample models and metaoutlines
   

   The descriptions help you to identify the catalog that you want to select when you connect to the OLAP Metadata Catalog from Essbase Integration Services Console.
8. Click OK to return to the ODBC Data Source Administrator dialog box. The data source name you entered and the driver you mapped to it are displayed in the System Data Sources list box on the System DSN tab.

To edit configuration information for a data source:

1. Select the data source name and click Configure to open the ODBC IBM DB2 - Add dialog box.
2. Correct any information you want to change.
3. Click OK twice to exit.