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

[Rajat15]

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?

[sachin_namjoshi]

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

[sagarg]

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