Skip to main content
Announcements
Global Transformation Awards! Applications are now open. Submit Entry
cancel
Showing results for 
Search instead for 
Did you mean: 
kenphamvn
Creator III
Creator III

Qlik Sense connect to HANA using ODBC not show some schema

Hi All

i'm trying create connection from Qlik Sense to SAP HANA using ODBC as the link

SAP HANA AND QLIK VIEW/SENSE | SAP Blogs

Everything ok, connection success but unfortunately this will not set the some Schema in the dialog (ex: FIHANA..like the link above)

Here my connector result

HANAConnector.png

I think there is a problem in access permission from HANA but i don't know how to check it

i'm not familial with HANA

 

how to resolve this problem please help me?


Regards,

An Pham

2 Replies
RenzoH
Partner - Contributor III
Partner - Contributor III

Hello An,

I'm having the same issue. If you managed to solve it, please let me know. Thank you!

Regards,

Renzo Hohagen

 

 

 

 

Kalmer
Partner - Creator
Partner - Creator

Hi!

1)First make sure that you have the ODBC 64-bit connection. In my experience QS will not find the 32-bit connections.

ODBC.jpg
1.1) If you just have the ODBC Data Source connection then download it from here: https://dev.mysql.com/downloads/connector/odbc/

2) In the webpage (https://blogs.sap.com/2015/08/04/sap-hana-and-qlik-viewsense/) it shows the "OLE DB" connection instead of the ODBC one. Since you made the ODBC USER DSN connection, you should use ODBC instead of OLE DB.
After you've chosen the USER DSN, try to find the connection you created and fill in the missing parameters.

ODBC2.jpg

Hope this helps you!
Good luck!

K