What You Can Do

#### Search Results

Search

# What You Can Do

The Event Replicator Target Adapter can be used to transform and apply replicated data from your Adabas mainframe database to a relational database, such as DB2, Microsoft SQL Server, MySQL, Oracle, PostgreSQL, Teradata; a JMS queue, or a Software AG Terracotta cache. For more details on Software AG’s Terracotta product, please refer to the "IBO and Big Data" documentation on Software GmbH's Empower web site.

Once appropriate Event Replicator subscription and destination definitions are activated and the Event Replicator Target Adapter is started, normal processing for the Event Replicator Target Adapter will transform and apply replicated Adabas data to a relational database or Terracotta cache as the data is processed by the subscription. In addition, using the Adabas Event Replicator Subsystem, you can manually submit requests to the Event Replicator Target Adapter that:

- initiate an initial-state request to populate the target tables or cache.

- clear (refresh) data in the target tables or cache.

- delete (drop) relational tables.

For information on using the Adabas Event Replicator Subsystem to do this, read Submitting Event Replicator Target Adapter Requests in Adabas Event Replicator Subsystem User Guide.

In addition, you can set up the ADALOD utility so that data loaded or updated by the utility is also replicated to the relational database tables. However, read Replicating ADALOD Data to the RDBMS Tables for important information on problems that might arise when you do this.

Finally, you can use the Event Replicator Target Adapter to replicate data to JMS queues and topics that are managed by webMethods Broker JNDI providers. The data in these JMS queues and topics can then be made available to webMethods Broker message consumers (such as webMethods Integration Server). For more information on setting up JMS support in the Event Replicator Target Adapter, read Replicating Data to JMS Queues or Topics. For complete information about JMS support in webMethods Broker, read the EntireX Message Service Provider (MSP), available in the IBM EntireX documentation on Software GmbH's Empower web site.

Notes:

1. User authorization to maintain any new RDBMS tables via Event Replicator Target Adapter is inherited from the site's privilege settings for the database. Authorization is managed by the user's RDBMS privileges and not by Event Replicator Target Adapter. Event Replicator Target Adapter will no longer grant RDBMS privileges to the user. Therefore, if you want to use Event Replicator Target Adapter to maintain tables in an RDBMS, verify that your RDBMS authorization privileges are correct for the maintenance you want to perform.
2. The Event Replicator Target Adapter will not process updates for a field that is the primary key for an RDBMS table or for any fields that comprise a composite key for the table.