1 Reply Latest reply: Feb 16, 2017 11:51 AM by John Baker RSS

    Qlik: HANA DB with ODBC and requirements of HANA Studio

    Thomas Fabian

      Hi experts

       

      We want to install Qlik on a  Server.

      On the source side we want to connect natively to a SAP HANA database.

      HANA studio is already installed on SAP side.

       

      Is there a need to install HANA studio client on the Qlik server to connect with ODBC to HANA DB?

       

      Thanks

      Thomas

        • Re: Qlik: HANA DB with ODBC and requirements of HANA Studio
          John Baker

          It looks like you have to install the whole client software package...bit of bad design really when you only want the ODBC driver, but this is most probably does as SAP want you to use their own BI solution.

           

          The actual ODBC drivers are: HDBODBC (64bit) or HDBODBC32 (32bit) but I can't find anywhere you can download just the driver.

           

          Here's a doc I found: https://kb.informatica.com/h2l/HowTo%20Library/1/0563-ConfigODBCConnToSAPHANA-H2L.pdf

           

          Install the SAP HANA ODBC Driver SAP HANA ODBC drivers are packaged with the SAP HANA client software. Install the client software for the SAP HANA database system. The client software includes the drivers needed to connect to the database. Install the SAP HANA database client, version 1.00.49 or later. Download the SAP HANA client software from the SAP Software Download Center. You must have an account with SAP to download the software. In the United States, you can download the SAP HANA client from the following site: https://hanadeveditionsapicl.hana.ondemand.com/hanadevedition/ Install the SAP HANA client software on the following machines:  Servers where the PowerCenter Integration Service or the Data Integration Service run.  Machines where Informatica client software is installed