Scenario: Publishing from a database to a message bus

This scenario shows how you can use RSME to capture events from various databases and publish the events in real time over a message bus. In Figure 3, events are published from different database systems to a number of applications. Inventory management is running on ASE. A customer relationship management (CRM) application is running on an Oracle database, and a manufacturing quality control system is running on IBM DB2.

In this configuration, a Sybase certified message bus can be used. A business activity monitoring application requires real-time notification of critical events from all three of the source databases. The customer event management application enables the organization to notify customers proactively based on critical events. The organization may also want to, for example notify customers if they have been sent defective items as identified by the quality control system. An operational data store is updated in real-time from all three of the source systems.

Figure 3: Publishing from any database to any message bus

This is a RSME data flow diagram. It illustrates capture of data events in heterogeneous databases and propagation of these events to client application either directly or using any standard messaging systems. It illustrates how RSME components are deployed and how they interact with each other.