How to Establish a Remote Table in ServiceNow with PostgreSQL as the Data Source?

[JaimeG]

I want to set up a Remote Table in ServiceNow with a PostgreSQL database as the source. My goal is to dynamically retrieve data from PostgreSQL without storing it in ServiceNow.

• Is it possible to connect a remote table to PostgreSQL database?
• How frequently does ServiceNow fetch data from the PostgreSQL source?
• Are there any performance considerations or best practices for optimizing queries?

Any guidance, step-by-step instructions, or examples would be greatly appreciated. Thanks!

[Vishal Jaswal · Accepted solution]

Hello @JaimeG 

Not possible - ServiceNow is table (backend) and form (frontend) based platform. When you make a JDBC connection with any database, ServiceNow will import the data accordingly and save it in a staging table and then with the help of transform map, you can move this data into actual table.