HCL Workload Automation, Version 9.4

Customizing HCL Workload Automation to run Informatica PowerCenter jobs

A property file is added in the plug-in configuration directory on the agent to provide plug-in configuration parameters and repetitive keys.

The PowerCenterJobExecutor.properties file is a text file that contains configuration parameters. The file is located on the HCL Workload Automation agent in the TWS_home\JavaExt\cfg (/JavaExt/cfg) directory.

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 contains two types of properties for the use of the plug-in jobs:
  • Credential properties that are repeated in all the plug-in job definitions. If you specify them in this file, you can leave the corresponding fields blank in the job definition and the values are retrieved from the properties file at runtime.
    The properties are:
    userName
    The name used to access the repository.
    password
    The password used to access the repository. The password is encrypted the first time it is used (either in a pick list or at the runtime of a job).
    repositoryDomain
    The domain where the repository is located.
    serviceDomain
    The domain where the Integration Service is located.

    The values specified for any of these properties in the file are overridden by the job definition values when entered in the corresponding fields.

  • Properties required to establish a connection with the Informatica Web Services Hub. It is mandatory that you specify these properties in the file.
    The properties are:
    hostName
    The hostname or the IP address of the computer hosting the Informatica Web Services Hub; that is, the service that provides the web services used for accessing the workflows.
    port
    The port number of the Informatica Web Services Hub.
    isSSLEnabled
    Specifies if the Informatica Web Services Hub is enabled to the SSL protocol. Set this property to true or false.

    If IsSSLEnabled=true, you must also change the JVMOption key in file JobManager.ini located in directory TWS_home/ITA/cpa/config (\ITA\cpa\config) on the agent. See Configuring the agent for SSL.

    use_load_balancer
    Specifies if the Informatica Web Services Hub is behind a load balancer. Set this property to YES or NO.

    If use_load_balancer=YES, you must also set errorMsgs=TimeOut, and checkWfStatusBeforeWait=true.

    polling
    This property is effective only if use_load_balancer=YES. It specifies the monitoring frequency of the workflow status. Set this property to NO or to an integer equal to or greater than 1000 (milliseconds). If you specify polling=1000, the workflow status is retrieved every second. Set polling=NO if use_load_balancer=NO.
    no_infa_log
    Specifies if you do not want to retrieve the Informatica PowerCenter workflow output in the HCL Workload Automation job log. Set this property to YES if you do not want to retrieve the workflow output, otherwise set this property to NO.
    errorMsgs
    This property is effective only if use_load_balancer=YES. It sets a pipe "|" as delimiter for error messages. If use_load_balancer=YES, set this property to TimeOut and never modify this value.
    checkWfStatusBeforeWait
    This property is effective only if use_load_balancer=YES. It specifies if the Informatica PowerCenter workflow status has to be monitored. If use_load_balancer=YES, set this property to true, otherwise set this property to false.
In the file the properties are specified each in a line, using the key=value syntax. See the following example: 
port=7334
password=mypassword
isSSLEnabled=false
userName=Administrator
serviceDomain=Domain_NY004114
hostName=NY004114.citylab.com
repositoryDomain=Domain_NY004114
use_load_balancer=YES
polling=No
no_infa_log=YES
errorMsgs=TimeOut
checkWfStatusBeforeWait=true