topic Re: Qlik & SAP S/4 HANA in QlikView

Qlik & SAP S/4 HANA

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

Anyone using Qlikview or Qlik Sense on customer with SAP S/4 HANA ? if yes have you successfully connected to the database and do the data extraction only using an ODBC connection to HANA ?

Re: Qlik & SAP S/4 HANA

vijayit43 — Mon, 25 Dec 2017 07:03:00 GMT

Hi ,

You have find any Solution?

Re: Qlik & SAP S/4 HANA

pablolabbe — Tue, 26 Dec 2017 23:16:10 GMT

Hi Vijay,

I found some documents from SAP related to the ODBC connection to HANA, and technically speaking, it´s possible. I'm not sure if the software agreement allows or not this practice for the ERP tables.

In the SAP documentation I also found information about Cluster and Pool table on R/3 and the conversion of such kind of table to SAP S/4. After conversion all table are Transparent. So you can freely query the data from all tables available in the system using an ODBC connection.

I found some posts related to Qlikview and Hana. . Maybe it could help you:

QlikView and SAP HANA‌

Re: database SPA HANA

QlikView JDBC Connector

SAP HANA vs Qlikview

I also attached a documentation from Qlik explaining several options available to connect QlikView or Qlik Sense to HANA.

PS: I didn´t have the opportunity to connect to this database yet.

Re: Qlik & SAP S/4 HANA

Peter_Cammaert — Wed, 27 Dec 2017 00:15:15 GMT

Good feedback, Pablo. Thanks.

Re: Qlik & SAP S/4 HANA

dionverbeke — Wed, 27 Dec 2017 07:41:34 GMT

We were able to connect to SAP 4/HANA and It is very fast (typically in the range of Qlik's in memory speed), but as you mentioned not all types of table are readily available.

We found that direct discovery or on demand generation is the best way to use this technology as the snapshot one has no benefit given the high cost of SAP.

I know that SAP requires you to use the open hub license, although that is typically not enforced if your population is large enough.

We did not yet test yet the pass-through security of the driver.

Kind Regards,

Dion

Re: Qlik & SAP S/4 HANA

pablolabbe — Wed, 27 Dec 2017 11:29:28 GMT

When applicable please mark the appropriate replies as CORRECT. This will help community members and Qlik Employees know which discussions have already been addressed and have a possible known solution. Please mark threads as HELPFUL if the provided solution is helpful to the problem, but does not necessarily solve the indicated problem. You can mark multiple threads as HELPFUL if you feel additional info is useful to others.

Re: Qlik & SAP S/4 HANA

pablolabbe — Wed, 27 Dec 2017 19:35:37 GMT

HI Dion,

Thanks for your feedback.

Are you using HODBC driver or the Qlik SAP SQL Connector ?

Re: Qlik & SAP S/4 HANA

dionverbeke — Wed, 27 Dec 2017 19:51:18 GMT

HODBC with Hana

Re: Qlik & SAP S/4 HANA

Anonymous — Tue, 07 Aug 2018 18:47:59 GMT

Resolution

Qlik support connecting to HANA Views on S/4 HANA with the Qlik ODBC connector, this assumes that the SAP ODBC Driver has been installed on the Qlik system. We also support Netweaver 7.5 with the Qlik SAP Connectors, SAP S/4 HANA is using Netweaver 7.5 so it is possible to use e.g. the SQL Connector with SAP S/4 HANA.

Provided that you already have installed the ODBC connector provided by SAP, Qlik ODBC connector gives you an option to HANA views on S/4 HANA.

From SAP Connectors 6.3, we support Netweaver 7.5. From Qlik Sense 3.0 we are certified for SAP HANA using ODBC

Re: Qlik & SAP S/4 HANA

cansuaatalay — Fri, 10 Feb 2023 12:54:17 GMT

Hi,

How to connect S4Hana Public Cloud with Qlik SaaS? Is this possible?

Thank you.

Re: Qlik & SAP S/4 HANA

Chip_Matejowsky — Wed, 15 Feb 2023 15:10:52 GMT

HI @cansuaatalay,

As this thread is over 4 years old and versions have evolved greatly since then, suggest that you open a new thread in the Qlik Sense forum.

Best Regards

Re: Qlik & SAP S/4 HANA

williammarcytvh — Fri, 22 Nov 2024 15:09:27 GMT

Bonjour,

Oui c'est possible et c'est obligatoirement via oData avec les APIs disponibles et proposées par SAP. Elles sont référencées ici :

https://api.sap.com/package/SAPS4HANACloud/odata