How can we pull SQL server data in ServiceNow by firing SQL queries from ServiceNow ?

[pawan k singh]

Dear Friends,

We have a requirement where we want to have data from SQL server by running queries from Servicenow to SQL server. What is the best possible way to do that? 

I have gone through the ODBC driver installation link, but it seem we can only pull the ServiceNow Data to SQL server by implementing that, vice versa seems not possible.

Thanks for your input in advance!

Regards

Pawan K Singh

[Vivektietsood]

just so that I understand the requirement clearly you want to fire queries from ServiceNow to a SQL server and not bring SQL server data into ServiceNow, that is you want to use SQL server as another data source to SNOW ?

If that's the case I don't think it is possible, there are far too many business rules, scripts that make tight coupling of SN UI and DB possible, plugging in another database would not be possible.

You can consider importing data from SQL server to SN or use REST API to query specific parameters.

Please mark helpful or accept solution so that it helps others with a similar question.

[pawan k singh]

Thanks for your response Vivek!

Yes, we need to have SQL as another data source for Servicenow. So that we can pull data from SQL to ServiceNow instance. 

Using ODBC driver, we can pull data from ServiceNow to SQL but there seem to be no way to achieve this.

Regards

Pawan K Singh

[Maik Skoddow]

Pulling SQL-based data to ServiceNow is quite easy but you will need a MID server installed near the SQL server you want to request.

For a concrete solution proposal, however, more detailed information are still missing.

[pawan k singh]

Sure, Actually we need to pull the Manager's direct reportee's datafrom SQL, we have manager's information in Servicenow but direct reportee's list is available only in SQL server database, that lies outside the Servicenow instance.

This is the reason for ask of pulling data of SQL to Servicenow.

Regards

Pawan K Singh