Qlik Community

QlikView Connectivity

Discussion board for collaboration related to QlikView Connectors.

Announcements
Read about the latest Qlik Community enhancements on the Community News blog!
cancel
Showing results for 
Search instead for 
Did you mean: 
greeshma_k
Creator III
Creator III

Custom Read Error while connecting to SAP HANA

Hi,

I need to connect to SAP HANA. I am trying to do this using a JDBC connector and i have followed the steps shown in this video

QlikView Connect and Direct Discovery with SAP HANA - YouTube   

However, when i click on the Select option in the edit script i am getting a 'Custom Read Failed' error.

Could someone help me with this?

Regards,

Greeshma

6 Replies
greeshma_k
Creator III
Creator III
Author

Hi All,

Any help with this?

rbecher

Regards,

Greeshma

rbecher
MVP
MVP

Hi Greeshma,

this is probably a configuration problem. You can contact me directly: ralf.becher@tiq-solutions.de

However, there is an ODBC driver for SAP HANA you should try first.

Vizlib Head of R&D
greeshma_k
Creator III
Creator III
Author

Hi Ralf,

Could you tell me how i can get the ODBC driver.

Regards,

Greeshma

rbecher
MVP
MVP

I don't know and this is a Qlik forum, not SAP..

Vizlib Head of R&D
s_uhlig
Partner
Partner

Hi Greeshma,

just try to enter your connection/user/pass by pressing connect and then enter your sql by hand.

Notice: You have to configure your profile to use PreparedStatements (Advanced Settings) which is not mentioned in the video.

Best regards

Sven

tobivogt
Partner
Partner

Hello Greeshma,

you could get the SAP HANA ODBC driver by installing the SAP HANA Client.

With this the HDBODBC driver will be installed and could be used to create an ODBC connection.

There seems to be an effect that you have to logon or accept the credentials each time you reload so you can't use this to reload via tasks.

Can anyone confirm this or is there an workaround?

Thanks in advance for any hint

Regards,

Tobias