Skip to Content

Tableau connecting SAP HANA DB

Hi,

I am trying to connect SAP HANA DB and I am getting below error

An error occurred while communicating with SAP HANA. The connection to the data source might have been lost. [SAP AG][LIBODBCHDB DLL][HDBODBC] Communication link failure;-10709 Connect failed (connect timeout expired) Unable to connect to the server "10.249.0.50". Check that the server is running and that you have access privileges to the requested database.

The port 31015 is opened and is anything you need initiate from the network team for HDODBC connection. Our HANA DB is Multi-tenant DB I tried all the option. I am using SYSTEM user do i need add any specific privilege for SYSTEM user. I have installed HANA Client 2

Your assistance highly appreciated

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    Aug 16, 2018 at 05:05 AM

    Your istance number is really 10 (as indicated by 31015)?

    As you are saying you are using an MDC system, to which database you are trying to connect? To the system database or to a/the first tenant database. The standard port for the SYSTEM database is 3xx13 (xx = your instance number), using 3xx15 in a default config would connect to the first tenant database.

    Regards,
    Florian

    Add comment
    10|10000 characters needed characters exceeded