Preparing to set up the standard sample application

Before you set up the standard sample application, you must install the database client software for a supported RDBMS. When setting up the standard sample application, you must use a computer on which the server component of DB2 OLAP Integration Server and the necessary database client software are both installed. For more information, see About data source configuration.

For manual setup of the standard sample application, the standard sample application scripts do not have to be installed on the same computer that you are using, but you must be able to access the script files.

Note:
IBM strongly recommends that you use the automatic installation process to install the standard sample applications (see Setting up the standard sample application automatically).

In addition to the sample application scripts, the standard sample application requires the database client software for the RDBMS that you are using. The database client software is required to run the standard sample application scripts.

If you are using Oracle OCI direct connection, verify that the database client software for the RDBMS is installed. If you choose to set up the standard sample application manually, refer to Table 22 and also verify that the appropriate client utility program is installed.

Table 22. Required Utilities for Setting Up the Standard Sample Application
Database Utility Programs
DB2 UDB DB2 Command Window or >DB2 -tvf
Informix DBAccess
MS SQL Server Query Analyzer (MS SQL Server 7.0 and 2000)
Oracle SQL*Plus
Sybase
  • ISQL
  • BCP command line utility
Teradata BTEQ

The remainder of this chapter assumes that you have installed the required database client software.