CaseTransform Filter
The CaseTransform filter can be used to force convert Schema, Table and Column names to either upper or lower case.
| Pre-configured filter name | casetransform |
| Classname | com.continuent.tungsten.replicator.filter.CaseMappingFilter |
| Property prefix | replicator.filter.casetransform |
| Stage compatibility | |
tpm Option compatibility | |
| Data compatibility | Any Event |
Parameter
| Parameter | Type | Default | Description |
|---|---|---|---|
to_upper_case | boolean | true | If true, converts object names to upper case; if false converts them to lower case |
This filter can be useful when replicating between environments that have different case sensitivity settings in place.
Usage ExampleTo force Upper Case on extractor:
svc-extractor-filters=casetransform
property=replicator.filter.casetransform.to_upper_case=true
To force Lower Case on applier:
svc-applier-filters=casetransform
property=replicator.filter.casetransform.to_upper_case=false