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.
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.