HCL Workload Automation, Version 9.4

Customizing HCL Workload Automation to run IBM Cognos reports

You can customize HCL Workload Automation to run IBM Cognos report by using the CognosJobExecutor.properties file.

The CognosJobExecutor.properties file is a text file that contains the server credentials, the authentication information, and the dispatch servlet name you specified when configuring the IBM Cognos product.

The properties file is automatically generated either when you perform a "Test Connection" from the Dynamic Workload Console in the job definition panels, or when you submit the job to run the first time. Once the file has been created, you can customize it. This is especially useful when you need to schedule several jobs of the same type. You can specify the values in the properties file and avoid having to provide information such as credentials and other information, for each job. You can override the values in the properties files by defining different values at job definition time.

The file is located in the directory:

agent_install_dir/TWA/TWS/JavaExt/cfg

Where agent_install_dir is the path where you installed the HCL Workload Automation dynamic agent or the IBM Workload Scheduler for z/OS agent. Where agent_install_dir is the path where you installed the HCL Workload Automation dynamic agent.

You can define the properties contained in the .properties file, except the dispatchServlet value, at job definition time also. In this case, HCL Workload Automation uses the values you specify at job definition time for running the report. Table 1 describes the properties contained in CognosJobExecutor.properties.

Table 1. Properties for running IBM Cognos reports
Property	Description/value	Required
namespace	The IBM Cognos namespace to log on to. You do not need to specify this value if you set the true value for the Allow anonymous access? property in the IBM Cognos Configuration > Local Configuration > Security > Authentication > Cognos window.
username	The user to use when logging on to the namespace. You do not need to specify this value if you set the true value for the Allow anonymous access? property in the IBM Cognos Configuration > Local Configuration > Security > Authentication > Cognos window.
password	The password of the authorized user. It is encrypted in the agent configuration file when you retrieve any information by using a list, or when you submit the report. You do not need to specify this value if you set the true value for the Allow anonymous access? property in the IBM Cognos Configuration > Local Configuration > Security > Authentication > Cognos window.
serverAddress	The host name or TCP/IP address of the Cognos server you want to connect to.
serverPort	The port to use for the connection. The default value is 9300. If you use SSL, the default is 9334.
dispatchServlet	The dispatch you specified in the IBM Cognos Configuration > Environment > Dispatcher Settings window. The default value is /p2pd/servlet/dispatch.	✓

Example

This example shows a CognosJobExecutor.properties file.

namespace=cognosNamespace
username=userName
password=userPwd
serverAddress=nc112006
serverPort=9300
dispatchServlet=/p2pd/servlet/dispatch