Creating and Configuring Publication Service

When running as a publisher, the adapter extracts data in the changed rows from database tables and publishes them on appropriate subject names. You can create Publication Service and then configure the service by using the adapter service tabs.

For details, see the following configurations:
  1. Creating Publication Service
  2. Fetching a Table After Creating Publication Service
  3. Specifying a Publishing Table
  4. Specifying a Polling Method
  5. Selecting a Storage Mode
  6. Enabling Loop Detection
  • Creating Publication Service
    Before you configure Publication Service, you have to create a service of Publication Service.
  • Fetching a Table for Publication Service
    To use the adapter to interact with source and target applications, you must fetch tables for Publication Service.
  • Specifying a Publishing Table
    After you create Publication Service and select a table for the service, when you save the adapter service configuration, the Publishing Table field in the Publication Options tab is automatically filled with the name of the selected table, with the prefix "P_".
  • Specifying a Polling Method
    Publication Service uses periodic polling or an alerter to monitor changes to a database table. You can select a polling method from the Polling Method list in the Publication Options tab.
  • Selecting a Storage Mode
    To copy columns from a source table to a publishing table, you can use the Storage Mode field in the Publication Options tab to select a storage mode. Publication Service provides two storage modes, Publish by Value and Publish by Reference. The selection depends on your specific requirements.
  • Enabling Loop Detection
    If a table is used as both a source table and a destination table for the same subject, a loop occurs and the same changes are published repeatedly. To prevent this issue, you can enable the loop detection feature by selecting the Enable Loop Detection check box in the Publication Options tab.