How to insert rows from ServiceNow into a 3rd Party MS SQL Server database using JDBC and MID Server?

[Shishir Pandey]

I need to insert/update data from ServiceNow into a table within 3rd Party MS SQL Server Database using JDBC and MID Server. I am not sure where to start? There is a Service Account which has the required privileges on the SQL Server Database to insert and update records and the MID server is used to query the records as well however I need to send the records back once updated and I am not sure where and how to put that configuration/script. I have read other articles/responses with similar intent but a little lost where to start.

[Niamul Arifin]

You can do this couple of ways.

1. Orchestration workflows and use powershell capability to send the data to MSSQLserver.You also need to configure powershell capability in your midserver.

2. Integrationhub to do CRUD operation using PowerShell action to send the payload to MSSQL server.

MID Server is the middleware which sits in the customer Network and communicates to your ServiceNow instance and the MSSQL Server that in your customer environment. 

You have to use that service account information to authenticate to your MSSQL server and the database name. The service account and the database should have privilege so that it can authenticate. 

Hope this helps. Please mark it complete so that future readers does get benefited from this.