Contents


IBM Cognos integration with Sterling Selling and Fulfillment Suite on Linux

By following the steps described here you can integrate IBM Cognos 10 with Sterling Selling and Fulfillment Suite 9 on Linux

Comments

This paper discusses the integration of IBM Cognos BI Server with Sterling Selling and Fulfillment Suite.

Applicability

The techniques and product behaviors that are outlined here are validated against:

  • IBM Cognos BI Server 10
  • IBM Sterling Selling and Fulfillment Suite 9

Assumptions and exclusions

This document assumes that the reader has a basic understanding of the IBM Cognos and IBM Sterling Selling and Fulfillment Suite installation and configuration process. The techniques and product behaviors that are outlined in this document might not be applicable to the future releases.

Prerequisites

The following products need to be installed, configured, and running:

  • A full base installation of IBM Cognos BI Server 10, including gateway, dispatcher, Content Manager, and content store.
  • IBM Sterling Selling and Fulfillment Suite 9 with a clustered installation that consists of both Foundation, such as IBM Sterling Order Management System (OMS), and IBM Sterling Warehouse Management System (WMS) PCA.
  • IBM Sterling Multi-channel Fulfillment (SMCF) and IBM Sterling Warehouse Management System (SWMS) Analytics.
  • Integration steps: Follow steps 1 though 7 to integrate IBM Cognos with SSFS on Linux.

1. Create a Cognos Data Source connection

Configure Cognos data sources that are related to Cognos (sample compressed file name: WMS-Analytics.zip):

  • wms-configuration-default
  • wms-transaction-default
  • wms-meta
  • wms-master-default

Configure Cognos data sources that are related to OMS (sample compressed file name: SMCF-Analytics.zip):

  • smcf-configuration-default
  • smcf-transaction-default
  • smcf-meta
  • smcf-master-default

2. Modify the Cognos Cache Session

Disable or modify a Cognos Cache Session by following these steps:

  1. Rename the CQEConfig.xml.sample file to CQEConfig.xml. This file can be accessed by using the file path, <COGNOS_HOME>/c10/configuration/.
  2. Modify the session cache setting by opening the CQEConfig.xml file by using a text editor, such as Notepad, and change the value of the queryReuse parameter. This increases or decreases the number of cache requests for each session accordingly.
  3. By default the value of the queryReuse parameter is set to 5. To disable the session cache setting, set the value of the queryReuse parameter to 0.
  4. Save the CQEConfig.xml file.
  5. Using Cognos Configuration, stop the Cognos server, and restart it.

3. Deploy IBM Sterling Analytics

To deploy the IBM Sterling Warehouse Management System Business Intelligence Reports and import the WMS-Analytics.zip file into the Cognos Content Store (CS) repository, follow these steps:

  1. Set the YNW_ANALYTICS_HOME environment variable as the IBM Sterling Warehouse Management System Business Intelligence Installation directory.
  2. Set the Display environment variable appropriate to an X-Windows terminal.
  3. Set COGNOS_HOME environment variable as the parent of the Cognos 10 installation directory. For example, if Cognos 10 is installed on path /usr/local/cognos/c10 directory then COGNOS_HOME should point to /usr/local/cognos directory.

The ynwinstallanalytics.xml file assumes that Cognos 10 and IBM Sterling Warehouse Management System Business Intelligence (SMCF, SWMS Analytics) are installed on the same machine. If Cognos 10 and IBM Sterling Warehouse Management System (WMS) Business Intelligence are installed on two separate machines, use the command prompt modify the following line of XML by replacing localhost with the IP address of the machine where Cognos 10 is installed: <propertyname="cognosurl"value="http://<localhost>:<9300>/p2pd/servlet/dispatch"/>

NOTE: Ensure to copy the following third-party jar files from <COGNOS_HOME>/c10/webapps/p2pd/WEB-INF/lib to <YNW_ANALYTICS_HOME>/lib:

  • axis.jar
  • axisCrnpClient.jar
  • CAM_AAA_CustomIF.jar
  • commons-discovery.jar
  • commons-logging.jar
  • dom4j.jar
  • jaxrpc.jar
  • saaj.jar
  • wsdl4j.jar
  • xalan.jar
  • xercesImpl.jar
  • xml-apis.jar

