Caching to a File Target
If a resource uses a data source that was originally added to TDV Server using the pass-through mode without saving the password, row-based security can affect cache refresh functionality. For details on save password and pass-through login, see
Adding a Data Source.
To enable caching to a file target
1. In Studio, open a view or procedure.
2. Select the Caching tab.
3. Click Create Cache.
4. Under Status, select the Enable check box. If you decide to leave it cleared, you can continue to define the cache, but it will not be active until you select the Enable check box.
When a cache is disabled, all existing cache settings are ignored. The view or procedure is used as if caching did not exist. Toggling between the enabled and disabled state does not cause refreshing of the data or resetting of the expiration date for the data.
5. Under Storage, specify Automatic to store the cached data in a system-created file accessible through Studio:
<HostName>/lib/sources/cacheDataSource
The physical files are stored by default in the TDV Server installation directory at: <TDV_install_dir>/tmp/cache
Each cached resource has a cache table in the cacheDataSource data source. The cache table’s name contains the resource type (view or procedure) and a system-generated ID.
6. Save the cache settings.