Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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

Re: Connecting to IDAA with Qlikview

I guess you can try Qlik custom ODBC connector.

Or contact Qlik support team

Not applicable

Re: Connecting to IDAA with Qlikview

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'

;

Community Browser