But then I got my SAP HANA, express edition installation and would like to connect to that. As a starting point, I leverage tutorial Use JupyterLab with SAP HANA, express edition. Luckily, since on SAP Data Intelligence already, I can skip steps 1 – 6 and directly install the required Python modules:
With this I connect to my SAP HANA, express edition leveraging sqlachemy and count my tables:
Alternatively, I use directly the SAP HANA Python driver which follows the Python Database API Specification to consume data:
The advantage of using SAP Data Intelligence is that you can turn your JupyterLab notebook directly into an SAP Data Intelligence Data Pipeline:
For more details check out the openSAP course SAP Data Intelligence for Enterprise AI, especially Unit 9: Operationalizing Python and R with the Pipeline Modeler.