Connecting START to Oracle

Owned by Former user (Deleted)
Last updated: Jun 06, 2013Version comment
2 min read

Attendance

Name

Role

Present

Christine Costantino

START PM

(tick)

Barbara Manville

START SME / BA

(tick)

David Logie

START BA

(tick)

David Backeberg

START Tech Lead

(tick)

Bill West

ServiceNow Test Lead

(tick)

Jeff Campbell

EMC Manager

(tick)

Kazi Ahmed

Web Methods Developer

(tick)

Shane Anderson

Solution Architect / Oracle SME

(tick)

Liz Burnell

IAM Director

(error)

Josh Nabozny

IAM Director

(error)

Jay Johnson

IAM Change Manager

(error)

Agenda

  1. Review the process for Travel Policy Approvers documented by Barbara
  2. Review three options for connecting SN to Oracle proposed
  3. Make decision on which option is best

Documents

Discussion

* Barbara led the discussion, Christine took notes

Introduction:

  • Barbara has done analysis for Orbitz Travel Policy Approver - moving request to ServiceNow, people list in Oracle (database), provisioning in Orbitz (currently biweekly process)
  • How to go to SN to Oracle, a few different options Web methods, etc.?
  • All access requests in START now, later more requests - individual, dept, org - people can have multiple access for different groups in the Travel Policy Approver request.

Options:

  • Option 1: Synchronous - Approval process, then Web service to update the People list in Oracle, biweekly process kicks in.
  • Option 2: Pub/Sub - ECC table (or other table) in SN, web service to monitor and get specifics of request and update the people list and then flag as complete - Polling - BEST OPTION
  • Option 3: Async - Runbook Orchestration (workflow) with drop entry into, Web service to look at AD group and updates people list (LDAP sync process runs this way for assignment groups) - NOT AN OPTION

Concerns:

  • Problem - Delete process - request to remove access, presents list of all combinations - how to query the people list to display in SN?
  • Need service to query data and return request
  • Cases: multiple deletes? two separate requests for one person by two different people. Currently, START prevents this. ServiceNow CAN do checks for duplicate requests, can query tables
  • Runbook is not licensed, security problems, don't have the module now for this reason; prefer to use Web Methods external to ServiceNow
  • Flag in HOP1 to say this is complete - loop or wait-for event needed
  • Two-way communication to update SN request status, or Orbitz communicates back?

Action Items:

  • Find out from IAM - delivery time for API and nature of it??? SOAP? mid-servers? - Christine
  • Write solution design based on Barb's use cases - David & Kazi