Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Connecting to IDAA with Qlikview

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? 

2 Replies
Not applicable
Author

I guess you can try Qlik custom ODBC connector.

Or contact Qlik support team

Not applicable
Author

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'

;