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.
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.
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: