Inbound Integration
For external software applications that desire to communicate with Service Management, an inbound queue, integration table, update
trigger, stored procedure hooks for custom logic, and integration queue form are
provided.
Inbound Integration Flow
- Data should be inserted into the integration_queue table of the application database.
- An insert trigger will fire on the table calling IntegrationQueueFireOneSp
that contains hooks to custom stored procedure [CustomIntegrationQueue
type] intended for the integrator to define business logic for validating
and posting data.
- If the stored procedure is not found or the posting validation fails, an error will be returned and populated on the integration_queue record.
- If no errors occur the record will be parked as posted and the process date assigned.
- For any unsuccessful record, the "Post" or "Post All" buttons can be chosen on the form to re-fire the integration routines.