# SAP HANA JDBC Connection

**URL:** <https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048>\
**Category:** Ignition\
**Created:** [September 5, 2019, 6:01pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048 "2019-09-05T18:01:53Z")\
**Posts on this page:** 1\
**Showing post:** 6

<div class="post-metadata">

**Author:** ![AGDC04](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/agdc04/32/6366_2.png) [@AGDC04](https://forum.inductiveautomation.com/u/AGDC04)\
**Post date:** [October 13, 2020, 6:03pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/6 "2020-10-13T18:03:06Z")

</div>

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

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/8/6/8644323eba70289d006668e1e26e5c6b187077ec.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/0/f/0fa17b57d37e15122f1e1ea7ee126baea43c02ff.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/3/4/34765a5eb4f4948d5d3093d1c479edf8b6b6fe7e.png)

after that, created a new Driver with this settings

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/7/7/7760a9ac1cdd61cad116b34c355ffeb97def96b8.png)  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/9/8/985e5249d8f493e27e3fc647595c1c831a2e43f5.png)

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.

---

_[View the full topic](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048)._
