Forum Discussion
Multi-tenant HANA database setup
Hello community, I am working with a multi-tenant setup in which one SAP HANA connection parameter string refers to two different databases. These two databases have the same IP address P...
As far as I understand it, every tenant database has its own port to connect to. You can find the correct port by executing the following query in the HANA SYSTEM database - look for the SQL_PORT:
SELECT DATABASE_NAME, SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS_DATABASES.M_SERVICES WHERE DATABASE_NAME='<DBNAME>' and ((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NAME='xsengine'))