topic Re: database SPA HANA in QlikView

database SPA HANA

Anonymous — Mon, 26 Jan 2026 21:26:37 GMT

Connector SAP already provides the connecting link to the new SAP HANA database?

thanks for your cooperation

Re: database SPA HANA

JonnyPoole — Tue, 07 Oct 2014 15:36:06 GMT

The SAP Connector from QlikView can access HANA IF Netweaver is deployed on HANA.

But you don't need the SAP Connector , you can use the ODBC driver that comes with HANA to do the connection via ODBC free of charge and that allows you to access HANA if the first condition above is not met.

Re: database SPA HANA

mats_olin — Tue, 07 Oct 2014 15:39:53 GMT

You can connect directly to SAP HANA through the JDBC or ODBC connector provided by SAP and the standard JDBC or ODBC connector in QV if you wan't to access analytical views for example. If you run 'BW on HANA' and want to access your BW objects you can also use the different QV SAP connectors if you have those aswell. Just like Jonathan said / Mats

Re: database SPA HANA

tobivogt — Thu, 14 Apr 2016 13:15:16 GMT

Hi Jonathan,

as I'm currently doing some tests with HANA via odbc and I'd like to ask whether the login windows appears or appeared too, and how you can supress this for using odbc in automated reload tasks.

On each reload I get the popup to enter username and password or just got to confirm the given entries.

Regards and many thanks for any hints,

Tobias

Re: database SPA HANA

tobivogt — Fri, 22 Apr 2016 06:28:17 GMT

A short note to my previous post:

There is a newer ODBC-Driver Version with no popup on reload.

That might be used for automated reloads.

Re: database SPA HANA

Anonymous — Tue, 12 Jul 2016 13:10:08 GMT

Where can I get this new ODBC-Driver Version? And what do I need to take care of?

Re: database SPA HANA

tobivogt — Tue, 12 Jul 2016 13:54:15 GMT

Hey, hi Mathias,

you can download this via SAP Marketplace as a SAR-File you have to unzip via SAPCAR.

The ODBC-Driver is part of the SAP HANA CLIENT.

After Unzip the SAR-File run the Installation and make sure it has been selected for being installed.

Hope it helps

CU,

Tobias

Re: database SPA HANA

Anonymous — Tue, 12 Jul 2016 15:22:17 GMT

Hey Tobias,

Thank's for your quick response.

So I downloaded the latest Version (1.00.112.04) and installed it.

But the login window still appears.

Do I have to change something (what? where?) in QV or create a new ODBC-datasource (User- or System-DSN)?

Thank's in advance!

Re: database SPA HANA

tobivogt — Tue, 12 Jul 2016 15:34:42 GMT

Hi Mathias,

so what is your HDBODBC-Driver Version you can see in ODBC-Source Administration?

My Version is 1.00.102.05.

Could you test successfully the Connection to your SAP HANA DB in ODBC-Source Administration?

My Version of the SAP HANA Client - SAR File was

IMDB_CLIENT100_102_5-10009664.SAR

In QV you have to create the connect string once with the credentials.

Does it work when you entered your credentials?

Or does it carry on if you entered your credentials again?

Regards,

Tobias

========

Re: database SPA HANA

Anonymous — Tue, 12 Jul 2016 16:10:16 GMT

Hi Tobias,

my driver version in ODBC-Administration is 1.00.112.04. I also tested the connection successfully in ODBC-Source Administration.

My Version of SAP HANA Client is :

File-Version: 1.0.112.10582

Product-Version: 1.00.112.04.1467296086

I can create a connect-string to Hana (this works fine!) and I can also load data (I have to enter my credentials every time). But as soon as I want to load again or add a view or table I have to enter my credentials again and again...

Can I create (how?) a connect-string (in QlikView) including my credentials?

Like that:

ODBC CONNECT TO DEMO_HANA (XUserId is KaFUbJFLTCVKUGBA, XPassword is TLICUJFMQDaCGXFMRRMGTTA);

Thank's in advance!