Set Up Database Connectivity for the Controller Database

For IBM Cognos Controller, the Controller Web Services Server access the Controller database. The Web server must be able to connect to the Controller database.

Procedure

Ensure that you install the database API software for your reporting sources on each computer where Application Tier Components are installed.

On Windows, Application Tier Components support either native database connectivity or ODBC. On UNIX and Linux, Application Tier Components support the native database connectivity.

On UNIX, for Microsoft SQL Server only, Application Tier Components support the Data Direct ODBC driver. This driver is available from Data Direct.

IBM® Cognos® Controller requires TCP/IP connectivity with the Microsoft SQL Server.