topic Re: Direct QUERY - Discovery in QlikView

Direct QUERY - Discovery

Thu, 16 Jan 2014 15:18:15 GMT

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;

Re: Direct QUERY - Discovery

Wed, 22 Jan 2014 16:18:33 GMT

"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

Re: Direct QUERY - Discovery

Wed, 22 Jan 2014 16:57:31 GMT

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

Re: Direct QUERY - Discovery

Wed, 22 Jan 2014 17:05:31 GMT

Thanks for your reply, I will try

Doc:

QlikView 11 2 SR5 Direct Discovery Technical Addendum.pdf

Re: Direct QUERY - Discovery

Thu, 23 Jan 2014 08:08:10 GMT

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

Thank you

Chris

Re: Direct QUERY - Discovery

Tue, 28 Jan 2014 13:35:05 GMT

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