Using RTDS with Adaptive Server Enterprise

You can use Adaptive Server Enterprise to:

Publish any user-defined messages to the TIBCO EMS, EAServer JMS, or MQ messaging system

Subscribe to (consume) events from the TIBCO EMS, EAServer JMS, 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 ESD #3 or 15.0.1 ESD #1 – allows messaging services to be build into the application within transactions

Legacy applications, with Adaptive Server upgraded to either versions 12.5.4 ESD #3 or 15.0.1 ESD #1

To do so, install Adaptive Server Enterprise version 12.5.4 ESD #3 or 15.0.1 ESD #1 with messaging services functionality and one of the following software components:

EAServer JMS version 5.2 – included with RepConnector 15.0.

Real-Time Data Services version 4.0 on Adaptive Server Enterprise version 12.5.4 ESD #3 does not support EAServer JMS.

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.

WARNING! Real-Time Data Service version 4.0 is not certified on Adaptive Server version 15.0.2 or later. If you have RTDS 4.0 and you upgrade Adaptive Server to version 15.0.2, 15.0.2 ESD#1, or 15.0.2 ESD#2, RTDS messaging stops. To use the RTDS feature, upgrade to RTDS 4.5.

Using Replication Server

You can publish database events from Adaptive Servers earlier than versions 12.5.4 ESD #3 and 15.0.1 ESD #1 to the JMS 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.