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