Qlik Community

QlikView Connectors

picqv
New Contributor

Utente SAP per QlikView Sap Connector

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

1 Solution

Accepted Solutions
biester
Valued Contributor

Utente SAP per QlikView Sap Connector

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

5 Replies
disqr_rm
Valued Contributor III

Utente SAP per QlikView Sap Connector

I wish your question was in english.

biester
Valued Contributor

Utente SAP per QlikView Sap Connector

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

Utente SAP per QlikView Sap Connector

Thank you very much Joachim for your help!

Fabio

disqr_rm
Valued Contributor III

Utente SAP per QlikView Sap Connector

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
Contributor III

Utente SAP per QlikView Sap Connector

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.

Community Browser