Processing a WebSphere Queue

Create an empty job.

Select and drag the Websphere Queue Writer transformation from the Access folder in the Transformations tree into the empty job in the Diagram tab in the Job Editor window.

Drop the source table for the queue in the Diagram tab.

Connect the source table to the input port of the Websphere Queue Writer transformation.

Drop the queue from the Message queue folder in the Inventory tree in the Diagram tab.

Connect the queue to the output port of the Websphere Queue Writer transformation. The job resembles the sample shown in the following display.

Open the Queue Options tab of the properties window for the Websphere Queue Writer transformation.

Select Table in the Message Type group box. Save the setting and close the properties window.

Run the job. If you are prompted to do so, enter a user ID and password for the default SAS Application Server that generates and runs SAS code for the job. The server executes the SAS code for the job.

If the job completes without error, go to the next section. If error messages appear, read and respond to the messages.

Open the IBM WebSphere Queue Explorer application.

Select the queue that you created and ran. Then, verify that the expected messages are sitting on the queue.

Create an empty job.

Select and drag the Websphere Queue Reader transformation from the Access folder in the Transformations tree into the empty job in the Diagram tab in the Job Editor window.

Drop the queue that you created and ran on the Diagram tab.

Connect the queue to the input port of the Websphere Queue Reader transformation.

Because you want to have a permanent target table to contain the output for the transformation, right-click the temporary work table that is attached to the transformation and click Replace in the pop-up menu. Then, use the Table Selector window to select the target table for the job. The target table must be registered in SAS Data Integration Studio. (For more information about temporary work tables, see Working with Default Temporary Output Tables.)

After these steps have been completed, the process flow diagram for this example resembles the following display.

Open the Queue Options tab of the properties window for the Websphere Queue Reader transformation.

Select Table in the Message Type group box. Save the setting and close the properties window. Remember that you verified that the message queue contained the messages from the source table in the Verify the Websphere Queue Writer Job section.

Run the job. If you are prompted to do so, enter a user ID and password for the default SAS Application Server that generates and runs SAS code for the job. The server executes the SAS code for the job.

If the job completes without error, go to the next section. If error messages appear, read and respond to the messages.

Access the View Data window for the source table.

Access the View Data window for the target table. A sample target table is shown in the following example.

The source table and the target table contain identical data. This means that the data was transferred successfully through the Websphere message queue. If you do not see the data that you expected, check the Message Format column on the Columns tab in the Websphere Queue Reader properties window. To access this window, right-click Websphere Queue Reader and click Properties in the pop-up menu. Then, you can correct the formats as needed.