question Connect ServiceNow to SAP HANA by JDBC using Mid Server in Community Central forum

Connect ServiceNow to SAP HANA by JDBC using Mid Server

davidnavelgas — Tue, 09 Jul 2024 11:01:15 GMT

Hi all,

We try to connect ServiceNow to HANA database through JDBC using Mid Server but when we execute the "Test Load 20 Records" of the data source we always received the same error after 300 seconds.

In the ECC Queue we have this error: Did not get a response from the MID server
- If check the xml with the details of error it said that: Cannot invoke com.service_now.mid.connections.jdbc.JDBCConnection.kill() because this.fJDBCConnection is null.

We read a lot about we need a dedicated Mid Server not cluster but it's a dedicated mid server. Can someone help us? Is it another alternative way to get data from HANA database?

Thanks in advance.

Cheers.

Re: Connect ServiceNow to SAP HANA by JDBC using Mid Server

Adrian49 — Tue, 09 Jul 2024 11:28:16 GMT

Hello David,

Im having the same problem as you.

Please share it if you find a solution.

Best regards.

Re: Connect ServiceNow to SAP HANA by JDBC using Mid Server

Anton42 — Mon, 25 Nov 2024 14:56:51 GMT

Hello. You must use a dedicated driver for that: Maven Repository: com.sap.cloud.db.jdbc » ngdbc
Here it is described how you do it: How Connect ServiceNow to SAP HANA DB via JDBC. - ServiceNow Community