Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Trying to get QV to access SAP Hana data using JDBC

Hi

I am trying to get Qlikview (version 12.20 SR6) to access data on our SAP Hana database

I have installed JDBCConnector, and specified the JDBC Driver to the ...SAP\hdbclient\ngdb.jar library

I then open QV and choose "Connect" using the JDBCConnector_x64.dll(64)

For the URL, I type in the following:

jdbc:sap://dbdewddb01.xxx.co.za:30044/?autocommit=false&connector.driverClass=com.sap.db.jdbc.Driver;

(xxx = our domain. Commented out with xxx)

And then enter my Username & pwd.

But when I click on the 'Test' button, I get an error:

"Cannot load the jvm.dll. Please make sure it's properly configured"

Can anyone help ?

Darryn

1 Reply
balabhaskarqlik

May be these are the issues:

Most of the time it's a wrong configuration: 64bit connector needs 64bit Java jvm.dll etc.

Check PATH and CLASS_PATH environment variables are defined correct.

Some times it depends on what version you have installed. Suggestion is to repair your Java installation.

https://community.qlik.com/docs/DOC-2438

https://docs.google.com/document/d/1XMOvGrtvubofbq9_GM5cy0Qax-skc1e4CGis0Lxe_5U/edit