Non-transactional events

This integration ensures that IBM® Sterling™ Intelligent Promising has updated configuration information for accurate promising and inventory visibility.

Configuration data sync

The Data Publish agent publishes the Configuration and Master data to SIP through Kafka. Currently, this agent publishes the following sets of data in IBM CloudEvents 1.0 specification.
  • Enterprise
    enterpriseSync
  • Ship node
    shipNodeSync
  • Distribution rules
    distributionGroupSync
  • Item/product
    productSync
The data sets contain related data for a particular entity. For example, the Item data set consists of items and related data like item details, item inventory attributes, and so on.
This agent works in two modes: FULL and DELTA. All the required configuration data and master data are published as part of initial setup. However when the applications are out of sync or require a data refresh, the agent can be run in the FULL mode, which publishes the complete data sets again. In DELTA mode, only the changed data sets are published.
Note: Currently, delta mode is supported only for the item data.
Table 1. Data publish agent criteria
Parameter Description Value
Action If left blank, it defaults to GET, the only valid value. GET
NumRecordsToBuffer This indicates number of messages that getJobs can push in a single run. 5000
MaxRecordsToQuery This indicates the maximum number of records that can be fetched in a single query by getJobs. 5000
ConfigurationType Indicates the type of data set CONFIG or MASTER
  • Enterprise Data and Node Data belong to CONFIG Configuration Type.
  • Item Data belongs to MASTER Configuration Type.
WaitTimeForWIPRecords Indicates the wait time period before stuck jobs are re processed and published. 1800
RetryCount Maximum number of retries for failed or stuck jobs. 0
Mode If the Mode is set to DELTA, the agent looks into the YFS_MIGRATION_PROCESS table for any available information. The agent queries the table to figure out if any previous run happened for the Master data. DELTA or FULL
IncludeTablesForPublish A comma separated list of config tables to be published so use this for selective table publish. Default value: Blank include all
Valid values: Comma separated list of following table names as example:
  • YFS_ORGANIZATION
  • YFS_SHIP_NODE
  • YFS_DISTRIBUTION_RULE
  • YFS_SCAC
  • YFS_NODE_TRANSFER_SCHEDULE
ExcludeTablesFromPublish A comma separated list of config tables to be excluded from publishing so use this for selective table publish.

Default value: Blank excluding none

Valid values: Comma separated list of following table names as example:
  • YFS_ORGANIZATION
  • YFS_SHIP_NODE
  • YFS_DISTRIBUTION_RULE
  • YFS_SCAC
  • YFS_NODE_TRANSFER_SCHEDULE
There are three agent criteria definitions provided out-of-the-box and are as follows:
  • DATA_PUBLISH_CONFIG_FULL_SYNC
    It triggers the agent as per the scheduled interval for CONFIG data in FULL mode.
  • DATA_PUBLISH_MASTER_FULL_SYNC
    It triggers the agent as per the scheduled interval for MASTER data in FULL mode.
  • DATA_PUBLISH_MASTER_DELTA
    It triggers the agent as per the scheduled interval for MASTER data in DELTA mode.

The parameters for these agent criteria definitions are described in Table 1.