Forum Discussion

alexpancakes's avatar
alexpancakes
Microsoft Employee
10 years ago

Connecting to SAP HANA

Hi everyone. I am trying to get data from SAP HANA DB and also to configure the gateway for it.

 

When I try to get data via power bi desktop, I am getting error:

"ODBC: ERROR [08S01] [SAP AG][LIBODBCHDB DLL][HDBODBC] Communication link failure;-10709 Connect failed (no reachable host left)"

As far as I understant, the problem is with ODBC driver? I installed and configured it via DNS provider (tried to connect - it was successful)

What else can it be? Or what I may did wrong?

 

Also when I try to configure enterprise gateway, via 2 different VMs, I am getting 2 error: 

 

1 - (Windows 7) - We encountered an error while trying to connect to sap*.com:32015. Details: "We reached the enterprise gateway, but the gateway can't access the on-premises data source.", Error Code: DM_GWPipeline_Gateway_DataSourceAccessError

Underlying error code: -2147467259

Underlying error message: [Microsoft][Диспетчер драйверов ODBC] Источник данных не найден и не указан драйвер, используемый по умолчанию (it says that the data source wasn't found and the driver which is used by default, wasn't pointed)


2 - (Windows Server) - It wasn't me who configured the gateway but at first everything was OK but then (don't know why) the error came: The gateway is either offline or could not be reached. Error Code: DM_GWPipeline_Client_GatewayUnreachable 

 

I really need to make it work any way!

Huge thanks for every suggestion in advance.

Need Help

16 Replies

  • mllopis's avatar
    mllopis
    Community Admin
    10 years ago

    Hi Alex,

     

    The first error seems to indicate that the machine that you are using does not have connectivity to the SAP HANA server. Can you verify that you can connect to that server from the same machine using other client tools?

     

    Thanks,
    M.

    • alexpancakes's avatar
      alexpancakes
      Microsoft Employee
      10 years ago

      Hi,

      well, via the ODBC admin panel the connection is successful (via personal or system DNS)

       

      Actually, this is my first time working with SAP so if you can suggest any client I can try to ping sap hana from my VM to check connectivity, it will be great!

      • Alisher's avatar
        Alisher
        New Member
        8 years ago

        Hi Alexpancakes,

         

        Have you managed to solve for this? If yes, could you please contact me @lenta.com?

         

        BR,

        Alisher

  • kot219's avatar
    kot219
    Regular Visitor
    10 years ago

    Hi Alexpancakes,

     

    Facing same error when we try to connect to HANA. But in my case i am able to connection with other HANA DB'S and only facing issue with one HANA DB. Did you get any break through on below issue? Any help is highly appreciated? Thank you!

     

    Regards,

    Kotesh 

      • nerusul's avatar
        nerusul
        New Member
        10 years ago

        Hi Alex 

         

        I'm facing the same issue , Is your issue is resolved ,if so could you please share the details

         

        Thanks

        Lakshmi

  • saunders's avatar
    saunders
    Helper II
    10 years ago

    Just wanted to add that I'm having the same issue.  I'm getting my infrastructure security folks to check that the date gateway machine can access our SAP HANA in the cloud.  If we manage to fix the issue I'll post back here.

    • Jeremy_Rogers's avatar
      Jeremy_Rogers
      Frequent Visitor
      9 years ago

      When you are creating your SAP HANA connection are you specifying a port as well?  This error was happening to me because the connection creation interface wasn't very specific about the need to include a port.  Once I did, the issue appeared to resolve.  So, when prompted for the "server" express it like this:  <servername>.<domain>.<com/net>:<port>

       

      I'm not sure if it's a standardized thing or not, but if you just know the server name and instance number (say your instance number is "02") then your port may look something like 30215 or "3<instanceNumber>15".  Otherwise maybe just try the default port of 30015.

       

      Hope that helps.

      • Jan_Vautmans's avatar
        Jan_Vautmans
        New Member
        9 years ago

        Hello All

         

        That last one deffinitely helped for me: 30215 or "3<instanceNumber>15" into the port number.

         

             Thanks a lot Jeremy, Jan

  • elementalfire23's avatar
    elementalfire23
    Frequent Visitor
    7 years ago

    I'm having the same issue.

     

    I've added the port number and I'm connecting via database credentials and I'm still getting the timeout. Anything else I could try?

  • velusekar's avatar
    velusekar
    Frequent Visitor
    6 years ago

    Hi team

    I am using SAP Hana as a Datasource in one of my power bi report and dataset getting a refresh with my desktop report without any issues, but the same report is getting fails with the below error in power bi service when its refreshed through power BI gateway.

    but it's not happening all the time, sometimes its get success automatically.

     

    ODBC: ERROR [S1000] [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;7 feature not supported: invalid character encoding: '&4', /db/e0/27(

    I am not sure what is the cause of the issue, Please help me on this.

     

    Thanks

    Velu.s