4. Edit the Sterling Analytics file

  1. Save the <COGNOS_HOME>/c10/webapps/p2pd/WEB-INF/classes/analytics.properties.sample file as analytics.properties in the same directory.
  2. Change the value of sscap.app.url property in the analytics.properties file to point to the IBM Sterling Selling and Fulfillment Foundation Application URL by entering

sscap.app.url=http://<hostname>:<portnumber>/smcfs

For the hostname, enter either your computer name or the IP address of the computer where the IBM Sterling Selling and Fulfillment Foundation is installed. For the portnumber, enter the listening port of the computer that IBM Sterling Selling and Fulfillment Foundation is installed on.

5. Copy JAR files

If IBM Sterling Warehouse Management System (WMS) Business Intelligence and Cognos 10 are installed on the same machine, run the target copylib in ynwinstallanalytics.xml.

To do this, run the following command: <YNW_ANALYTICS_HOME>/bin: ant -f ynwinstallanalytics.xml copylib

On successful execution the command copies:

  • The <YNW_ANALYTICS_HOME>/lib/sscap-auth.jar to the <COGNOS_HOME>/c10/webapps/p2pd/WEB-INF/lib directory.
  • The <YNW_ANALYTICS_HOME>/bin/analytics.properties.sample to the <COGNOS_HOME>/c10/webapps/p2pd/WEB-INF/classes directory.
  • The <YNW_ANALYTICS_HOME>/deployment/WMS-Analytics.zip to the <COGNOS_HOME>/c10/deployment directory.
  • <YNW_ANALYTICS_HOME>/images/refresh.gif to the <COGNOS_HOME>/c10/webcontent/samples/images directory.

If IBM Sterling Warehouse Management System (WMS) Business Intelligence and Cognos 10 are installed on different machines:

  1. Copy the <YNW_ANALYTICS_HOME>/lib/sscap-auth.jar to the <COGNOS_HOME>/c10/webapps/p2pd/WEB-INF/lib directory on the machine.
  2. Copy the <YNW_ANALYTICS_HOME>/bin/analytics.properties.sample file to the <COGNOS_HOME>/c10/webapps/p2pd/WEB-INF/classes directory.
  3. Copy the <YNW_ANALYTICS_HOME>/deployment/WMS-Analytics.zip file to the <COGNOS_HOME>/c10 deployment directory.
  4. Copy the <YNW_ANALYTICS_HOME>/images/refresh.gif file to the <COGNOS_HOME>/c10/webcontent/samples/images deployment directory.

6. Publish the Sterling Package to the Cognos Content Store

Run the following command from <YNW_ANALYTICS_HOME>/bin directory:

<YNW_ANALYTICS_HOME>/bin: ant -f ynwinstallanalytics.xml

Figure 1. Command output
Screen capture of the command output
Screen capture of the command output

On successful execution, the command publishes IBM Sterling Warehouse Management System (WMS) Business Intelligence package with reports on the Cognos Content Repository.

Navigate to IBM Cognos Administration and check for the WMS-Analytics package as shown in figure 2:

Figure 2. Package in Cognos Administration
Screen capture of WMS
Screen capture of WMS

The steps to publish Sterling Multi-channel Fulfillment Analytics (SMCF) reports are similar to the steps discussed in this article. To publish Sterling Multi-channel Fulfillment Analytics (SMCF) reports, use the following steps as a guide:

  1. Deploy IBM Sterling Analytics
  2. Edit Sterling Analytics File
  3. Copy JAR files
  4. Publish Sterling Package to Cognos Content Store

7. Testing the integration

Open the application console of IBM Sterling Selling and Fulfillment Suite. Click the Business Intelligence tab to launch IBM Cognos Connection in a new window.

Figure 3. Test integration of Cognos with Sterling
Screen capture of IBM Cognos Connection in a new window.
Screen capture of IBM Cognos Connection in a new window.

Downloadable resources


Related topics


Comments

Sign in or register to add and subscribe to comments.

static.content.url=http://www.ibm.com/developerworks/js/artrating/
SITE_ID=1
Zone=Commerce, AIX and UNIX
ArticleID=1025605
ArticleTitle=IBM Cognos integration with Sterling Selling and Fulfillment Suite on Linux
publish-date=01142016