cancel
Showing results for 
Search instead for 
Did you mean: 

PaPM Cloud: How to calling HANA stored procedure inside a PaPM environment using Python RFA

danielaceresa89
Explorer
0 Kudos
420

Dear all,

as anyone tested succesfullly this kind of feature or founded documentation that explain it? If yes, how? If not, what alternative way?

Thank you.

Best regads.

Daniela C.

edwiromero_s
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Daniela,

Did you found a way to do this?

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

danielaceresa89
Explorer
0 Kudos

No 😅 I tried also to open an incident and the response wans't good.

Here the extract

 

I understand the issue you're encountering while establishing connection to SAP HANA using Python RFA in PaPM. 

 

Upon investigating, we found that the connection that you are trying to establish fails. We would like to highlight that pandas.connect() is not a supported API according to the official documentation of pandas library. Furthermore, there is no alternate approach of connecting to HANA database which is currently supported in Python RFA and this is by design to avoid security issues.

 

As an alternative, you can retrieve data using the method data = scope.get('data', []). Please have a look at https://blogs.sap.com/2023/12/28/using-the-python-rfa-function-in-papm-to-calculate-the-difference-b... to get a detailed example showcasing the same.

 

If anyone had a positive experience, please tell us 😅