Direct QUERY - Discovery

[#1]

Hi all,

Simple question, is it possible to have two Direct QUERY in one application ?

I have an error when I want to create a second one

DIRECT QUERY

dimension

key,

  itype

measure

  customerID

FROM xxx.xxxxx;

DIRECT QUERY

dimension

key,

  itype

measure

  orderID

FROM yyyy.yyyy;

[#2 · Accepted solution]

"This version of direct discovery only supports one direct discovery table per QlikView

application, the source of the direct discovery can be one database table or one view. It is also

possible to use a WHERE statement on the load script with the direct discovery table." cf Technical Doc

[#3]

Hi Adrien

I got another answer which is

the Direct Select takes as a reference the previous ODBC connexion string

So if you declare

ODBC connect...1

DIRECT SELECT ...

ODBC connect...2

DIRECT SELECT ...

it should connect to 2 different DB

I'm eager to get the Tech doc if you mean to post it

Thank you

Christian

[#4]

Thanks for your reply, I will try

Doc:

QlikView 11 2 SR5 Direct Discovery Technical Addendum.pdf

[#5]

Please let me know the result of your test with many ODBC

Thank you

Chris

[#6]

No it's not working, first statement is correctly executed, but at thse cond I've got this error :

Script line error:

DIRECT QUERY

MEASURE