Question Re: Consume BW data on Hana with python in Technology Q&A

Consume BW data on Hana with python

former_member659945 — Wed, 12 Feb 2020 10:15:06 GMT

Hi!

Today we are running BW on Hana with runtime license. Now we have some new requirements from our data scientist users, that they want to connect and consume some BW data, for exploration/predictive analysis and machine learning. Want I know that they are working with python via Jupyter notebook, thus they want to connect python to the BW data.

How can I best help them with this requirement?

I have seen that you can use the SAP HANA Python Client API, to connect and consume Hana data. Can you use the Python client API if you only have the runtime license?

To be able to give them access to the BW data on Hana, I will generate SAP HANA views on supported objects (for example Datastore objects), so they can consume the data via HANA, because we have runtime license and not enterprise license.

Can you do like this, or is there some better alternatives, if you only have the runtime license?

Stefan

Re: Consume BW data on Hana with python

john_hawk — Thu, 12 Mar 2020 20:07:56 GMT

Your appraoch is sound.

Re: Consume BW data on Hana with python

AndreasForster — Fri, 13 Mar 2020 07:39:15 GMT

Hi Stefan, Please reach out to your Account Executive to clarify this specific licencing question.
That Python wrapper has some capabilities which might not comply with the runtime restrictions (ie the ability to create tables and upload data).
Greetings, Andreas

Re: Consume BW data on Hana with python

former_member659945 — Mon, 30 Mar 2020 08:44:23 GMT

Thx Andreas for the Answer. I will contact our Account Executive.

Regards

Stefan

Re: Consume BW data on Hana with python

Former Member — Wed, 11 Aug 2021 15:08:13 GMT

https://blogs.sap.com/2020/06/09/connecting-python-with-sap-step-by-step-guide/