Creating and Configuring Subscription Service

When running as a subscriber, the adapter listens on a subject, receives messages, and updates the relevant tables in its associated database. The data is then available to other applications that have access to the database.

For details, see the following configurations:
  1. Creating Subscription Service
  2. Fetching a Table After Creating Subscription Service
  3. Specifying an Exceptions Table
  4. Using an Exceptions Table as a Source Table
  5. Specifying an Opaque Exceptions Table
  6. Specifying a Precommit Stored Procedure Call
  7. Configuring a Subscriber Reply Sender
  • Creating Subscription Service
    Before you configure Subscription Service, you have to create a service of Subscription Service.
  • Fetching a Table for Subscription Service
    To use the adapter to interact with source and target applications, you must fetch tables for Subscription Service.
  • Specifying an Exceptions Table
    After fetching a table in Subscription Service, you can specify an exceptions table for Subscription Service. If an error occurs when the subscriber endpoint inserts, updates, or deletes data in the destination table, the subscriber endpoint writes the data to the exceptions table to record the error.
  • Configuring an Exceptions Table as a Source Table
    If you want to publish data from an exceptions table and also want to use this exceptions table as the source table, you cannot use the ADB_ERROR_TEXT or ADB_OPCODE columns.
  • Specifying an Opaque Exceptions Table
    You can specify an Opaque Exceptions table for Subscription Service. If a subscriber endpoint fails to generate records in the destination table or fails to insert a message into an exceptions table, the subscriber endpoint logs the error into the opaque exceptions table.
  • Specifying a Precommit Stored Procedure Call
    You can configure Subscription Service to call a stored procedure after a database inserts, updates, or deletes data and before committing the data. You can use this stored procedure as a hook to accomplish further processing inside the database and have results returned to the adapter.
  • Configuring a Subscriber Reply Sender
    A subscriber endpoint can be configured to send the subscription status as a reply to the message sender if the message contains a reply subject. The ADB_SUBSCRIBER_STATUS AE schema is used for this reply message.