Connector for HCL Commerce Manual / Version 2107
Table Of Contents
Note
Event-based Commerce Cache Invalidation is only available if the HCL Commerce Extension is used
Content Cloud integrates with HCL Commerce without importing catalog data into the CMS. Since all catalog data is requested dynamically from the HCL Commerce system, Content Cloud comes with its own caching layer to provide fast access to HCL Commerce data. In order to promptly reflect any changes of HCL Commerce data, Content Cloud supports event based cache invalidation. Apply the following changes to enable event based cache invalidation:
Add the
CacheInvalidationHandleras described in Section 3.7, “Configuring REST Handlers”Add database triggers for cache invalidation of segments and marketing spots. In order to create corresponding entries in HCL Commerce CACHEIVL table (where Dynacache Invalidation events are stored), several database triggers are needed. These are database specific but HCL Commerce already provides correct working examples in the HCL Commerce workspace. You do not need all the sample triggers but only those for Segments and Marketing Spots.
Copy the triggers for the INSERT, UPDATE and DELETE cases for the following tables:
EMSPOT
MBRGRP
and add them to your database (for example, by using
http://HOST/webapp/wcs/admin/servlet/db.jsp)The sample files are located in the following directories:
- Oracle:
WCDE-ZIP\schema\oracle\cm.wcs.cacheivl.trigger.sql - IBM DB2:
WCDE-ZIP\schema\db2\cm.wcs.cacheivl.trigger.sql - Cloudscape/Derby:
WCDE-ZIP\schema\clouscape\cm.wcs.cacheivl.trigger.sql
Note
If enabled HCL workspaces in your environment setup, you need to create these triggers for each workspace. If you enabled 5 workspaces for example, you need to create these triggers 5 times. Examples are given in the mentioned example files.
