Use Direct Discovery with the ODBC Connectors

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.

Example:  

LIB CONNECT TO 'Oracle1'; SELECT "DEPARTMENT_ID", "DEPARTMENT_NAME", "MANAGER_ID", "LOCATION_ID" FROM "HR"."DEPARTMENTS"; DIRECT QUERY DIMENSION FIRST_NAME MEASURE SALARY DETAIL EMPLOYEE_ID FROM "HR"."EMPLOYEES";

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.

Did this information help you?

Thanks for letting us know. Is there anything you'd like to tell us about this topic?

Can you tell us why it did not help you and how we can improve it?