Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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:
Answers would be greatly appreciated
Jan
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...
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
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