REST / SOAP Integration between SQL Server and ServiceNow

[Rutvik]

Hello Community,

We have a requirement where we have to integrate between SQL Server and ServiceNow with SOAP / REST. We do not want to use the approach of Data Source / JDBC Connection as we want to preserve the Sys ID value stored in the Data Repository. Can you please suggest an approach with which this Data Repository / SQL Server can be used to fetch the data from this Data Repository.

Appreciating your time for reading.

Thank you.

Regards, 

Rutvik.

[-Andrew-]

Hi,

There are a few ways to integrate ServiceNow with a SQL Server database using SOAP or REST, without using the Data Source or JDBC Connection approach. Here are a few options you can consider:

• Scripted REST API: You can create a Scripted REST API in ServiceNow that calls the SQL Server database and retrieves the data. This approach allows you to preserve the Sys ID value stored in the Data Repository, as it can be included as a parameter in the REST API call.
• Scripted SOAP Web Service: You can create a Scripted SOAP Web Service in ServiceNow that calls the SQL Server database and retrieves the data. Like the REST API, this approach allows you to preserve the Sys ID value stored in the Data Repository, as it can be included as a parameter in the SOAP Web Service call.
• MID Server: You can use a MID Server to connect to the SQL Server database and retrieve the data. The MID Server can then send the data back to ServiceNow via a REST or SOAP Web Service. This approach allows you to preserve the Sys ID value stored in the Data Repository, as it can be included as a parameter in the REST or SOAP Web Service call.
• ServiceNow Data Importer : You can use ServiceNow data Importer to import data from SQL Server to ServiceNow. You can use this approach to import your entire data repository to ServiceNow.

Please note that these are general suggestions and the best approach depends on your specific use case, data structure, and the requirements of the integration

[Rutvik]

Hello @-Andrew- ,

Thank you very much for your response and time. We will surely check these approaches.

Thank you.

Regards, 

Rutvik.