Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

SAP HANA Navigator

Hello, Im trying to make dicret connection to my sap hana express. I got the connection and it seems that everyting is going well(Or that's what i believe) . Anyway after i connect to the sap hana database, and in the Navigator window I only see the Contents Folder, no tables nothing...!!

Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    Well, ya the answer was right! 

    The sulotion was actually there, just install the Client of SAP HANA 

    and add that connection to ODBC Administrator with correct ip and port which usually 3<instance number> 13  (ip:3<IN>13)

    and I choose the system username and password "Not the best choice " and when the connection succeed, just in the Get Data in Power bi choose Other-> ODBC .
    That is how did it work for me . 

5 Replies

  • dexterz's avatar
    dexterz
    Icon for Helper II rankHelper II
    9 years ago

    you can only see the cube in contents by hana drive.

    want to see the table should through the odbc drive.

    • Eric_Zhang's avatar
      Eric_Zhang
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago
      dexterz wrote:

      you can only see the cube in contents by hana drive.

      want to see the table should through the odbc drive.

      dexterz

      Thanks for that information! Is there any documentation talking about this limitation?

    • psdhillon1's avatar
      psdhillon1
      Icon for Helper I rankHelper I
      4 years ago

      Hi, 

      I am facing same issue & able to connect using ODBC, Though with ODBC connection, i can see all the raw data tables not the polished tables, as i can see in many tutorial videos. When i check with Hana connector, the screenshot given above is on my screen, No Cube is visible, but i can see the cubes in different packages in hana studio. it looks like it is priviledge issues, but i am not sure what priviledge i shoudl eb asking from hana team. Please suggest

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Well, ya the answer was right! 

    The sulotion was actually there, just install the Client of SAP HANA 

    and add that connection to ODBC Administrator with correct ip and port which usually 3<instance number> 13  (ip:3<IN>13)

    and I choose the system username and password "Not the best choice " and when the connection succeed, just in the Get Data in Power bi choose Other-> ODBC .
    That is how did it work for me . 

    • sathishdsk's avatar
      sathishdsk
      Frequent Visitor
      6 years ago

      Hi Anonymous ,

       

      I know this is pretty old post. But if it happens you look this message now, can you elaborate on "Add that connection to ODBC administrator"? I have SAP HANA Studio installed in my laptop and tried through Other --> ODBC in Power BI. But no luck. I am not clear on what to pass or how Power BI determines the system to connect to (Dev / QA / Prod)? More light on this will be really helpful.

       

      Thanks,

      Phani