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]

Yes. Depending on what you want to do, but to simple pull data from MSSQL, MYSQL, any database that you can access through JDBC on a regular basis all you need to do is to set up a data source with a transform map as well as a scheduled import that you can run how ofter you want it

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/concept...

https://docs.servicenow.com/bundle/tokyo-platform-administration/page/administer/import-sets/task/t_...