Execute a PostgreSQL Database query and display in Portal

[prabhur34]

I have an external database PostgreSQL and I need to fetch the data (select query, say) and display them in Service Portal.

I have the widget created with sample html, but not sure ServiceNow supports external DB queries in Server Script. Any leads or directions for doing this will be appreciated.

[Deepak Ingale1]

You can use JDBC probe

http://www.john-james-andersen.com/blog/service-now/using-the-servicenow-jdbcprobe.html

[Deepak Ingale1]

For READ operation, we can create JDBC type data source.

JDBC type data source

Previous post is valid for UPDATE and INSERT operations