Display SQL data in ServiceNow Dashboard.

Jeffrey Siegel
Mega Sage

I have a requirement to gather data from a SQL server. and create a report based on it, and show on a dashboard.  We do not want to STORE the data from SQL, but instead make an on the fly call to SQL to get the data to display in a report.  does anyone know if this is possible without 3rd party integrations?

1 REPLY 1

SteveMacWWT
Kilo Sage

To the best of my knowledge, what you're looking for is not possible. To show something on the report, it needs to be stored somewhere. And to be honest, ServiceNow is not meant to do that so the requirement should be pushed back on. 

 

On the other hand, I could see SN making a call to SQL Server and generating a formatted file that could be emailed.