000034404 - Alternate Method for Reoccuring Data Feeds in RSA Archer

Document created by RSA Customer Support Employee on Dec 9, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000034404
Applies ToRSA Product Set: Archer
RSA Version/Condition: 5.x and may work on versions of 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.
Tasks

The provided script takes three values


  • selectValueID - Value that means record needs to be processed by datafeed
  • fieldID - Field that value occurs in
  • datafeedID - ID of data feed to run
Update the attached script with values for your particular environment.
Schedule the Data Feed that you want the script to kick off for a starting date in the distant future (year 2100).
Run the provided script through a scheduler of your choice (SQL Agent , Transport Only Data Feed etc..).
This script can be reused for as many re-occurring data driven Data Feeds as you needs require.
NotesThese 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.
 

Outcomes