topic Re: QlikView Direct Discovery in QlikView

QlikView Direct Discovery

Mon, 17 Apr 2017 12:46:50 GMT

Hello All.

I am using QlikView 11.2 SR 15. I am trying to set up a Direct Discovery connection to an OLEDB SQL server using the following syntax.

DIRECT SELECT Field1,
Field2
FROM Database."Owner"."Database Tables";

When I run the script, I receive a "Line is not valid." error. The script does not seem to like the quotation marks, but that is what the connection set up provides.

Thank you in advance.

Tom

Re: QlikView Direct Discovery

Anil_Babu_Samineni — Mon, 17 Apr 2017 13:16:13 GMT

From help it is showing like below link. Check if it helps you

https://help.qlik.com/en-US/qlikview/12.1/Subsystems/Client/Content/Scripting/ScriptRegularStatements/direct-query.htm

Re: QlikView Direct Discovery

anushree1 — Mon, 17 Apr 2017 14:20:05 GMT

Hi Tom,

I had faced the same issue earlier and got it resolved by adding the below variable before loading the data.Request you to try the same:

SET DirectCacheSeconds= 15;

SET DirectStringQuoteChar=’”’;

SET DirectIdentifierQuoteChar=' ';

SET DirectConnectionMax= 4;

SET DirectTableBoxListThreshold= 100000;

SET DirectDistinctSupport=true;

SET DirectIdentifierQuoteStyle=’ANSI’;