How do dump the data from servicenow DB to SQLServer ?

[john_thomas]

How do dump the data from service-now DB to SQLServer ?

[Josh Cooper]

There's also, or else used to be, an ODBC Connector available.   It used to have a really good writeup on the wiki, but not sure where it's landed since.

[Andy26]

Hi Josh,

I am having the same requirement to take the DB back from service-now to local DB,kindly guide us how can we use ODBC connector to take entire dump in local db.

[JahanzebB]

Here is information on how to install the ODBC Driver. You will then need to determine which data you will query from your ServiceNow instance. https://docs.servicenow.com/bundle/london-application-development/page/integrate/odbc-driver/concept/c_ODBCDriver.html

[Andy26]

Hi Jahanzeb,

We have setup the odbc driver and able to connect the instance successfully, however I am still not able to figure out how to setup a job in odbc so that it can retrieve the data? need your guidance