Archives

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

Setup Websphere MQ File Transfer Database Logger

Step 1. Run the following db2 command: — drop if necessary and then create FTELOGDB echo ******************************************************* echo the following command may fail because the database did echo NOT previously exist, this is an acceptable error echo ******************************************************* drop database FTELOGDB echo — Creating database FTELOGDB create database FTELOGDB echo — Connect to FTELOGDB database […]

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