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

[vermaamit16]

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

[vermaamit16]

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.

[vermaamit16]

Hi @Txilos 

Yes. You can use the existing mid server. Refer below posts :

https://www.servicenow.com/community/developer-forum/jdbc-probe-to-insert-update-records-into-sql-da...

https://www.servicenow.com/community/developer-articles/exporting-to-mysql-oracle-or-sql-server-with...

https://www.servicenow.com/community/developer-forum/pull-the-data-from-service-now-to-ms-sql-server...

Alternatively, you can always make use of PowerShell or Python to send data from your ServiceNow instance to the DB server. The data could be queried on the ServiceNow instance and could be passed to an insert query which could be triggered via a Mid Server Script file to upload the records on the database.

Thanks & Regards

Amit Verma