ServiceNow JDBC Driver

[anil_kudidi]

Hello Dev folks , Happy Friday ! we want to check in if anybody has done SN integration using JDBC driver recently and any known pros/cons using , Appreciate the feedback , Thanks!

Also any documentation regarding the Authentication being supported in current versions.

[Viraj Hudlikar]

Hello @anil_kudidi 

Pros:
JDBC allows direct access to the database, which can be useful for large data imports or export.

It supports various databases like MySQL, SQL Server, and Oracle, providing flexibility in integration

For batch processing and scheduled data transfers, JDBC can be more efficient compared to REST or SOAP APIs.

Cons:

Setting up JDBC connections can be more complex compared to REST or SOAP integrations.

Managing database credentials and ensuring secure connections can be challenging.

Docs link - https://www.servicenow.com/docs/csh?topicname=create-JDBC-connection.html&version=latest

If my response has helped you hit helpful button and if your concern is solved do mark my response as correct.

Thanks & Regards
Viraj Hudlikar.