Activating IWD Aggregate Plugins

From release 9.0.014

From release 9.0.014 onwards, the I_TASK_FACT_<SUBJ>_15MIN aggregation tables (for standard aggregation plugins: agent, capture, classification, queue, age) are removed from the iWD Data Mart schema. The H_TASK_FACT_<SUBJ>_15MIN tables contain a full set of intervals. Check whether your custom plugins use H_TASK_[Subj]_FACT_15MIN or I_TASK_[Subj]_FACT_15MIN tables: if so you might need to adjust them. See the Migration page in the iWD Deployment Guide.

Similarly to activating statistics (see Composition of IWD Statistics and Aggregates), you activate a plug-in by appending it to the plugins.properties file, which is located in the etl\plugins subfolder.

Up to release 9.0.013

The iWD Data Mart has five embedded aggregation plug-ins:

• AGE
• AGENT
• CLASSIFICATION
• CAPTURE
• QUEUE

By default, only the task classification aggregate is enabled in this file to minimize ETL processing time and Data Mart size; this plug-in’s content consists of the following single line:

${KETTLE_REPOS_DIR}\plugins\classif,task_classif_fact,native

To enable additional plugins, perform the following steps:

1. Stop iWD Data Mart runtime node.

2. Using an ASCII editor, open plugins.properties, add a row for each plug-in that you want to enable, and save.

Important
This file should not contain any extraneous lines.

For example, to add all the aggregate plug-ins, add these lines to the file as shown below:

${KETTLE_REPOS_DIR}\plugins\classif,task_classif_fact,native
${KETTLE_REPOS_DIR}\plugins\age,task_age_fact,native
${KETTLE_REPOS_DIR}\plugins\agent,task_agent_fact,native
${KETTLE_REPOS_DIR}\plugins\capt,task_capt_fact,native
${KETTLE_REPOS_DIR}\plugins\queue,task_queue_fact,native

Genesys also provides a sample file with all plugins enabled: etl\plugins\all_plugins_example.properties.

Important

Due to better performance results, iWD Data Mart uses the Groovy versions of the aggregation plugins instead of Kettle since release 9.0.009.xx.

But only the Kettle implementation of the aggregations plug-ins supports customization, so you can switch back to the Kettle version if needed:

${KETTLE_REPOS_DIR}\plugins\classif,task_classif_fact
${KETTLE_REPOS_DIR}\plugins\age,task_age_fact
${KETTLE_REPOS_DIR}\plugins\agent,task_agent_fact
${KETTLE_REPOS_DIR}\plugins\capt,task_capt_fact
${KETTLE_REPOS_DIR}\plugins\queue,task_queue_fact