How to Access Relational DB from Python in SAP DI

[IngoPeter]

Hello all,

Which possibilities are there to connect from Python in SAP DI to a HANA DB or more generally to any relational DB?

1. Can I use connections from the connection manager in SAP DI to connect to a relational DB from Python?
2. For HANA this would be possible using the hana_ml library.

Are there any other ways (OData, native libraries, hdbcli, ...)? What are pros and cons?

Thx, Ingo

[lochner_louw]

Hey Ingo,

Depends in which context you are referring to. If you directly want to connect to HANA from Python in an ML context then you can use hana-ml package or the built-in SAP DI SDK.

In Jupyter on DI check blog by Andreas Forster. He has an example where he get the HANA connection to use with hana-ml.

SAP DI SDK:

• https://help.sap.com/viewer/a14d06ba202c41718039647beb04bbd1/3.0.2/en-US/12f7abac63844d4293a339a8eff...

You can have a look at the HANA ML Python SDK examples here:

• https://help.sap.com/doc/1d0ebfe5e8dd44d09606814d83308d4b/2.0.06/en-US/index.html
• https://pypi.org/project/hana-ml/

Thanks,

Lochner