DB2 OLAP Server Installation Guide

Configuring SQL Interface on Windows

You can configure The SQL Interface on Windows from the Essbase CD, either at the same time you install the Essbase OLAP Server or after you have installed the Essbase OLAP Server.

To configure SQL Interface on Windows:

1. Make sure the relational database management system (RDBMS) environment is set up correctly. You must be able to connect to the RDBMS from the Essbase server machine before SQL Interface can work. Confirm that:
   1. The RDBMS server is installed and running. You must set the environment variables required to run the RDBMS. For more information, see your RDBMS documentation.
   2. The RDBMS database client software is installed on the machine where Essbase is (or will be) installed; for example, the correct version of Client Application Enabler (CAE) for DB2 is installed, or the correct version of Open Client for Sybase is installed.
   3. You can connect to the RDBMS.
   4. You can issue a query to the RDBMS using an RDBMS client utility.
2. Configure the ODBC data source. Before you can access relational data using SQL Interface, you must use the ODBC Administrator (odbcad32.exe) to tell DB2 OLAP Server what data sources are available and which drivers it should use. For detailed instructions, see the SQL Interface Guide.

   Additionally, On Windows NT and Windows 2000, each MERANT ODBC driver has its own help file. You can access it using the ODBC Administrator. The MERANT ODBC drivers come with a document called MERANT DataDirect Connect ODBC Reference. This reference is in PDF format for online viewing and printing in Adobe Acrobat Reader (Version 3.0.1 or later).

If you accept the default during installation, the installation program places all SQL Interface program files in the C:\ibm\db2olap\bin directory on your Windows computer. This includes esssql.dll, the ODBC driver files and their corresponding help (.hlp) files, and .bnd and .lic files. If you choose to install SQL Interface in a different directory from the default, the installation program stores the files in the bin directory in the appropriate path.

The SQL Interface installation program also installs ODBC driver files and their corresponding help and .pdf files in the ARBORPATH/ODBC/Merant40/Docs directory.