Configuring a Data Source Refresh

To avoid querying the database each time data is requested by a client, the ICONICS Databases Point Manager temporarily caches a Data Source's query results in memory.

The use of the cache improves the performance of the application and reduces the load on the database. However, if the database contains new data, it might be desirable to discard the cached data, and execute the query again to retrieve the latest from the database.

You can configure the ICONICS Databases Point Manager to clear all cached data for a Data Source on certain conditions. When a cache clear occurs, the server will also re-execute the Data Source's database query and update any connected clients with the new data automatically.

NOTE: For more information about caching, refer to Cached Data Considerations.

To configure a Data Source Refresh:

  1. Open Workbench. Expand Data Connectivity > Databases and expand the Connection that contains your Data Source. Double-click the Data Source to edit it.

  2. Select the Data Refresh tab. You can configure the Data Source refresh policy by selecting an option from the Refresh Type drop-down. The possible options are:

    Refresh Type option Description
    No Refresh The Data Source's cache will not be cleared. Cached data will persist until evicted from the cache manually, because of inactivity, or low usage. For more information about eviction of items from the cache, refer to Cached Data Considerations.
    Periodic The Data Source's cache will be cleared at specified intervals. Selecting this option enables the Refresh Period box, which determines the interval at which the cached data is cleared.
    By Triggers The Data Source's cache will be cleared when an event from a Trigger is received. Selecting this option enables the Refresh Triggers list. One or more Triggers can be added to the list: the Data Source's cache will be cleared when an event is received from any of the selected Triggers. For more information about Triggers, refer to Triggers Overview.

    NOTE: The default setting for a Data Source is periodic refresh at a 60 seconds interval. You may want to adjust or modify this based on your application's requirements.

  3. Configure the desired options and click Apply. The Data Source will now refresh as configured.