Connect ServiceNow to SAP HANA by JDBC using Mid Server

davidnavelgas
Tera Contributor

‎07-09-2024 04:01 AM

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.

Preview file
613 KB
0 Helpfuls
  • 584 Views
2 REPLIES 2

Adrian49
Tera Contributor

‎07-09-2024 04:28 AM

Hello David,

 

Im having the same problem as you.

Please share it if you find a solution. 

 

Best regards.

0 Helpfuls

Anton42
Tera Expert

‎11-25-2024 06:56 AM - edited ‎11-25-2024 06:56 AM

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

0 Helpfuls