000034404 - Alternate Method for Reoccuring Data Feeds in RSA Archer

Document created by RSA Customer Support Employee on Nov 14, 2019
Version 1Show Document
  • View in full screen mode

Article Content

Article Number000034404
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x and 6.x

IssueFor frequent reoccurring Data Feeds that only process data flagged for processing, you can schedule the Data Feed for the far off future and let the attached SQL script queue the Data Feed only when necessary. This relieves processing for the web api to peek into Archer and the overall number of jobs processed in the Job Engine.

The provided script takes three values:

  • selectValueID - Value that means record needs to be processed by datafeed
  • fieldID - Field in which that value occurs
  • datafeedID - ID of data feed to run
You will need to:

  1. Update the attached script with values for your particular environment.
  2. Schedule the Data Feed that you want the script to kick off for a starting date in the distant future (year 2100).
  3. Run the provided script through a scheduler of your choice (SQL Agent, Transport Only Data Feed, etc.).
  4. This script can be reused for as many re-occurring data-driven Data Feeds as required.

These methods/scripts are provided as is and we assume no responsibility for their content or operation in any particular environment. Further, we assume no liability for potential harm or damage, software or hardware, that may result from their use. The scripts are provided as examples only and may need to be modified for your use. VERIFY THE USEFULNESS of the script before you use it.