ETL Problem With Direct Query

pkpandey — Mon, 26 Jan 2026 16:26:21 GMT

While using Direct Query in ETL with Qlikview 11.2 SR6 I am getting the error. Please help

Error snapshot and qvw are attached.

P.K.Pandey

Re: ETL Problem With Direct Query

Tue, 12 Aug 2014 07:28:51 GMT

Hi!

Using SAP connector as a datasource you need to set following environment variables:

SET DirectFieldColumnDelimiter=' ';

SET DirectIdentifierQuoteChar=' ';

Here is the quote from Reference manual:

"For SAP, Direct Discovery can be used only with the QlikView SAP SQL Connector, and it requires the following parameters in SET variables:

SET DirectFieldColumnDelimiter=' ';

SET DirectIdentifierQuoteChar=' ';

SAP uses OpenSQL, which delimits columns with a space rather than a comma, so the above set statements

cause a substitution to accommodate the difference between ANSI SQL and OpenSQL."