Easily unlock the data from your Database.
Do you have data locked in a database in your data center? Maybe you have multiple monitoring applications that contain data, but you don’t want to provide access to the GUI? SquaredUp’s SQL integration tile enables you to quickly and easily pull data from any SQL Server.
Here’s an example dashboard that uses the same basic query but converts the results into a variety of visualizations.
Here’s a peek at the query behind the visualization.
As you can see, it’s not just simple SQL code. We’ve declared a dynamic table and are inserting results from a common table expression. Whatever you need to get the job done.
Once you have the data visualized just right, use SquaredUp’s Open Access feature to share it.
Select the SQL tile.
Choose how you want to visualize your SQL data – a single value (scalar), a grid of data, a line graph, sparklines, bar, donut, or status blocks.
Enter your connection string
Supply your query. Your query can be as straightforward (or complicated) as it needs to be to get the job done.
(Optionally) Add some finishing touches like showing or hiding columns, making the rows clickable, adding a legend or labels to get the point across.
Find out more about working with the SQL integration in the following blog posts:
Add context to your dashboards from SQL data sources
Dashboard Server: Working with the SQL tile
Reduce monitoring silos with SquaredUp Web API and SQL tiles
If you want to dig a little deeper, check out these Knowledge Base articles:
How to configure access to a database for use with the SQL tile
How to use the SQL tile
Troubleshooting the SQL tile
Start now with hundreds of customizable dashboards.