Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Has anyone connected to IDAA as a source for a QlikView datasource? How have you set the special registry to verify you are hitting the IDAA and not the underlying DB2 table?
I guess you can try Qlik custom ODBC connector.
Or contact Qlik support team
You just need to include a separate line which I believe modifies the special register:
SQL SET CURRENT QUERY ACCELERATION ALL;
For example:
ODBC CONNECT TO DBNAME(XUserId is UserId, XPassword is XPassword);
test:
SQL
SET CURRENT QUERY ACCELERATION ALL;
SQL Select *
from SCHEMA.TABLE
WHERE FIELD= 'VALUE'
;