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

Create DB2 Data Source for WebSphere Application Server

How to create a DB2 Data Source for Websphere Application Server: Step 1: Click on Resource -> JDBC -> JDBC Provider -> New Confirm that the scope of the JDBC Connection is correct -> Node level. Step 2: Complete the JDBC Provider Fields. Database type : DB2 Provider type: DB2 Universal JDBC Driver Provider Implementation […]

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

Insert row DB2 with Websphere Cast Iron

How to insert a row into DB2 using Websphere Cast Iron. Step 1: Create an DB2 Endpoint by specifying the following information: DB2 Database Name DB2 Host Name DB2 Port Number DB2 Username DB2 Password Please make sure that the Cast Iron appliance or Virtual image has rights to insert a row onto DB2. This […]

Rate this:

Read More

Salesforce and DB2 integration with Cast Iron

Below is a short tutorial on how to integrate Salesforce with IBM DB2 using Cast Iron. 1. Define your SalesForce Endpoint by providing the following information (you must be a registered member of Salesforce): Username Password Ste 2: Test the connection and make sure that it is successful. Step 3: Define the DB2 Endpoint by […]

Rate this:

Read More