Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

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,137 Views
2 REPLIES 2

sachin_namjoshi
Kilo Patron
Kilo 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