15". ![58410..." /> 15". ![58410...">

Hana Multi-tenant connection on BI 4.2

The OLAP connection to HANA asks for an instance number and it then connects to the HANA server on port "3<instance_number>15".

58410409edbd9.png

But in multi-tenant scenarios the port number changes. It cannot connect to SAP HANA tenant or system DB. Below is the link for SAP on-line help about Port Assignment in Tenant Databases.

Connections for Multitenant Database Containers

Here is the work around.

First check and note the proper port of the tenant SQL port from Studio system properties, here is 35941.

584104d0b1281.png

Then enter host name with port number in host name field on OLAP connection setup screen.

Please add the semicolon at the end

Here is 192.168.1.59:35941;

584105bdd5a94.png

Test the connection

5841067441020.png

Hana Multi-tenant connection on BI 4.2 ================== The OLAP connection to HANA asks for an instance number and it then connects to the HANA server on port "3<instance_number>15". ![58410409edbd9.png](serve/attachment&path=58410409edbd9.png) But in multi-tenant scenarios the port number changes. It cannot connect to SAP HANA tenant or system DB. Below is the link for SAP on-line help about Port Assignment in Tenant Databases. [Connections for Multitenant Database Containers](https://help.sap.com/saphelp_hanaplatform/helpdata/en/44/0f6efe693d4b82ade2d8b182eb1efb/frameset.htm) Here is the work around. First check and note the proper port of the tenant SQL port from Studio system properties, here is 35941. ![584104d0b1281.png](serve/attachment&path=584104d0b1281.png) Then enter host name with port number in host name field on OLAP connection setup screen. _**Please add the semicolon at the end**_ Here is **_192.168.1.59:35941;_** ![584105bdd5a94.png](serve/attachment&path=584105bdd5a94.png) Test the connection ![5841067441020.png](serve/attachment&path=5841067441020.png)

Perfect is not enough - must be irreplaceable!

Alternately, we can use below query to find out the ports tenant database uses.

SELECT 
DATABASE_NAME, 
SERVICE_NAME, 
PORT, 
SQL_PORT, 
(PORT + 2) HTTP_PORT 
FROM 
SYS_DATABASES.M_SERVICES
WHERE 
DATABASE_NAME='HDB' 
and ((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or 
(SERVICE_NAME='xsengine'))

586e95d492d22.png

Alternately, we can use below query to find out the ports tenant database uses. ```` SELECT DATABASE_NAME, SERVICE_NAME, PORT, SQL_PORT, (PORT + 2) HTTP_PORT FROM SYS_DATABASES.M_SERVICES WHERE DATABASE_NAME='HDB' and ((SERVICE_NAME='indexserver' and COORDINATOR_TYPE= 'MASTER') or (SERVICE_NAME='xsengine')) ```` ![586e95d492d22.png](serve/attachment&path=586e95d492d22.png)

Perfect is not enough - must be irreplaceable!

394
views
1
replies
1
followers
live preview
enter atleast 10 characters
WARNING: You mentioned %MENTIONS%, but they cannot see this message and will not be notified
Saving...
Saved
All posts under this topic will be deleted ?
Pending draft ... Click to resume editing
Discard draft