To configure a relational data source on Windows NT, Windows 2000, or Windows
XP systems, you must have an Open Database Connectivity (ODBC)
connection from the DB2 OLAP Integration Server to the relational data source and to the OLAP Metadata
Catalog. DB2 OLAP Integration Server V8.1 requires an odbc.ini file for operation of
ODBC, and this file is in the Registry under \HKEY_LOCAL_MACHINE\SOFTWARE\ODBC. Use ODBC Data Source Administrator to store information about how
to connect to a relational data source. The ODBC.ini file is available in
ODBC software packages and is included with Microsoft Office software. For
more information about applications that install ODBC drivers or the ODBC
Administrator, visit the Microsoft support Web site.
Start ODBC Administrator and then create a connection to the data source
that you will use for creating OLAP models and metaoutlines. Run the ODBC
Administrator utility from the Windows Control Panel.
The following example creates a DB2 data source. The dialog boxes for other
RDBMSs will differ.
To configure a relational data source with ODBC Administrator:
- 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, such as 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 relational data source (for
example, TBC 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.
- 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 My Business
database:
Customers, products, markets
You might type the following
words to describe the sample application database:
Sample relational data source
The descriptions help to identify the available data sources for your
selection when you connect 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.