This dialect allows you to use the SAP HANA database with SQLAlchemy and pyhdb driver.

The dialect is currently experimental and doesn't support all possible features in SQLAlchemy with SAP HANA.

The usage of the python database interface delivered by hdbclient, is currently not supported.

At the moment the dialect only supports the pure Python database driver pyhdb. It's recommended to use pyhdb version 0.3.1 or above.

See the README of pyhdb about how you can install the driver.

Install from Python Package Index (coming soon):

$ pip install sqlalchemy-hana

You can also install the latest version direct from a cloned git repository.

$ git clone https://github.com/SAP/sqlalchemy-hana.git
$ cd sqlalchemy-hana
$ python setup.py install

If you do not have access to a SAP HANA server, go to the SAP HANA Developer Center and choose one of the options to get your own trial SAP HANA Server.

Now you can create a engine with the usage of the HANA dialect. This engine works like all other engines of SQLAlchemy.

from sqlalchemy import create_engine
engine = create_engine('hana://username:[email protected]:30015')

If you found bugs or have other issues than you are welcome to create a GitHub Issue. If you have questions about usage or something similar please create a Stack Overflow Question with tag sqlalchemy and hana.