Before you begin
- Create an event table (a database table that serves as a transient
store for event data).
- Create a trigger on the application data table. The trigger inserts
a row into the event store whenever the application data is changed.
- Configure the IBM® Integration Bus runtime
component to connect to the database; see Enabling ODBC connections to the databases.
If you use DB2® on
z/OS®, your user ID (or your
user group) requires permission to perform a SELECT on SYSIBM.SYSJAROBJECTS.
You
do not need experience of ESQL to complete this task.
About this task
Scenario: A retail company uses a relational database
to manage its stock inventory. Since a recent acquisition, a new set
of applications based on XML and
WebSphere® MQ are
added to the environment. The applications notify interested parties
of any changes to the stock levels. The applications have a predefined
XSD schema model that describes the input message.
IBM Integration Bus is used to respond to database
updates, and to notify the
WebSphere MQ application
of these changes.
- A DatabaseInput node
retrieves the data.
- A transformation node, such as a Compute node or a Mapping node, transforms the
data to the target format.
- An output or request node, such as an MQOutput node, sends the transformed
message to the target system.