Connection to hana DB through PHP/Python with Hdbuserstore

56 Views Asked by At

I'm using PHP to execute a Python script that connects to a Hana DB:

When using the full connection string, data retrieval from the DB works fine:

engine_hana = sqlalchemy.create_engine(f'hana+hdbcli://{user}:{quoted_password}@{host}:{port}/{tenant}', echo=False)

Now, I'm attempting to utilize hdbuserstore to connect to the DB in order to conceal connection information using this connection string:

engine_hana = sqlalchemy.create_engine(f'hana+hdbcli://userkey={KEY}/{TENANT}', echo=False)

However, I'm encountering the following error:

(hdbcli.dbapi.Error) (-10104, 'Invalid value for KEY "XXX", directory search path: /var/www/.hdb/')

To connect to hana database with hdbuserstore mechanism

0

There are 0 best solutions below