Suggestions Needed for ServiceNow to Oracle Integration

[Lisa Goldman]

Hello,

I have a project in which we are developing a service request application for travel reimbursement. Once a user submits a travel expense report, the data needs to be inserted into Oracle database tables.

We would like your suggestions on the best approach to handle this integration. Could you please share your recommendations and any best practices for implementing this solution?

Thank you

[Tanushree Maiti]

Hi @Lisa Goldman 

Refer this community post : https://www.servicenow.com/community/community-central-forum/how-to-do-integrate-oracle-database-wit...

Probable steps as mentioned there: 

1. Create JDBC Connection & Credential Alias for the Oracle database using a mid server.

2. Build a flow that triggers on the catalog request or after any approvals

3. Lookup the catalog variables and grab the user id and any other information you need.

4. Use the JDBC step in flow designer to call a stored procedure or execute an SQL statement to revoke access. You will need an integration hub subscription for this step.

5. If successful, add validation to confirm the users access was revoked.

6. If failure, create a task to a specific team for investigation or manual adjustment.

7. Update ritm based on outcome.