topic Re: Direct Discovery Script with SAP source doesn't work in QlikView

Direct Discovery Script with SAP source doesn't work

Wed, 25 Nov 2020 16:16:04 GMT

Guys,

Anyone knows whether QvSAPConnector.dll supports Direct Discovery at all or it is just JDBC? I see all examples in the forum use JDBC.

The script is this.

CUSTOM CONNECT TO "$(vConnectSAPBW)";
//
DIRECTDiscovery:
Direct QUERY
DIMENSION
MATERIAL
MEASURE
BASE_QTY
FROM
[/BIC/ARPA_OC1000];

Thanks,

Ram

Fri, 08 Jul 2016 08:36:55 GMT

Hi,

Direct Discovery does work with SAP Connector. Perhaps try the same syntax without table name:

CUSTOM CONNECT TO "$(vConnectSAPBW)";

Direct QUERY
DIMENSION
MATERIAL
MEASURE
BASE_QTY
FROM
[/BIC/ARPA_OC1000];

Sun, 10 Jul 2016 23:34:10 GMT

No Pravesh. It doesn't.

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

SET DirectFieldColumnDelimiter=' ';

SET DirectIdentifierQuoteChar=' ';