CDC Guide for Linux, UNIX, and Windows

10.5
- 10.5.6
- 10.5.5
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Example Group Definition File

PowerExchange provides an example group definition file, pwxcclgrp.cfg, in the PowerExchange installation directory. Use this example as a starting point when creating your group definition file.

The example file contains the following statements:

GROUP=(Company1People,"/user/logger_files/people/company1/condense") 
REG=Emp* 
REG=Manager 
GROUP=(UK_People,"/user/logger_files/people/UK/condense") 
SCHEMA=Company2 
REG=Manager 
REG=Emp* 
REG=Em* 
SCHEMA=Company3 
REG=Manager 
REG=Emp* 
GROUP=(All_Managers,"/user/logger_files/people/managers/condense") 
SCHEMA=Company1 
REG=Manager 
SCHEMA=Company2 
REG=Manager 
SCHEMA=Company3 
REG=Manager 
GROUP=(AllCompany3_Locations,"/user/logger_files/locations/company3/condense")
REG=loc* 
GROUP=(Company2Jobs,"/user/logger_files/jobs/company2/condense") 
REG=Job*

Because this example is for a group definition file on a Linux or UNIX system, the paths include forward slashes. A group definition file on Windows system would be similar but have back slashes.

This example file defines the following groups:

Company1People group
. Groups all tables associated with capture registrations that have names beginning with “Emp” or the name “Manager.” Changes for these tables are logged to log files that have file names beginning with “condense” and that are located at “/user/logger_files/people/company1/.”

UK_People group
. Groups tables that have the schema Company2 and that are associated with capture registrations that have names beginning with “Emp” or “Em” or the name “Manager.” Changes for these tables are logged to log files that have names beginning with “condense” and that are located at “/user/logger_files/people/UK/.”

All_Managers group
. Groups tables that have the schema Company1, Company2, or Company3 and that are associated with the capture registration with the name “Manager.” Changes for these tables are logged to log files that have names beginning with “condense” and that are located at “/user/logger_files/people/managers/.”

AllCompany3_Locations group
. Groups all tables that are associated with capture registrations that have names beginning with “loc.” Changes for these tables are logged to log files that have names beginning with “condense” and that are located at “/user/logger_files/locations/company3/.”

Company2Jobs group
. Groups all tables that are associated with capture registrations that have names beginning with “Job.” Changes for these tables are logged to log files that have names beginning with “condense” and that are located at “/user/logger_files/jobs/company2/.”

Some tables might be included in more than one group. For example, the table COMPANY2.MANAGERS is in the Company1People, UK_People, and All_Managers groups. However, changes for this table are logged only under the Company1People group because it is the first group in the file that includes this table.

Using PowerExchange Logger Group Definitions

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal