Condition for Static Filters for SAP HANA DataSources

If the data provisioning adapter makes this necessary, you can specify a static filter condition with SQL syntax for SAP HANA DataSources that support real-time replication. For most SAP HANA DataSources, you do not have to enter a static filter condition. This condition can no longer be changed once the initial data load to the generated target tables has been completed.

Only use this filter if the remote source makes this necessary, to specify a particular data set or restrict the data volume.

Example

If you create an SAP HANA DataSource to read Tweets using the Twitter adapter, you should enter a filter condition to specify a particular data set. If you do not enter a filter condition for the "Status" table, note that the Twitter adapter will read Tweets from your home timeline only.

To read all Tweets from the 'SAP' user's timeline, use the following filter condition: "ScreenName" = 'SAP'

To read all Tweets from the public timeline (search), use the following filter condition: "Tweet" like '%SAP%'