Skip to Content
avatar image
Former Member

ODBC/JDBC connectivity to tenant databases with HANA Express Edition

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

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

    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

    Add comment
    10|10000 characters needed characters exceeded

  • May 09, 2017 at 05:06 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Dec 05, 2017 at 12:36 PM

    Hello Eric,

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

    Thanks

    Anthony

    Add comment
    10|10000 characters needed characters exceeded