Prerequisites: Driver installation & configuration
If you connect through ODBC, a DSN must be created prior to the connection. More details: Go to ODBC-Create a DSN linked to Indexima Engine.
Depending on the location of the ODBC repository, you may need extra rights to perform the DSN creation.
Install the jar files
Setup a DIRECT Query Connection
Create DIRECT Query Connection
The SQL-like statement that gets the data must start with DIRECT QUERY.
More details: Go to https://help.qlik.com/en-US/sense/February2022/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptRegularStatements/direct-query.htm