Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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=' ';