Qlik Community

QlikView Connectors

Highlighted
Not applicable

Qlik: HANA DB with ODBC and requirements of HANA Studio

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

1 Solution

Accepted Solutions
joantbak
New Contributor III

Re: Qlik: HANA DB with ODBC and requirements of HANA Studio

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

View solution in original post

1 Reply
joantbak
New Contributor III

Re: Qlik: HANA DB with ODBC and requirements of HANA Studio

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

View solution in original post