Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

How to fetch the Data from Oracle Database in to servicenow Table using REST/SOAP

Rajat15
Tera Contributor

‎02-22-2022 10:13 AM

We have the requirement to fetch the Oracle Database data into ServiceNow using SOAP/REST. Does anyone have tried this before. What are the steps?

0 Helpfuls
  • 3,915 Views
2 REPLIES 2

sachin_namjoshi
Mega Patron

‎02-22-2022 10:23 AM

If you want to fetch data from Oracle Database, you should configure  JDBC data source.

 

https://docs.servicenow.com/bundle/sandiego-platform-administration/page/administer/import-sets/reference/r_JDBCTypeDataSource.html?cshalt=yes

 

If app which is hosted on this oracle instance provides REST/SOAP API, you can always consume this API in servicenow instance.

Also, oracle has a ServiceNow adapter which you can look into

 

https://docs.oracle.com/en/cloud/paas/integration-cloud/servicenow-adapter/using-servicenow-adapter-oracle-integration.pdf

 

Regards,

Sachin

0 Helpfuls

sagarg
Kilo Contributor
In response to sachin_namjoshi

‎01-25-2023 06:41 AM

we wanted to automate oracle database activities just to start with DB restart, DB creation, will that be possible with Oracle ServiceNow adapter ? have you ever tried or come across such requirement?

happy to know if anyone has any idea.

Regards

Sagar

0 Helpfuls