topic Re: SAP data output to python ? in Application Development and Automation Discussions

SAP data output to python ?

Former Member — Fri, 20 Dec 2019 09:24:14 GMT

How to access SAP data from windows python, i am working on some projects where i wanted to deal with SAP dataset with Python, need to add rows and columns and modify them from python code. Is there any API or integration by which i can access SAP dataset ??

Re: SAP data output to python ?

FredericGirod — Fri, 20 Dec 2019 09:28:53 GMT

Did you check if your Python could access SAP data through Odata ?

like that https://github.com/SAP/python-pyodata

Re: SAP data output to python ?

thomas_mller13 — Fri, 20 Dec 2019 17:43:27 GMT

Create a Webservice via TA SICF. There are many tutorials in the web about that. You have to implement the interface if_http_extension and register your class in SICF as a Webservice.

https://blogs.sap.com/2016/10/23/creating-class-handler-sicf-service-code-example/

Re: SAP data output to python ?

AndreasForster — Fri, 03 Jan 2020 13:00:23 GMT

Hi Ranveer, There is a fairly new Python interface to interact with HANA data. https://help.sap.com/doc/1d0ebfe5e8dd44d09606814d83308d4b/latest/en-US/index.html

It allows you to work with the HANA data through Python without having to download the rows. Below is a very basic example, which calculates a new column. The outcome can be saved as view in HANA, it can be persisted as HANA table, or the modified data can be downloaded as pandas dataframe if you must.

import hana_ml.dataframe as dataframe
conn = dataframe.ConnectionContext("hxehost", 39044, "ML", "password")
df_pushdown = conn.sql('SELECT * FROM USEDCARPRICES')
df_pushdown = df_pushdown.select('*', ('YEAR(CURRENT_DATE) - YEAR', 'AGE'))
df_pushdown.save("NAMEOFNEWVIEW", "VIEW")
df_pandas = df_pushdown.collect()

A more comprehensive example that also includes Machine Learning is described on https://blogs.sap.com/2019/11/05/hands-on-tutorial-machine-learning-push-down-to-sap-hana-with-python/

Re: SAP data output to python ?

roberto_forti — Thu, 24 Nov 2022 14:19:25 GMT

Hi, try to understand how the module "pyrfc" works.

from pyrfc import Connection.

Re: SAP data output to python ?

Srdjan — Wed, 26 Jul 2023 12:28:48 GMT

> Hi, try to understand how the module "pyrfc" works.

hope this helps: https://github.com/SAP/PyRFC