SAP HANA JDBC Connection

Hello,

Yes, I could access HANA with JDBC.

So I installed the HANA Client at my PC
At Ignition created a new translator with this settings



after that, created a new Driver with this settings


the Jar file to import is at the HANA Client install folder usually at C:\Program Files\SAP\hdbclient\ngdbc.jar

After that, I could create a HANA Connection, with a User and Login at SAP, Using Windows authentication for me not worked.

The URL for connection like

jdbc:sap://hanalink.com:30015/?autocommit=false

jdbc:sap://LINK:PORT/?autocommit=false

and connected, also it can loader the folders at query build and is easy to find the correctly view at HANA.

2 Likes