You can use Adaptive Server Enterprise to:
Publish any user-defined messages to the TIBCO EMS or MQ messaging system
Subscribe to (consume) events from the TIBCO EMS or MQ messaging system
Using RTDS, applications can use Adaptive Server Enterprise directly, taking advantage of Transact-SQL® functions to publish and subscribe messages.
You can use RTDS with Adaptive Server Enterprise for:
New applications written on either Adaptive Server versions 12.5.4 or 15.0 ESD #2 – allows messaging services to be build into the application within transactions.
Legacy applications, with Adaptive Server upgraded to either versions 12.5.4 or 15.0 ESD #2
To do so, install Adaptive Server Enterprise version 12.5.4 or 15.0 ESD #2 with messaging services functionality and either of the following software components:
TIBCO EMS Message Bus system version 4.2 – Adaptive Server does not include TIBCO EMS Message Bus system; obtain the software separately and obtain the license from TIBCO. For more information, and to obtain TIBCO software, see the TIBCO Web site.
MQ messaging system version 5.3 – Adaptive Server does not include IBM WebSphere MQ; obtain the software separately and obtain the license from IBM. For more information, and to obtain MQ dynamic load libraries, see the IBM WebSphere MQ Web site.
You can publish database events from Adaptive Servers earlier than versions 12.5.4 and 15.0 ESD #2 to the TIBCO EMS or MQ messages by using Replication Server.
Figure 1 shows this setup, where Adaptive Server acts as an event hub for heterogeneous applications, with Replication Server delivering events through Adaptive Server.
Figure 1: Using Adaptive Server as an event hub
Use this setup to install Replication Server, which is provided in the RTDS product bundle. In this setup:
Replication Agents for different RDBMs publish data changes to Replication Server.
Replication Server, through the use of replication function strings, can transform, then call the appropriate Adaptive Server messaging function for Adaptive Server to publish the message to the message bus.