Configuration for Single Schema

Data pertaining to the IBM® Sterling Selling and Fulfillment Foundation will point to a single schema. The following figure illustrates the setup required for a single schema.

Figure 1. Single Schema Setup

Configure the following data sources on Cognos® in order to represent individual table types in the IBM Sterling Selling and Fulfillment Foundation:

All the data sources will point to a single schema that is mentioned in the jdbc.properties file under the <INSTALL_DIR>/properties directory.