SAP HANA JDBC Connection

Ignition
1

Hello World,

Any one could connect to SAP HANA using JDBC at Igniiton?

2

I am interested in this as well, since it appears my company is headed in this direction.

3

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
2019-09-13%2016_00_27-Window1182×855 29 KB
2019-09-13%2016_00_36-Window
2019-09-13%2016_00_36-Window1172×420 7.72 KB
2019-09-13%2016_00_50-Window
2019-09-13%2016_00_50-Window1180×831 41 KB
2019-09-13%2016_01_01-Window
2019-09-13%2016_01_01-Window1186×670 37.9 KB
2019-09-13%2016_01_06-Window
2019-09-13%2016_01_06-Window1198×720 10.1 KB

4

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 and here, and a demo can be set up with your Ignition rep, if this interests you.

Hope this helps!

Keith Adair
MES Product Manager, Sepasoft

1 Like
5

Hello AGDC04
Did you finally succeed to communicate with the HANA via JDBC?

Thanks

6

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
image1168×829 39 KB

image
image1189×871 31.8 KB

image
image1156×264 3.53 KB

after that, created a new Driver with this settings

image
image1229×684 25 KB

image
image1179×523 8.45 KB

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
7

It’s working
Thank you for the detailed explanation

8

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?

9

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.

10

With this method you showed, Am I able to write to a table at SAP HANA?

11

If your HANA allow to CREATE / UPDATE yes, should be ok