What all possible ways to push data from ServiceNow to SQL Server

[Pragati4]

Hi There,

Can someone suggest what all possible ways are there to push data from ServiceNow to SQL Server?

Regards,

Pragati

[Pragati4]

Thank you Sumanta & Rajdeep for your quick response! 

Here I won't be getting the endpoint, I have just the server details, table name and user ID/Password. 

Any detailed link or doc would be helpful through which I can achieve this. 

Regards,

Pragati

[Amit Verma]

Hi @Pragati4 

Can you please elaborate on your requirement so that we could assist you further ? If you have just the server details, username and Password, you could think of PowerShell scripts.

Thanks & Regards

Amit Verma

[Pragati4]

Hi Amit,

Here we need to push the data every 5 min from the ServiceNow table to the SQL server table.

We have the server details, table info & user id/Password.

Regards,

Pragati

[Amit Verma]

Hi @Pragati4 

A simple and elegant solution to this would be a flow in Flow Designer that could be set to trigger after every 5 minutes. Inside the flow, you can make use of PowerShell script to make the push via Mid Server to your database.

You can also explore JDBC Step https://docs.servicenow.com/bundle/vancouver-build-workflows/page/administer/flow-designer/reference... which could be used again with a flow.

Thanks & Regards

Amit Verma

[Txilos]

Hi, we are testing the same functionality on our sub-production. We have imported data from the SQL server to our ServiceNow instance using a data source with  JDBC & MID server.

But its not clear how the other-way around (sending records from ServiceNow to the SQL Database) can be achieved.

Can this be done with the MID Server already installed?

Regards

Theo.