Collect data en show it in a graph

Question

Collect data en show it in a graph

piet.kouwer

Old Hand

Points: 354
More actions
November 2, 2017 at 1:00 am

#409743

Hi all,
I'm not sure this is the right place for my question, but I'll give it a try:
Ik looking for a (free) tool to collect data from a SQL-query ( or stored procedure) and show it in a graph: real time ( or a small delay). Since I don't want it to be complex to install and configure, SSRS is not an option. I like it to be Windows desktop software...
Example:
L let's say we store a temperature or pressure from an other device into a SQL Server database/table and want it to show it in a graph.
Does anyone know such tools??
Kind regards,
Piet Kouwer

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Thom A SSC Guru Points: 99133 More actions · Answer 1

Depends how you want to display it, your requirements are quite vague. For example, you could use Excel. Run the script in SSMS, copy and paste the data out into Excel and then create a graph. If you want to automate it a bit, build a Macro to return the data, and have a graph already on the sheet that uses that said data.

Where and how are you looking to display this information? What do you have against SSRS?

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

piet.kouwer Old Hand Points: 354 More actions · Answer 2

Ow, I really love SSRS, believe me, but I want to use this tool for ad-hoc monitoring without the need for installing SSRS etc.

I'd like to view the data on a seperate machine and it isn't always a SQL Server. It's al about process data, like values, counts etc, not performance counters....

Thom A SSC Guru Points: 99133 More actions · Answer 3

You could have a look at PowerBI, but, personally, I think SSRS would be a good choice here. if it's on a separate machine, you only need a web browser (not Chrome as you're using SQL 2012) to view the report, not a separate client.

Thom~

Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk

Paulo de Jesus Default port Points: 1403 More actions · Answer 4

I'd recommend PowerBI as well, as it is very affordable.
If you're familiar with SSRS already, then working with PowerBI will be a walk in the park.
There are tons of tutorials on the website as well:
https://powerbi.microsoft.com/en-us/
Download and install the PowerBI Desktop app

xsevensinzx One Orange Chip Points: 25560 More actions · Answer 5

Python + Django or Flask + Google Graphs or Highcharts.

Highcharts Realtime Spline Chart

If it was me, I would use Flask because the amount of knowledge and code to get a one-page site up or expand beyond that is minimal.

In the code from this chart, you can likely keep everything the same, just replace that Math.random() function with the actual temp or pressure value from that table. That way the script pulses on the time, but the value is dynamic based on what the temp/pressure value is at that current time. The trick is how do you get that Y = variable populated with the metric from SQL Server. Should be a fun project. 🙂

JSFiddle Example

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 6

You could just setup and Excel spreadsheet to hit a stored proc and do automatic refreshes to update a chart in Excel.

The question is, what kind of data are you actually monitoring for?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)