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.
- 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.
- In the ODBC Data Source Administrator dialog box, click the System DSN tab.
- Click Add to open the Create New Data Source
dialog box.
- 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.
- 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.
- 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
- 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.
- 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:
- Select the data source name and click Configure to open the ODBC IBM DB2 - Add dialog box.
- Correct any information you want to change.
- Click OK twice to exit.