cancel
Showing results for 
Search instead for 
Did you mean: 

ODBC/JDBC connectivity to tenant databases with HANA Express Edition

Former Member
0 Kudos

Hi,

I cannot connect to any tenant database using ODBC. I can connect to the System database (Port 39013). Any attempt to connect on port 39015 fails

On a related note, my attempts to create a connection with IDT using JDBC also fail (The connection is also made through port 39015). I can shoehorn port 39013 by selecting "Multi Server" as data source, but here again I can only connect to the System database.

Any suggestions?

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member

Hi Frank,

I have tried your suggestion (In my case the port in question is 39040, but I still can't establish an OBBC connection to database other than System.

The interesting thing is, I can write a small Java program to connect to my tenant database with the following connection string:

jdbc:sap://hxehost:39013/?databaseName=HANA

So it seem that 39013 is the port to connect to, though so far I have not been able to connect to a tenant database other than via by Java code, or using Hana Studio. Every other client tool will not let me access a tenant database (Only System)

Cheers,

Eric

Former Member
0 Kudos

Hello Eric,

Were you able to connect to the tenant DB via the studio, i am facing the same issue .

Thanks

Anthony

architectSAP
Active Contributor
0 Kudos

Hello Eric,

I am afraid you are trying to connect to the wrong port. The SQL/MDX acces port for standard access to the tenant database of a multitenant HANA system is in the range of 3NN41 - 3NN98 (see TCP/IP Ports of All SAP Products).

You can find this port from your SAP HANA Studio. In my case it is 30041:

Best regards

Frank