OLAP Setup and User's Guide

Loading and Configuring ODBC for the SQL Interface

The installation program does not load and configure the open database connectivity (ODBC) drivers. To use the SQL Interface add-on, you need to set up ODBC for DB2 and Merant database driver managers manually.

Setting Up the IBM DB2 ODBC Driver

To load and configure ODBC for IBM DB2 using the DB2 sample application:

1. Add the IBM DB2 ODBC driver to your system:
   1. Open the ODBC Data Source Administrator tool by running

      c:\essbase\bin\odbcad32.exe
      

      where c:\essbase is the drive and directory where you installed DB2 OLAP Server.

   2. Click the System DSN tab, and then click Add.
   3. On the Create New Data Source window, select IBM DB2 ODBC driver and click Finish.
   4. On the ODBC IBM DB2 Driver - ADD window, click Sample from the Data Source Name field, and click OK.
   5. Click OK on the ODBC Data Source Administrator window.
2. To test the ODBC connection, first bind an application to the database, then open an SQL data source. To bind the application:
   1. Open the DB2 Client Configuration Assistant tool.
   2. Select the SAMPLE database, and click Bind.
   3. On the Bind Database - Sample window, make sure the Bind user applications radio button is selected, and click Continue.
   4. In the Connect to DB2 Database window, type your user ID and password, and click OK.
   5. In the Bind Applications window, click Add.
   6. In the Bind Applications - Add File window, select all the *.bnd files from the c:\essbase\bin directory (qecsvi.bnd, qecswhvi.bnd, qerrvi.bnd, qerrwhv1.bnd, qeurv1.bnd, qeurwhv.bnd). Click OK.
   7. In the Bind Applications window, click OK. Make sure that there are no errors with the bind. Click Close.
3. Open the SQL data source in the Application Manager. This example uses the SALES table in the SAMPLE database:
   1. Open the Application Manager and log on to the server.
   2. Click File --> New --> Data Load Rules. The Data Prep Editor window opens.
   3. Click File --> Open SQL. The Select Server, Application, and Database window opens.
   4. Click OK. The Define SQL window opens.
   5. In the From field, select the SAMPLE database, and type SALES. Click OK/Retrieve.
   6. On the next window, type your user ID and password, and click OK. The contents of the SALES table are displayed in the Data Prep Editor window.

Setting Up the Merant ODBC Driver

To load and configure ODBC for Merant using the sample application:

1. Add the Merant ODBC driver to your system:
   1. Open the ODBC Data Source Administrator tool by running c:\essbase\bin\odbcad32.exe, where c:\essbase is the drive and directory where you installed DB2 OLAP Server.
   2. Click the System DSN tab, and then click Add.
   3. On the Create New Data Source screen, select the Merant DB2 ODBC driver and click Finish.
   4. On the ODBC Merant DB2 Driver setup window, make sure the data source name is SAMPINT and the database name is SAMPLE, and click OK.
   5. Click OK on the ODBC Data Source Administrator window.
2. To test the ODBC connection, first bind an application to the database, then open an SQL data source. To bind the application:
   1. Open the DB2 Client Configuration Assistant tool.
   2. Select the SAMPLE database and click the Bind button.
   3. On the Bind Database - Sample window, make sure the Bind user applications radio button is selected, and click Continue.
   4. In the Connect to DB2 Database window, enter your user ID and password, and click OK.
   5. In the Bind Applications window, click Add.
   6. In the Bind Applications - Add File window, select all the *.bnd files from the \essbase\bin directory: qecsvi.bnd, qecswhvi.bnd, qerrvi.bnd, qerrwhv1.bnd, qeurv1.bnd, qeurwhv.bnd. Then click OK.
   7. In the Bind Applications window, click OK. Make sure there are no errors with the bind. Click the Close button.
3. Open the SQL data source in the Application Manager. This example uses the SALES table in the SAMPLE database:
   1. Open the Application Manager and log on to the server.
   2. Click File --> New --> Data Load Rules. The Data Prep Editor window opens.
   3. Click File --> Open SQL. The Select Server, Application, and Database window opens.
   4. Click OK. The Define SQL window opens.
   5. In the From field, select the SAMPINT data source, and type SALESin the From field. Click OK/Retrieve.
   6. On the next window, enter your user ID and password. The contents of the SALES table are displayed in the Data Prep Editor window.