9.13.2 Database Forwarding Agent

The Database forwarding agent inserts UDR data into a database table, based on user defined mappings between UDR fields and database table columns. Also, the agent offers the possibility of populating columns with other types of data. The data is inserted either using a plain SQL statement, or through a call to a stored procedure that will be responsible of inserting the data.

The agent does not only map and forward the data. A special column in the target table is also assigned a unique Transaction ID, generated for each batch. In relation to this, a pending transaction table is utilized to indicate that a batch is open. The Database collection agent also utilizes this table to prevent problems if collecting data from the target table.