Integrating applications using WebSphere Business Integration Message Broker V5: Part 3B: Using ESQL to develop message flow applications

Level: Intermediate

Milorad Stefanovic (milorads@ca.ibm.com), Staff Software Developer, IBM Toronto Laboratory
Kim Tsao (ktsao@ca.ibm.com), Staff Software Developer, IBM Toronto Laboratory
Suman Kalia (kalia@ca.ibm.com), Advisory Software Developer, IBM Toronto Laboratory

08 Jun 2005
Updated 11 Jul 2005

	Get the download

Extended Structured Query Language is a programming language that is used to define and manipulate data within a message flow. This article describes how to use ESQL in WebSphere Business Integration Message Broker to transform the message contents and customize the behavior of message flow nodes.

WebSphere® Business Integration Message Broker (hereafter called Message Broker) uses Extended Structured Query Language (ESQL) to define and manipulate data within a message flow. ESQL is derived from the Standard Query Language (SQL), and like SQL, it has the ability to access and update databases, as well as -- provide extensions particularly suited to manipulating message data structures.

This is Part 3B in a six-part series on Message Broker V5. Part 3A introduced the concept of message flows, broker schemas, and the tools used for creating and building message flow applications. In this article you will see how to use the ESQL language to transform and manipulate the contents of messages. You will learn about tools for building ESQL program modules to customize the behavior of message flow nodes.

You might also be interested in the other articles in this series:

• Part 1: Integration Scenario -- Creating a Web Order processing application
• Part 2: Message set development
• Part 3A: Using message flows to integrate applications
• Part 4: Message Transformation using Message Broker mappings
• Part 5: Custom message flow node development
• Part 6: Debugging message flows using Websphere Message Broker

Download

Description	Name	Size	Download method
Article in PDF format	0506_kalia3b.pdf	.6 MB	FTP|HTTP

	Information about download methods			Get Adobe® Reader®

About the authors

		Milorad Stefanovic is a Staff Software Developer at IBM Toronto Laboratory in Toronto Ontario. He the team lead for Extended SQL development tools and is also working on the Mapping Framework for WebSphere Business Integration Message Broker. Milorad received MSc in Software Engineering from the University of Alberta and is currently pursuing MBA program at the Schulich School of Business, York University. You can reach Milorad at milorads@ca.ibm.com.

		Kim Tsao is a Staff Software Developer at IBM Toronto Laboratory in Toronto, Ontario. She works on the mapping tools for WebSphere Business Integration Message Broker. You can reach Kim at ktsao@ca.ibm.com.

		Suman Kalia is an Advisory Software Developer at IBM Toronto Laboratory in Toronto Ontario, Canada. He is the team lead for Message Set Development tools for WebSphere Business Integration Message Broker. You can reach Suman at kalia@ca.ibm.com.

Rate this content

Please take a moment to complete this form to help us better serve you. Did the information help you to achieve your goal? Yes No Don't know   Please provide us with comments to help improve this page:   How useful is the information? 1 2 3 4 5 Not useful Extremely useful

Back to top