Display SQL data in ServiceNow Dashboard.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-15-2024 07:22 AM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-16-2024 08:13 AM - edited 05-16-2024 08:14 AM
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.