How to use a trigger to refresh a Cache daily in TIBCO Data Virtualization?

How to use a trigger to refresh a Cache daily in TIBCO Data Virtualization?

book

Article ID: KB0071993

calendar_today

Updated On:

Products Versions
TIBCO Data Virtualization All Supported Versions

Description

This article provides the steps needed to use a trigger to refresh a cache daily in TIBCO Data Virtualization

Issue/Introduction

This article provides the steps needed to use a trigger to refresh a Cache on a daily basis in TIBCO Data Virtualization

Resolution

1. Create a trigger in TDV Studio.
2. Enable it by checking the box 'Enable Trigger'.
3. Set the condition type to Timer Event 
4. Select the Periodic option and Refresh every 1 day
5. Also, set the Start on date and time accordingly
6. Additionally, if the trigger needs to be restricted to work only on specific days then the Recurrence Restriction can be configured as well.
7. In the bottom window, change the Action Type to 'Execute Procedure'.
8. The Procedure Path needs to be set to the internal procedure '/lib/resource/RefreshResourceCache'
9. Now, RefreshResourceCache contains two parameters that need to be entered for a successful execution i.e. Path and type.

a) path: The path of the resource.
b) type: The type of the resource. Valid values: TABLE, PROCEDURE or POLICY

10. These two parameters need to be provided in the field Parameter Values
11. Once all the above information has been configured, the trigger can be saved.

Screenshot of the trigger:

User-added image