Trying to get QV to access SAP Hana data using JDB... - Qlik Community

Anonymous · ‎2018-07-04

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

balabhaskarqlik · ‎2018-07-04

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.

Trying to get QV to access SAP Hana data using JDBC