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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources 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=' ';