Problem Summary: How to setup a channel to filter data from HANA source.
Description:
The fix for HVR-7315 removed the ability to define Restrict/CaptureCondition and Restrict/IntegrateCondition for HANA as a source. This article describes the workaround to filter data from HANA source. HANA like other databases does not have concept of supplemental logging, so for anything other than an insert, any unchanged column has no value. We then can’t execute an expression, since we have no value. This article assumes the target to be Snowflake.
Workaround:
This can be achieved by using an intermediate database. For eg. SQL Server or PostgresSQL or something that supports supplemental logging. There will be one channel which will replicate all the data from HANA to intermediate database. We then can have a 2nd channel from intermediate database to Snowflake. This channel will have Restrict /IntegrateCondition and Restrict /CaptureCondition