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

Question

Answer

#!/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}  

• 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.

<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

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  

Source:IBM