Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
janbouwmans
Contributor II
Contributor II

How can you use the SAP Query w/o generating a list of queries first

Hi,

We want to use the SAP Query connector but get stuck immediately on the following :

When we push the "Search Button"in the SAP queries Bbutton, we get nothing or a time out as a result. Monitoring the sap processes learns that the Query connector starts opening all queries in the system ( which is in our SAP system with 3000+ users a lot), even if you specify th exact query you want.  I it encounters a corrupt query ( we can not avaoid that there are....) the proces dumps in SAP, and we get no result.

My question is:

  1. How can we directly go to the right query without scanning through all of them.
  2. Or, alternatively, how can we limit the list.
  3. Is there some one who can explain how to script the extraction of a query, so that we can do it manually ( if that is doable)

Answers would be greatly appreciated

Jan

3 Replies
Anonymous
Not applicable

Which SAP connector version do you have?

You can limit the list by making  sure that the Connector user is listed in the relevant query user group


The extraction script is a little complex and depend on the query result layout so I think it would be hard to write it without the wizard...

janbouwmans
Contributor II
Contributor II
Author

Hi Yaniv,

We tried limiting the List by restricting the Qlik extraction user to a dedicated Qlikview query user group, that contains just 3 queries. Still, when we connect it looks that SAP keeps checking All queries..... Maybe there is an additional setting in SAP that we need to do?

We are using SAP connector  5.8

Tomas_Sommergyll
Employee
Employee

Hi Jan,

Yes, it is possible to write the query directly in the script, but maybe not easy to get right.

A simple query could look something like this:

CUSTOM CONNECT TO "Provider=QvSAPQueryConnector.dll;ASHOST=x1.x2.x3.x4;SYSNR=00;CLIENT=800;XUserId=xyz;XPassword=xyz;";

[Table0]: // Material Tesx

Load *;

Select SAPQUERY (QUERY (ZMAKT), USERGROUP (QLIKVIEW), WORKSPACE (G), EXTERNAL_PRESENTATION (S), VARIANT (TEST_LANGU_01));

Otherwise, restricting the user groups is a good method as mentioned previously. Try checking the transaction SQ03 in the SAP Gui to verify the groups your user has access to.

Please attach your connector log which shows the issue.

Thanks