Pushing filter to SQL Server database engine from FlowGraph

[Former Member]

Hi experts!

I'm trying to load on premise SQL Server data to SAP Hana database on cloud, through a remote source using MssqlLogReaderAdapter adapter, some virtual tables and a flow graph task.

However, I would like to upload data changed from a reference date, using a filter like:

"Filter1_Input"."LASTCHANGE" > ADD_DAYS (CURRENT_DATE, -5)

I see the the adapter does not push the query where condition to the on premise database engine, generating performance issues.

If I put a static value it works, for example:

"Filter1_Input"."LASTCHANGE" > '2018-05-25'

I tried also to set a flow graph task parameter, without success.

How can I solve my problem?

Thank you for your answers,

Carlo

[former_member225192]

hi Brunengo,

did you find a solution? I am finding that even a static filter in the flowgraph is not pushed to SQL. when I look in SYS.REMOTE_STATEMENTS during the load I can see the sql statement in field REMOTE_STATEMENT_STRING and it does not contain my static filter from the filter node that directly proceeds my virtual table datasource in the flowgraph.

any ideas how to get the static filter pushed to SQL?

[Former Member]

Hi, there are no solutions. For my issues, I created some SQL Server views to filter data based on last changed date.

Regards, Carlo