Table of Contents

Search

  1. Preface
  2. Web Services
  3. SOAP Web Services
  4. WSDL Data Object
  5. Schema Object
  6. How to Create a SOAP Web Service
  7. Operation Mappings
  8. Parsing Web Service SOAP Messages
  9. Generating Web Service SOAP Messages
  10. Web Service Consumer Transformation
  11. REST Web Services
  12. How to Create a REST Web Service
  13. REST Web Service Consumer Transformation
  14. REST and SOAP Web Service Administration
  15. Datatype Compatibility

Web Services Guide

Web Services Guide

Web Service Result Set Caching

Web Service Result Set Caching

Result set caching enables the Data Integration Service to use cached results for web service requests. Users that run identical queries in a short period of time may want to use result set caching to decrease the runtime of identical queries.
When you configure result set caching, the Data Integration Service caches the results of the DTM process associated with each web service request. The Data Integration Service caches the results for the expiration period that you configure. When an external client makes the same query or request before the cache expires, the Data Integration Service returns the cached results. If a cache does not exist or has expired, the Data Integration Service starts a DTM instance to process the request.
When the amount of data in the cache exceeds the maximum cache size memory, the Data Integration Service stores the result set in an encrypted cache file at
<Informatica_install_dir>/tomcat/bin/disTemp/<Service_Name>/<Node_Name>/
.
The Data Integration Service stores the result set cache for web services by user when the web service uses WS-Security. The Data Integration Service stores the cache by the user name that is provided in the username token of the web service request. When the Data Integration Service caches the results by user, the Data Integration Service only returns cached results to the user that sent the web service request.
Use the following steps to configure result set caching in the Administrator tool:
  1. Configure the result set cache properties in the Data Integration Service Process properties.
    The following table describes the result set cache properties:
    Property
    Description
    Maximum Total Disk Size
    Maximum number of bytes allowed for the total result set cache storage. Default is zero.
    Maximum Per Cache Memory Size
    Maximum number of bytes to allocate for a single result set cache instance in memory. Default is zero.
    Maximum Total Memory Size
    Maximum number of bytes allocated for the total result set cache storage in memory. Default is zero.
    Maximum Number of Caches
    Maximum number of result set cache instances allowed for the Data Integration Service. Default is zero.
  2. Configure the cache expiration period in the SOAP web service operation properties or the REST web service resource properties.
    The result set cache expiration period if the number of milliseconds that the result set is available to use. If set to -1, the cache never expires. If set to zero, result set caching is disabled. Changes to the expiration period do not apply to existing caches. To set all caches to use the same expiration period, purge the result set cache after you change the expiration period. Default is zero.
  3. To enable the Data Integration Service to cache the results by user, enable WS-Security in the web service properties.
To disable result set caching for a web service request when the web service operation is configured to cache the result set, include the following syntax in the HTTP header of the SOAP request:
WebServiceOptions.disableResultSetCache=true