PowerExchange Express CDC for Oracle now supports Oracle column-level encryption. When enabled, PowerExchange can decrypt data in encrypted Oracle source table columns that are selected for capture processing. To enable support of column-level encryption, use the in the SUPPORT_COL_ENCRYPTION parameter in the OPTIONS statement.
You must have the following Oracle privilege to use this feature:
GRANT SELECT ON "SYS"."ENC$" TO
capture_user
For more information, see the "Express CDC for Oracle" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows