Archives

WebSphere Transformation Extender MQ PUT in IF statement

Call a MQ PUT or Get in a WTX Input or output card with an IF statement: IF ( Field1 < Field2, PUT("MQS","-QMN QM1 -QN WTX.OUT -DH", LEFT(PACKAGE(MessageDescriptor2 Header:In2),348)+PACKAGE(IndexNumber)+RIGHT(PACKAGE(MessageDescriptor2 Header:In2),12)+TEXT(In1) ),PUT("MQS","-QMN QM1 -QN WTX.OUT -DH", LEFT(PACKAGE(MessageDescriptor2 Header:In3),348)+PACKAGE(IndexNumber)+RIGHT(PACKAGE(MessageDescriptor2 Header:In3),12)+TEXT(In1) )) The WTX statement will test if Field 1 is bigger than Field 2 if True it […]

Rate this:

Read More

WebSphere Transformation Extender DB2 insert

WebSphere Transformation Extender can be used to insert transformed data into a Database in this case I used DB2. Below is the steps to follow to do a DB2 Insert into WTX: Step 1: Open WebSphere Transformation Extender Database Interface Designer. Select New to create a new Database Query File. Right Click on Databases to […]

Rate this:

Read More

Using WebSphere Transformation Extender inside Sterling Integrator

BM® WebSphere® Transformation Extender, formerly called DataStage TX, and hereafter referred to as WebSphere TX, has been part of the IBM WebSphere portfolio since 2005. WebSphere TX maps provide complex, any-to-any and many-to-many transformation capabilities that can be executed standalone or embedded into other IBM products such as WebSphere Message Broker, WebSphere ESB, and WebSphere […]

Rate this:

Read More

Websphere Transformation Extender Partner Manager Tutorial- Define Internal and External Trading Partners

Internal Partners 1. Open Partner Manager. 2. From the Address Book navigator, select Internal → X12.The Address Book for Internal X12 window opens. 3. Click Add.The Add X12 Trading/Application Partner window opens. 4. Complete the Fields in the Partner window. Below is an example: 5. Click Save. The Address Book will display the entry. 6. […]

Rate this:

Read More

Websphere Transformation Extender Partner Manager Tutorial- Define Database in Partner Manager

1. Start Partner Manager. From the Start menu, select Programs → IBMWebSphere Transformation Extender n.n → Trading Manager → PartnerManager. 2. Click on the Utilities icon in the Partner Manager tool bar. 3. On the Utilities navigator, click Database Settings. The Partner ManagerDatabase Selection dialog appears. 4. Select Microsoft Access from Database Vendor drop-down list […]

Rate this:

Read More

Websphere Transformation Extender Partner Manager Tutorial- Define ODBC Data Source

Trading Manager uses a relational database to store information about tradingpartners, routing instructions, access privileges, document tracking and tradingrelationships. A sample Microsoft Access database is included with the PartnerManager installation. 1. From the Windows Start menu, select Settings → Control Panel →Administrative Tools → Data Sources ODBC.The ODBC Data Source Administrator dialog opens. 2. Select […]

Rate this:

Read More

Websphere Transformation Error Handling in Websphere Message Broker

How to catch Websphere Transformation Extender Error in Websphere Message Broker: I have created a flow that will validate a message (WTX Validate) and also catch any error: The Transformation Errors can be put on a Queue to be consumed by an Monitoring tool, Exported to a file for debugging.

Rate this:

Read More

Websphere Transformation Extender with Websphere MQ

How do you set a input or Output Card to post the transformed or incoming file to a Websphere MQ queue? This will show how WTX can GET or PUT a untransformed or transformed input or output to a MQ queue. Step 1: Open up WTX Design Studio and create a Transformation map with input […]

Rate this:

Read More

Websphere Transformation Extender Launcher Monitor and Management Console

After you have created your WTX Launcher project as seen in the previous post you can get more information on your transformation in the Management Console in a text based interface and Launcher Monitor in a graphical interface. Setup the Management Console setup: 1. Open the Management Console and Click on Launcher New, complete the […]

Rate this:

Read More

Websphere Transformation Extender Launcher Tutorial

So how do you set up Websphere Transformation Extender Launcher to automatically transform incoming files with the correct transformation map en produce an output map. With this the launcher also comes with the Launcher Management Console which provides you detailed information on the status of transformed files. The Launcher Monitor provides you a graphical interface […]

Rate this:

Read More