6.6 Setting up a Delta Query

Data Integrator provides a delta query feature where the adapter checks for new alarms without returning all alarms each time.

6.6.1 Defining a Delta Query

  1. Select an element in the Definition Navigator pane.

  2. In the right pane, click the Query icon to display the Editor tab.

  3. Use the Editor and Source tabs to define the generated or custom query.

    For more information, see Section 6.0, Defining Queries and Properties.

  4. Click the Property Details tab.

  5. To create properties for procedure results columns:

    1. Select the Computed Property check box.

    2. Select Highest from the drop-down list.

    3. To check for any delta results, specify the name of the result column in the Column Name field.

6.6.2 Defining a Custom Query

  1. Select an element in the Definition Navigator pane.

  2. In the right pane, click the Query icon.

  3. Click the Source tab.

  4. Include the Computed Property in the stored procedure invocation.

    For example, if the property using the Computed Property option is HighestCustomerID, then the execute statement might look like the following:

    #if ( ${query.initial} )
      Execute sp_mysp 0 GETDATE()
    #else
      Execute sp_mysp ${query.property.HighestCustomerID} GETDATE()#end
    
  5. Click the Editor tab.

  6. Click the No radio button next to Remove Alarms Not in Query.

    All alarms not in the subsequent query remain in Operations Center.

    If you click Yes, the alarms are removed and the adapter element shows only the delta alarms.