Not possible to run Direct Query with SAP HANA: No Direct Statement Script Error
Article Number: 000041433 | Last Modified: 2018/11/21
Direct Query through ODBC Connection on SAP HANA does not work.
This is working as designed. If using Direct Query the SAP HANA Database should be queried through the Qlik SAP Connector. SAP HANA Database can be queried using normal ODBC Query but for Direct Query Qlik SAP Connector must be used. Please see below for further reference:
For SAP, Direct Discovery can be used only with the Qlik SAP SQL Connector, and it requires the following parameters in SETvariables:
SET DirectFieldColumnDelimiter=' ';
SET DirectIdentifierQuoteChar=' ';
In addition if the table name has backslashes like /BIC/MZGENDER, it needs to be enclosed in square brackets like [/BIC/MZGENDER].