Run SQL queries (Oracle Database) from servicenow

SUDEL · ‎03-03-2022

Hello,

I have a requirement to run few SQL commands on Oracle database through ServiceNow UI, would like to know what are the different ways we can achieve this through ServiceNow.

Servicenow - Midserver - Database

Thanks and Regards,

Sudipth

SUDEL · ‎10-16-2024

Hi Mansi,

Yes i was able to integrate using IntegrationHub, there is a action that runs SQL commands you have to add that to the flow, also Application registry and related connectivity configurations needs to be placed before. Oracle Connection and credentials needs to be setup. You'll find the example in the OOB settings itself. This connection is used in the SQL action.

View solution in original post

Kieran Anson · ‎03-03-2022

What will the commands be doing? Are you expecting to have the output returned? Is it returning data that needs to be loaded into the system.

Yes you can run SQL commands, but there is usually a bigger picture on what/why that's being done

SUDEL · ‎03-03-2022

Hi Kieran,

Running the commands for adding/removing data from a specific table based on the request(Simple removal codes even have the sql queries), we're automating few manuals code run on oracle database with catalog submission.

Kieran Anson · ‎03-07-2022

IntegrationHub will be the simplest method if you're licensed for it, it'll also allow you to easily retrieve any output.

Alternatively, you can leverage the ECC queue and send custom commands, but this involves building technical debt which isn't viable.

SS6 · ‎04-26-2023

How can i run PL SQL from ServiceNow to perform some operations in Oracle EBS.