The Qlik ODBC Connectors supports Direct Discovery. The SELECT statement can be edited in the Data load editor in Qlik Sense, and in the Edit script dialog in QlikView, to create a DIRECT QUERY statement.
Do the following:
After the script has been inserted in the script editor, you change a SELECT statement to a DIRECT QUERY statement.
LIB CONNECT TO 'Oracle1';
The Qlik ODBC Connectors support the use of separate SELECT and DIRECT QUERY statements in the same script.
Note: The DIRECT QUERY statement does not support use of DISTINCT or GROUP BY clauses.