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 can be done by specifying the Privileges in the DB2 Control Centre.

Step 2: Test the connection to verify all information is correct.

Step 3: Create your integration flow

Step 4: Specify the DB2 Endpoint created in Step 1 and select the table and row you want the data to be inserted into

Step 5: Create the input and output maps for both activities

Step 6: Verify and test the flow.

This flow will update a website that is located in a cloud environment (like Amazon EC2) and updated an on-premise DB2 instance.

File Transfer Integration flow with Websphere Cast Iron

How to integrate file transfer with Cast Iron

Step 1: Create or start your ftp server (in this case I just use FileZilla Server)

Step 2: In your file server create a user or role and specify the permissions of the user and some username and password

Step 3: Create an FTP endpoint by specifying:

  • FTP Host Name
  • FTP Port Number
  • FTP Username
  • FTP Password

Step 4: Test the connection by clicking on the ‘Test Connection’ button.

Step 5: Create your FTP integration flow

In this flow we will be moving Files from a Cloud Server to a local user machine

Step 6: Specify the folder of the file from origin to destination

Step 7. Test the integration flow by dropping a file into the origin folder and see if it has been move to the destination folder.

    Cast Iron Websphere MQ integration Flow

    How to integrate Websphere MQ integration flow with Cast Iron tutorial.

    Before starting this tutorial make sure that you have the MQ jar files added to the -> Install Module Providers Menu

    Step 1: Create a Websphere MQ endpoint by specifying the following information:

    • Websphere MQ hostname
    • Websphere MQ port
    • Queue Manager Name
    • Server Connection Channel Name
    • MQ Privilege User – Username
    • MQ Privilege User – Password

    Step 2:  On Websphere MQ Explorer create the following:

    • Local Queue
    • Create Server Connection Channel

    Step 3: Create your integration Flow

    Step 4: Specify the the MQ Endpoint as one create in Step 1

    Step 5: Create the input and output maps for the two activities.

    Step 6: Verify and test the integration flow.

    Setup Websphere Cast Iron Virtual Appliance

    How to setup Websphere Cast Iron Virtual Appliance.

    Step 1: Get the iso file for the virtual appliance, the one used for this scenario was: factory-19k-official-5_0_0_6-102.iso

    Step 2: Open VM Workstation and create a new virtual appliance, see the steps below:

    Step 3: As you can see we have added another Network adapter that is also bridged. Please make sure your VM has not started before you add another Network Adapter, the reason for this is the one Network Adapter is for the Web and the other for the Data.

    Step 4: Config the New DVD/CD Settings to the following:

    Step 5: Run the virtual appliance and after it has started up the first command to run is: install

    Step 6: Enter the value 1 into the console to start the Installation.

    Step 7: Select Fresh Install

    Step 8: Select yes to confirm that you would like to start a fresh install of the Cast Iron Appliance

    Step 9: Press any key to continue

    Step 10: Select the option ‘Exit and Reboot’

    Step 11: Add your virtual identity to register your appliance. The command looks as follows and fill in your appliance ID where … is specified.

    Step 12: After you have registered the virtual appliance you can call the help keyword to see all the relevant keywords.

    Step 13: View the two interfaces for the appliance:

    Step 14: Log into into the appliance with any browser:

    Now you are ready to deploy Cast Iron flows into your virtual appliance.

    Cast Iron integration into the current IBM ESB stack

    So where does Cast Iron fit into the IBM Websphere stack?Cast Iron primary used for Cloud to on-premise integration. Where you can create a message flow diagram using the Cast Iron Studio and deploy that flow to the following environments:

    1. Cast Iron Appliance (which is now the Datapower XH35 Cast Iron V5.1)

    http://www.castiron.com/ibm/websphere/datapower/castiron/appliance/xh35

    2. The virtual Cast Iron appliance which can be installed in VMWare.

    3. Amazon EC2

    So how can you integrate Cast Iron with current IBM ESB’s:

    1. Datapower XI50

    2. Websphere Message Broker

    3. WESB (Websphere ESB)

    The simple answer is:

    1. Websphere MQ

    2. Web Services

    Cast Iron integrates natively to Websphere MQ and any Web Services call can be made. This is a great addition to the IBM Stack and will be a great solution for customers that want to do any cloud integration.