A relational data source, including an OLAP metadata catalog, can run on any platform if you have the database client software and ODBC driver needed to access it. You must obtain and configure both the database client software and the ODBC driver.
DB2 OLAP Integration Server, ODBC, and the database client software must be installed on the same computer.
The relational database management system (RDBMS) must include one of the following database clients:
Ensure that the versions of the database client and the RDBMS are compatible. This chapter provides information on how to configure the ODBC drivers. For information on how to install and configure the database client, see the RDBMS and database client documentation.
The client software for the RDBMS and the ODBC driver must be installed on the same computer as Essbase Integration Server. The database client software works with the ODBC driver to make ODBC connections to RDBMS databases.
On Windows systems, environment changes needed for running the database client software should be completed automatically by the RDBMS client installation program. For information about additional configuration of the database client software, see the installation documentation for the RDBMS that you are using.
Before proceeding with the configuration of data sources using ODBC, make sure you can connect to RDBMS databases and access tables while logged on with the user account you use to run Essbase Integration Server. Use the SQL command line utility provided with the database client software that you are using.
For information about installing and configuring database client software, see the installation documentation for the RDBMS that you are using.
DB2 OLAP Integration Server supports specific ODBC drivers for connecting to RDBMSs. For a list of supported ODBC drivers by platform, see Supported ODBC drivers and relational data sources.
For detailed information on the MERANT drivers provided with Essbase Integration Services, see the MERANT DataDirect Connect ODBC Reference, which is available on Windows from the Start > Programs > IBM DB2 OLAP Server 8.1 > Documentation information map.