Copy data from servicenow table to local sql server using SSIS

[Manikandan Subr]

Hello Team,

The main goal that I have is to automate reporting. I just have to extract data from Service now database and import it to my local SQL Server and do all calculations and extract reporting from there. DO Let me know if there is a better approach than I have mentioned below.

I am trying to set up an ODBC connection and connect to the Service Now database as linked server from my local server.

Once I do this, I want to schedule jobs using SSIS package.

This is done specifically only for reporting purpose. I do not want to alter or change any data. The access I need is also a read only access.

Will this work or is it an issue? would you have any

Please share if you have any documentation for this automation process.

[Subhajit1]

I am not sure about SSIS package, but you can do a REST query on the tables from which you need Information from and download the information onto your instance. The result set would be in XML, so i assume that the system would not have any issues to read the data.

[jerod_cdatasoft]

If you can tolerate a paid solution, my employer (CData Software) has SSIS Source and Destination components that greatly simplify the process of integrating ServiceNow and SQL Server. You can read more about the components here: ServiceNow SSIS Components and download a free Beta of the components here: ServiceNow Drivers - Download