Could somebody please point me to ServiceNow JDBC driver?

[nilesh9]

Hi Guys,

Could somebody please point me to service now jdbc driver. I am working on developing an application in java that needs to extract data from Service Now.

I looked at the unityjdbc driver for service now. However, it comes will lot of other drivers that I do not really need.

Thanks for your help in advance.

Regards,

N

[Mike Allen]

I know there is an ODBC driver, but I don't think there is a JDBC driver.

[coryseering]

Hi Nilesh,

ServiceNow does not allow direct DB connections via JDBC. What we do allow are connections over HTTPS through our SOAP web services, and provide an ODBC driver for it:

https://wiki.servicenow.com/index.php?title=ODBC_Driver

However, there is no supported JDBC-ODBC bridge. That doesn't mean that a configuration for such isn't possible, only that we don't know of a working one and cannot provide support for troubleshooting / fixing issues if you set one up.

The SOAP or REST interfaces are the supported methods for retrieving data from ServiceNow.

Thanks,

Cory

[nilesh9]

Hi Cory Seering,

Thanks for your reply. I came across this JDBC driver from UNITYJDBC that claims to work fine with ServiceNow. This is a JDBC interface and behind the scenes uses SOAP web services. I have tested this and it seems to work.

Is this something officially recognized by ServiceNow?

http://www.unityjdbc.com/servicenow/servicenow_jdbc.php

Regards,

Nilesh

[coryseering]

Hi Nilesh,

That is not a driver offered by ServiceNow, and is not supported by ServiceNow. Again, that means that ServiceNow does not troubleshoot problems with it, and does not offer Support services for it. If it works- great. Be aware that it could break if the API's it depends on change- especially if it's using deprecated or undocumented APIs, or exploiting a communication method that is later deemed a security issue and closed.