DatabaseTransform (dbtransform) Filter
This filter can be used to rename databases (schemas) and/or tables between sources and targets
| Pre-configured filter name | dbtransform |
| Classname | com.continuent.tungsten.replicator.filter.DatabaseTransformFilter |
| Property prefix | replicator.filter.dbtransform |
| Stage compatibility | |
tpm Option compatibility | |
| Data compatibility | ROW Events only |
Parameters
| Parameter | Type | Default | Description |
|---|---|---|---|
transformTables | boolean | false | If set to true, forces the rename transformations to operate on tables, not databases |
from_regex1 | string | foo | The search regular expression to use when renaming databases or tables (group 1); corresponds to |
to_regex1 | string | bar | The replace regular expression to use when renaming databases or tables (group 1); corresponds to from_regex1 |
from_regex2 | string | The search regular expression to use when renaming databases or tables (group 2); corresponds to to_regex2 | |
to_regex2 | string | The replace regular expression to use when renaming databases or tables (group 2); corresponds to from_regex2 | |
from_regex3 | string | The search regular expression to use when renaming databases or tables (group 3); corresponds to to_regex3 | |
to_regex3 | string | The replace regular expression to use when renaming databases or tables (group 3); corresponds to from_regex3 | |
from_regex4 | string | The search regular expression to use when renaming databases or tables (group 4); corresponds to to_regex4 | |
to_regex4 | string | The replace regular expression to use when renaming databases or tables (group 4); corresponds to from_regex4 |
The dbtransform filter can be used to apply standard Java Regex expressions to rename databases and/or tables between source and target.
Up to 4 from/to regex patterns can be provided. By default the transformation will be applied to Database Schema names. To use the transform for
Table Names, specify the transformTables=true option.
The filter will only transform databases or tables, not a mix of the two. For more advanced transformation you may want to consider the rename filter instead
The filter only works with ROW events. Statement-based transformations are not supported with this filter.