DB2 OLAP Server Installation Guide

Configuring data sources on Windows systems

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:

  1. On the Windows desktop, open the Control Panel window and perform one of the following steps:
  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, such as 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 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.
  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.
  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 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.
  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.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]