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:
  • Modify the VENDOR_FILE path to reflect your SI environment properties subdirectory.
  • Modify the "/myITXAproject/data/importfiles/envelopes" part to reflect the directory or file you want to import. With the above syntax, the entire contents of the directory "/myITXAproject/data/importfiles/envelopes" would be imported. The content could be modified to import a specific file, i.e: com.ibm.spe.core.utils.SPEImporter ${DBPROPS} quiet import="/myITXAproject/data/importfiles/envelopes/myenvelope.xml" refId=${REF_ID}
  • Assign execute permission to the script.
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>
  • In the above BP, make sure the workingDir assign is set to where you have saved the spesetup_and_import.sh script and that the cmdLine assign does not include a path, just the script name.
  • Note that if you make your working directory something other than the ITXA bin subdirectory that you have to change the spesetup_and_import.sh as well so that . ./spesetup.sh becomes . /spesetup.sh
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

Browse Categories

Share Blog Post

Pragma Edge (4.5/5)
4.5/5

Source:IBM

Recent Blog Posts - Read More

Sterling Data Exchange

Thank you for submitting your details.

For more information, Download the PDF.

Get Solution Brief

FileGPS - End To End File Monitoring

Subscribe to our newsletter

Elevate your approach to technology with expert-authored blogs, articles, and industry perspectives.

Thank You!

Thanks for signing up! We look forward to sharing resources and updates with you.

Continue to view our resources below.

Services
Contact us

Thank You!

Your Article submission request has been successfully sent. We will review your article & contact you very soon!

  • We don't provide Do-Follow links & we provide no follow backlinks to relevant blogs/articles
  • We don't promote company pages/services/training/products
  • We accpet free guest blogging with 1- no follow backlink
  • We will not publish Author bio, we will publish the article with author name.

Sign up for Free Trail

Community manager solution extends IBM Sterling B2B Integrator to deliver next-generation B2B and File Transfer capabilities that meet the growing demands of the customer.

Thank You!

Thanks for contacting us. We will reach you shortly!

Select Industry & Watch IBM Partner Engagement Manager Demo

Start SRE Journey to AIOPs

FileGPS - End To End File Monitoring

Pragma Edge Sterling Universe

Thank you for the Registration Request, Our team will confirm your request shortly.

Invite and share the event with your colleagues 

Return to home page

Pragma Edge Jarvis Monitoring tool (Jarvis)

Community Manager - PCM

Community Manager - PCM

To deliver next-generation B2B and File Transfer capabilities

Pragma Edge - API Connect

IBM Partner Engagement Manager Standard

IBM Partner Engagement Manager Standard is the right solution
addressing the following business challenges

IBM Partner Engagement Manager Standard

IBM Partner Engagement Manager Standard is the right solution
addressing the following business challenges

IBM Partner Engagement Manager Standard

IBM Partner Engagement Manager Standard is the right solution
addressing the following business challenges

Please Join us
On April 21 2021, 11 AM CT