In DB2 OLAP Integration Server, a data source must be configured for the relational database that contains user data (the Data Source database). A data source must also be configured for the relational database that contains the OLAP Metadata Catalog. Databases, including an OLAP Metadata Catalog, can run on any supported platform, provided that you have the ODBC driver and, in some cases, the database client software needed to access them.
The installation program installs DataDirect ODBC driver files that you use to configure data source names for both the Data Source database and OLAP Metadata Catalog database.
If database client software is required, the relational database management system (RDBMS) should include one of the database clients listed in Supported ODBC drivers and relational data sources. If your configuration requires database client software, ensure that the versions of the database client and the RDBMS are compatible.
This chapter provides information on how to configure ODBC drivers. For information on how to install and configure database client software, see the RDBMS documentation.
Integration Server runs on Windows 2000, Windows XP, Windows 2003, AIX, HP-UX, Solaris, or Linux. You must install Integration Server software, including ODBC drivers, and if required, database client software on the server computer.
The DB2 OLAP Integration Server client software runs on Windows 2000, Windows XP, or Windows 2003. You must install the Integration Services Console software on Integration Services client computers.
Configure the ODBC connections to the Data Source database and the OLAP Metadata Catalog database only on the computer running the server. You do not need to configure ODBC connections on client computers.
If you are using Oracle OCI direct connection, you connect DB2 OLAP Integration to both an OLAP Metadata Catalog database and 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.
For a complete list of supported ODBC drivers by platform, see Supported ODBC drivers and relational data sources.
For detailed information on the DataDirect Wire Protocol drivers provided with Integration Services, see the DataDirect Connect for ODBC Reference.