SQLAlchemy dialect for SAP HANA Database
Project description
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.
Prerequisites
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
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
Getting started
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:password@example.de:30015')
Contribute
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.
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.