Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Direct Discovery Script with SAP source doesn't work

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

2 Replies
Not applicable
Author

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];

Not applicable
Author

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=' ';