Skip to Content
0

ODBC/JDBC connectivity to tenant databases with HANA Express Edition

May 09, 2017 at 03:09 PM

849

avatar image
Former Member

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?

capture.png (17.2 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

avatar image
Former Member May 10, 2017 at 02:14 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded
Frank Schuler
May 09, 2017 at 05:06 PM
0

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


indexserver.png (62.1 kB)
Share
10 |10000 characters needed characters left characters exceeded
avatar image
Former Member Dec 05, 2017 at 12:36 PM
0

Hello Eric,

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

Thanks

Anthony

Share
10 |10000 characters needed characters left characters exceeded