Utente SAP per QlikView Sap Connector

[picqv]

Salve a tutti,

abbiamo installato recentemente presso un nostro cliente il Sap Connector di QlikView. L'utente SAP usato dal connettore è stato creato secondo le specifiche di installazione del connettore (QlikView SAP Connector 5.20 Installation Notes.doc) . Il connettore si collega correttamente, utilizzando la connessione OLAP, vede i metadati (InfoCubi), crea lo script pseudo MDX e lo esegue senza restituire errori. Il problema riscontrato è che non estrae alcun dato. I dati sono presenti su SAP BW, abbiamo testato lo script direttamente su ambiente SAP ed estrae dati. Dopo aver modificato il profilo dell'utente SAP con profilo SAP ALL rieseguendo lo script venivano estratti anche i dati. La nostra conclusione è che le specifiche di configurazione dell'utente SAP contenute nel documento di installazione non vadino bene nel nostro caso.

Avete già avuto problemi simili, sapete darci indicazioni su come configurare l'utente SAP per far estrarre anche i dati?

Grazie mille

A disposizione

Un saluto

Fabio Nuzzo | Pic Servizi per l'Informatica S.r.l. | fnuzzo@pic-informatica.it

[disqr_rm]

I wish your question was in english.

[biester · Accepted solution]

Well, I don't have much idea about SAP but I'll reduce my role here in trying to translate so that community can help:

"We have recently installed the QlikViewSAP connector at one of our customers. We have setup the SAP client used by the connector according to QlikView SAP Connector 5.20 Installation Notes.doc. The connector is correctly connecting, using the OLAP connection, retrieves the metadata (InfoCubi), creates the pseudo MDX and executes it without returning any errors. The problem is that it does not extract any data. Tha data is present in SAP BW, we have tested the script directly in th SAP environment and it is retrieving data. After having modified the profile of the SAP client with profile SAP ALL and reexecution of the script, also data was retrieved. Our conclusion in the matter is that the configuration specifications of the SAP client in the mentioned document might not apply in our case.
Has anybody had similar problems, can you give us a hint how to configure the SAP client to extract also the data?

A thousand thanks and regards, ...."

Don't know whether my nomenclature and termini technici are correct, but I hope it helps a little,
Regards,

Joachim

[picqv]

Thank you very much Joachim for your help!

Fabio

[disqr_rm]

Thanks Joachim for such a perfect translation.

For the problem:

Please double check section "4.1.3 User configuration" in the Installation documentation and make sure you are correct roles setup. Please make sure to press "User Comparision" button in the PFCG when editing the role and assigning the user. It seems the user you are using does not have authorizations to extract the data.

If problem still exists, check section 4.2.4 in the documentation to enble the logging and analyze the logs generated.

[tabletuner]

I never used the BW connector. However, I had some problem with the connector about a year ago. The connector couldn't read any data like in your problem. At last I found out that the SAP database was running on a cluster server. This server had a unique ip address and several underlying separate ip adresses. My advice is to double check the IP adresses that you are using. You might use the wrong one right now.