topic SAP HANA Prepared Statements in Connectivity & Data Prep

SAP HANA Prepared Statements

eha — Fri, 02 Apr 2021 08:43:49 GMT

Hi All,

Does anyone have any experience with sending Prepared Statements from QlikView to SAP HANA Views/Tables using

HANA ODBC driver?

The SAP Team requires the SQL scripts to be be routed to the appropriate HANA host, but unfortunately all queries run on the Master HANA node which is not workable for the HANA Team. I have tried with multiple driver versions but without any luck.

any thoughts are appreciated!

Re: SAP HANA Prepared Statements

meshri2002 — Sun, 17 May 2020 04:19:46 GMT

Hi Eha,

we have the same issue, all are routed to master HANA node. did you found any solution , please post.

Thank you

Mehar

Re: SAP HANA Prepared Statements

eha — Sun, 17 May 2020 04:33:17 GMT

Unfortunately, it’s not supported. I have submitted an enhancement to the Product, but no ETA at this point. I am guessing it could be incorporated in 2021, but not certain.
Thanks

eha

Re: SAP HANA Prepared Statements

meshri2002 — Sun, 17 May 2020 04:52:07 GMT

Thank you Eha for Prompt response .