# SAP HANA JDBC Connection **URL:** \ **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:** 11\ **Page:** 1
**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:** [September 5, 2019, 6:01pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/1 "2019-09-05T18:01:53Z")
Hello World, Any one could connect to SAP HANA using JDBC at Igniiton? ---
**Author:** ![pphillips](https://avatars.discourse-cdn.com/v4/letter/p/da6949/32.png) [@pphillips](https://forum.inductiveautomation.com/u/pphillips)\ **Post date:** [September 5, 2019, 9:05pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/2 "2019-09-05T21:05:46Z")
I am interested in this as well, since it appears my company is headed in this direction. ---
**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:** [September 13, 2019, 7:02pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/3 "2019-09-13T19:02:16Z")
I could create the Conection with JDBC for HANA, and create a Translator. But I’m facing issue to Pass the login to HANA. Follow the settings: ![2019-09-13%2016_00_27-Window](https://us1.discourse-cdn.com/inductiveautomation/original/2X/8/8cc7f32f5592aa292f60f42dbaa7f29d26c54706.png) ![2019-09-13%2016_00_36-Window](https://us1.discourse-cdn.com/inductiveautomation/original/2X/0/076ea01acdb49726b110abd1011f4bd1d036bb6c.png) ![2019-09-13%2016_00_50-Window](https://us1.discourse-cdn.com/inductiveautomation/original/2X/b/b71fc02f3920f5e7a0d31923815ee312f190ba6f.png) ![2019-09-13%2016_01_01-Window](https://us1.discourse-cdn.com/inductiveautomation/original/2X/1/1891c935592301a1e06a94b4aa7a0cc89795d020.png) ![2019-09-13%2016_01_06-Window](https://us1.discourse-cdn.com/inductiveautomation/original/2X/4/4cdeac20b2289394d064f78de42a8e66aeecaec3.png) ---
**Author:** ![keith.adair](https://avatars.discourse-cdn.com/v4/letter/k/eb8c5e/32.png) [@keith.adair](https://forum.inductiveautomation.com/u/keith.adair)\ **Post date:** [September 13, 2019, 11:47pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/4 "2019-09-13T23:47:21Z")
Hello there! I can’t help you with communicating with SAP HANA via JDBC, but I will tell you that we are releasing next week an Interface for SAP ERP module, that will, in tandem with our Business Connector module, enable you to communicate natively with most on-prem SAP servers, including HANA. More information can be found [here](https://www.sepasoft.com/products/interface-for-sap-erp/) and [here](https://www.sepasoft.com/products/sepasoft-business-connector/), and a demo can be set up with your Ignition rep, if this interests you. Hope this helps! Keith Adair MES Product Manager, Sepasoft ---
**Author:** ![udib](https://avatars.discourse-cdn.com/v4/letter/u/f14d63/32.png) [@udib](https://forum.inductiveautomation.com/u/udib)\ **Post date:** [September 30, 2020, 3:39pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/5 "2020-09-30T15:39:44Z")
Hello AGDC04 Did you finally succeed to communicate with the HANA via JDBC? Thanks ---
**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")
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. ---
**Author:** ![udib](https://avatars.discourse-cdn.com/v4/letter/u/f14d63/32.png) [@udib](https://forum.inductiveautomation.com/u/udib)\ **Post date:** [October 13, 2020, 9:02pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/7 "2020-10-13T21:02:21Z")
It’s working Thank you for the detailed explanation ---
**Author:** ![zacharyw.larson](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/zacharyw.larson/32/23749_2.png) [@zacharyw.larson](https://forum.inductiveautomation.com/u/zacharyw.larson)\ **Post date:** [June 20, 2023, 3:51pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/8 "2023-06-20T15:51:41Z")
I have been trying to learn the best ways to connect SAP and Ignition. @AGDC04 Is this the technique you use today? Did you learn a better one? ---
**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:** [November 25, 2024, 11:07am UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/9 "2024-11-25T11:07:34Z")
You can use the SAP Module to connect, if want to read/write, here we are creating API links from SAP to write data and read using HANA, but we will replace HANA with another replication DB just for read. ---
**Author:** ![Jesus\_Rodolfo\_De\_San](https://avatars.discourse-cdn.com/v4/letter/j/8e7dd6/32.png) [@Jesus\_Rodolfo\_De\_San](https://forum.inductiveautomation.com/u/Jesus_Rodolfo_De_San)\ **Post date:** [February 26, 2025, 11:52pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/10 "2025-02-26T23:52:36Z")
With this method you showed, Am I able to write to a table at SAP HANA? ---
**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:** [February 27, 2025, 12:06pm UTC](https://forum.inductiveautomation.com/t/sap-hana-jdbc-connection/28048/11 "2025-02-27T12:06:07Z")
If your HANA allow to CREATE / UPDATE yes, should be ok