This repository provides an easy to use example for how to connect and persist data to SAP HANA within a Jupyter Notebook. It uses the existing "to_sql" interface of DataFrames and makes easy persistence possible.
The sample data comes from the Mannheim OpenData Tool. The dataset is licensed under dl-de/by-2-0.
- pandas
- numpy
- hdbcli
- sqlalchemy
You can simply use pip to install the dependencies. Example:
pip install hdbcli
It is as simple as it looks. Just add your credentials into the Notebook's according variables, run it and see your persisted data in your SAP HANA instance.
I documented more information about this repository and it's use case in two blog posts.
- Blogpost on blogs.sap.com (in english)
- Blogpost on my personal blog (in german).