Data Integrator provides a delta query feature where the adapter checks for new alarms without returning all alarms each time.
Select an element in the
pane.In the right pane, click the
icon to display the tab.Use the
and tabs to define the generated or custom query.For more information, see Section 6.0, Defining Queries and Properties.
Click the
tab.To create properties for procedure results columns:
check box.
Select
from the drop-down list.To check for any delta results, specify the name of the result column in the
field.Select an element in the
pane.In the right pane, click the
icon.Click the
tab.Include the Computed Property in the stored procedure invocation.
For example, if the property using the HighestCustomerID, then the execute statement might look like the following:
option is#if ( ${query.initial} ) Execute sp_mysp 0 GETDATE() #else Execute sp_mysp ${query.property.HighestCustomerID} GETDATE()#end
Click the
tab.Click the
radio button next to .All alarms not in the subsequent query remain in Operations Center.
If you click
, the alarms are removed and the adapter element shows only the delta alarms.