pull the data from Service Now to 'MS SQL Server', Just one way directional integration.

[Raviteja3]

Team,

Service Now Version :Kingston

Requirement : pull the data from Service Now to 'MS SQL Server', Just one way directional integration.

Question 1 : As we have 'Mid Server' in place, Is there any way we can use JDBC & Mid Server to pull the data from SErvice Now Instance into MS SQL Server?

Question 2 : How secure to use ODBC Drivers to pull the data from SNOW to MS Sql Server?

Question 3 : Are there any other approaches apart from ODBC driver?

Thank you in advance
Ravi

[simonbergstedt]

We are doing similar things but then we are pulling data using the SN Webservices through Powershell or curl/python/or whatever you use with linux and push the data into MSSQL or MYSQL. We also have jobs using Biztalk, but that might be a bit overkill 🙂

[Raviteja3]

Thanks for the response but if we use the webservices, we need to expose more no of API's for respective tables. 

[simonbergstedt]

Ah yes depending on what data you want or dont want to expose ofc. A scripted API could do it ofc. and there is always the possibility to push data as well, that is another way that we are doing it. That way you can control that data you expose, and get it from multiple tables as well. Then you would need something that take that data and put it into the database ofc. Or I guess you could export a csv-file that you can import into the MSSQL-database as well.

[harshi2]

Hello Simon, 

did you guys achieve this ??

my requirement is to send the data from ServiceNow to SQL Database ? is this possible ??

if yes can i know how to achieve this ?

Thank you