Qlik Community

QlikView Connectors

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
janbouwmans
New 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

Tags (2)
3 Replies
yfe
Contributor III

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

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
New Contributor II

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

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

Employee
Employee

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

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

Community Browser