Introduction
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 a HANA source. HANA, like other databases, does not have a 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 that will replicate all the data from HANA to an intermediate database.
We then can have a 2nd channel from the intermediate database to Snowflake. This channel will have Restrict /IntegrateCondition and Restrict /CaptureCondition.