Request for API Integration to Auto-Create ServiceNow Incidents from SQL Server Alerts

Question

Hi Team,

I’m currently managing our MSSQL environment at Tech Mahindra, and I’d like your guidance on integrating ServiceNow with SQL Server using APIs. As of now, we are receiving all alert notifications (job failures, maintenance job issues, etc.) via email through SQL Server Agent. These emails used to trigger to my team and ServiceNow helpdesk team, the ServiceNow help desk team used to created manual incident in ServiceNow.

         Now the incident creation from email notifications has now been deprecated in favor of automation. To align with the new automation policy, I would like to know if we can set up an API-based integration between SQL Server and ServiceNow, so that incidents are automatically created whenever an alert or job failure occurs.  This integration will help us ensure timely and reliable ticket creation and reduce dependency on email-based workflows.

Specifically, I need your help with:

• API endpoint details for creating incidents (e.g., URL, method, and required parameters). Authentication mechanism (Basic Auth, OAuth, or use of a MID server).
• Any existing guidelines or security policies we must follow for API integration.
• Best practices or samples, if available.

Before proceeding, I would like to understand:

• Is API-based integration between SQL Server and ServiceNow safe and secure?
• Is it officially recommended or supported by our internal policies?
• Do we already have any approved methods (e.g., MID server, secured service account) for this kind of integration?
• Are there any risks, limitations, or prerequisites I should be aware of?