How can a Sterling B2B Integrator Business Process be created to use the IBM Transformation Extender Advanced speimport utility?

Question

How can a Sterling B2B Integrator Business Process be created to use the IBM Transformation Extender Advanced speimport utility?

Answer

The speimport.sh|bat utility which is used to import IBM Transformation Extender Advanced (ITXA) resources (maps, envelopes, schemas, etc) is typically invoked from the command line. This utility can also be incorporated into a Sterling B2B Integrator (SI) Business Process. To accomplish this using a UNIX operating system, as an example, take the following steps:
1) Create a script, for example, spesetup_and_import.sh, that has content similar to the following. Note paths used with the scripts are for example purposes only:
				
					#!/bin/bash 

# Setting ITXA environment

. ./spesetup.sh

VENDOR_FILE=/opt/ibm/SI/install/properties/servers.properties

DBPROPS=dbprops="${SPE_INSTALL_DIR}/dbprops.cfg" 

# Running a custom script

${JAVA_HOME}/bin/java  -Dvendor=shell -DvendorFile=${VENDOR_FILE}

com.ibm.spe.core.utils.SPEImporter ${DBPROPS} quiet import="/myITXAproject/data/importfiles/envelopes" refId=${REF_ID}
				
			
In this script you will have to:
2) Once the script is created the next step is to create a business process (BP), using the Command Line Adapter to invoke the script. An example BP is shown below:
				
					<process name="BP_calling_speimport">
<sequence>
<operation name="RunScript">
<participant name="CLA2_calling_speimport" />
<output message="xout">
<assign to="remoteName">localhost</assign>
<assign to="cmdLine">spesetup_and_import.sh</assign>
<assign to="workingDir">/opt/ibm/StandardsProcessingEngine9.0.0/bin</assign>
<assign to="waitOnProcess">true</assign>
<assign to="setSoTimeOut">12000</assign>
<assign to="." from="*" />
</output>
<input message="xin">
<assign to="." from="*" />
</input>
</operation>
</sequence>
</process>
				
			
This BP / script will generate a Null Pointer Exception error. To eliminate this error take the following steps:
				
					1. Append the following entry to the <si_install_dir/properties/servers.properties.in file: log=&LOG_DIR;/noapp.log
2.Run the SI setupfiles.sh utility
3. Stop SI
4. Start SI and test the BP



				
			
Pragma Edge, IBM Gold Partner, IBM, Pragmaedge,

Sterling File Gateway Tutorial

Electronic Banking Internet Communication Standard (EBICS) is an Internet-based communication and security standard that is primarily used for remote data transfer between your organization

Read More »