Configuring relational data sources for DB2 OLAP Integration Server

To create OLAP models or build metaoutlines, you must connect DB2 OLAP Integration Server to a database that contains metadata (the OLAP Metadata Catalog database) and to a database in which user data is stored (the Data Source database). To make these connections, you must configure a data source name for an OLAP Metadata Catalog database and a Data Source database. You do this by mapping a supported Open Database Connectivity (ODBC) driver to each database.

Note:
You are not required to use two different databases for your Data Source database and OLAP Metadata Catalog database. Additionally, you are not required to use two different data source names to connect to the Data Source database and OLAP Metadata Catalog database if the two databases reside in the same database.

On Windows, use the ODBC Administrator to configure ODBC data sources. On UNIX, edit the odbc.ini file using a text editor such as vi. You cannot use the odbcconfig utility because it is no longer included in DB2 OLAP Integration Server. All ODBC data source names are configured only on the computer that runs DB2 OLAP Integration Server.

Note:
If a supported ODBC driver is already mapped to a Data Source database, you do not need to map it again. In this case, you need to map a supported ODBC driver only to the OLAP Metadata Catalog database.

If you are using Oracle OCI direct connection, you connect Integration Services to an OLAP Metadata Catalog database and to a Data Source database when you access the databases in Integration Services Console. This process is described in Connecting to Integration Server and Connecting to data sources.

This chapter contains the following topics that describe how to configure data sources: