- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-03-2022 03:07 AM
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
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-16-2024 07:05 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2024 07:28 AM
Hi @SUDEL , Were you able to achieve this requirement? If yes then how? Can you provide detailed steps?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-16-2024 07:05 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎10-10-2024 09:55 AM
Only some Servicenow Support Engineers can run SQL on an Instance Database. Use GlideRecord API to query the database.
