9 Replies Latest reply: Oct 21, 2013 5:40 AM by anks ag RSS

Hi Experts, How to create JDBC Connection for SAP HANA

Vishali SRR
Currently Being Moderated

Hi Experts,

            Please tell me how to create JDBC Connection for SAP HANA.

  • Re: Hi Experts, How to create JDBC Connection for SAP HANA
    Rama Shankar
    Currently Being Moderated

    If you have the HANA studio installed in your PC, you should have the drivers for JDBC installed automatically.

     

    Which tool are you trying to use to connect to HANA? Depending on that you do that via the tool or you can use the Windows control panel and create a system DSN or local DSN using the JDBC driver and then use that connection within the tool.

     

    Hope this helps.

     

    Regards,

    Rama

  • Re: Hi Experts, How to create JDBC Connection for SAP HANA
    Manish Umarwadia
    Currently Being Moderated

    You create this in the Information Design Tool. With a DSN created within Windows Control Panel, you can only create an ODBC connection,

     

     

     

  • Re: Hi Experts, How to create JDBC Connection for SAP HANA
    Jeet Parmar
    Currently Being Moderated

    1) What application is going to connect to hana using JDBC drivers?

    2) jdbc jar file will be used by ur client application so it should have some connectivity screen where u can give the path of ngbc.jar file.

    3)you can also use other clients libs from /usr/sap/hdbclient dir for ur connectivity

    • Re: Hi Experts, How to create JDBC Connection for SAP HANA
      Muralikrishnan E
      Currently Being Moderated

      Hi Jeet,

       

      1)Almost all the BO Clients can connect to HANA using JDBC Connection.The Relational Connection in IDT can be created using JDBC driver and can be published to BOE Reporsitory.So that this can be used to consume HANA Data in Dashboard,CR,WebI or Explorer.

       

      2)There is no connectivity screen as such.You need to place this ngdbc.jar file in the correct location(as mentioned in he above replies) and with the help of IDT Relational Connection option,you can mention the Host name and Instance number of your HANA DB.

       

      3)When you install the HANA Client(using "....exe -a client" ),all the drivers like ODBC,ODBO and JDBC will get installed in the path you mention.So these drivers also can be used.

      For Eg:AO(Analysis for Office) and CR 2011 use ODBC driver,Microsoft Excel uses ODBO driver.

       

      Rgds,

      Murali

  • Re: Hi Experts, How to create JDBC Connection for SAP HANA
    anks ag
    Currently Being Moderated

    Hi All,

     

    I have gone through quite a few posts about JDBC connection to HANA. The only working answer received is creating connection using IDT's Database Middleware Driver Selection. i was wondering, Hana has been designed to work independently as database and for landscape in which no IDT is used, then how the connection to HDB will be done from HANA Studio.

     

    Pardon me if it sounds stupid, but i think its a valid question for which i haven't found and answer yet. Please help me here. I don't have access to IDT then how am i supposed to create the JDBC connection. is it not possible?

     

    Rgds,

    ankur

Actions