SAP HANA

1. Create a dedicated user

What: Create a non-human user in SAP HANA for Querio.

CREATE USER QUERIO_USER PASSWORD "STRONG_PASSWORD" NO FORCE_FIRST_PASSWORD_CHANGE;

2. Grant read-only access

What: Give Querio SELECT access to the specific schemas it should query.

GRANT SELECT ON SCHEMA "MY_SCHEMA" TO QUERIO_USER;

Repeat the grant for each schema Querio should access.

3. Share connection details

Provide:

• Username
• Password
• Host
• Port, usually 443 or 39015 (depends on your HANA Cloud or on-premise setup)
• Schema (optional, used as default schema)

Connection string format:

hana://<username>:<password>@<host>:<port>?encrypt=true&sslValidateCertificate=true