Database sender

The properties of the links connecting this node are described.

Configuration properties

Table 1. Database sender configuration properties
Property Description
Runtime Tab
Table Name Select the table you want the message to be written to. Valid values are YFS_IMPORT and YFS_EXPORT.
Rollback on Exception Select this check box if you want the message to be committed to the database only after the service is completed.

Uncheck this check box if you want the message to be committed to the database immediately.

For example, if the ON_SUCCESS event of any standard Sterling Selling and Fulfillment Foundation API is attached to a service, in which the message is transactionally written to the database, the message is committed to the database only upon successful completion of the ON_SUCCESS event. The message is then rolled back from the queue if there is any error in the ON_SUCCESS event after the message is staged. However, in non-transactional mode, the message remains in the database, once it is staged and is not rolled back.

Header Tab
  The Header Name and Header Value allow the sender to differentiate between messages in the table. See the Selector field in the "Database Receiver Configuration Properties" table.

In addition to the Header Name/Value, EOF messages get appended with MessageType=EOF in the USER_REFERENCE column. If you are using USER_REFERENCE as the selector, you need to modify the Selector criteria to include MessageType=EOF as well.

Note: The header name must be unique. Two headers cannot have the same header name.

Choose the Create New icon to add a new header name and value.

Choose the Details icon to modify an existing header name and value.

Choose the Delete icon to delete an existing header name and value.

Important: Do not enter any spaces in the Header Name.

Header Value Saved in the USER_REFERENCE column of the YFS_EXPORT and YFS_IMPORT tables as a name value pair. A maximum limit of these name/value pairs stored is 2048 bytes, beyond which the references are truncated.

Each Header Name/Value pair specified is appended in the USER_REFERENCE column of the YFS_IMPORT/YFS_EXPORT table as Name1=Value1 Name2=Value2

These references can be used to identify the key data stored in the MESSAGE field of the YFS_IMPORT/YFS_EXPORT table when querying.

This can be set to dynamically extract from the message using the following syntax xml://<full path of the element from root node>/@<attribute name>.

For example, to get the sales order number from the publish ship advice output XML: set the value as xml://ShipmentAdvices/ShipmentAdvice/@SalesOrderNo results in the USER_REFERENCE field to be populated with NAME1=<value of attribute SalesOrderNo in the XML>

Important: Do not enter any spaces in the Header Value.