sql tile integrations
Integrations

SQL integration

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.

Sample SQL Dashboard

Here’s an example dashboard that uses the same basic query but converts the results into a variety of visualizations.

SquaredUp integrations - sql example

Here’s a peek at the query behind the visualization.

SquaredUp integrations - sql query example

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.

Share the insights across the team

Once you have the data visualized just right, use SquaredUp’s Open Access feature to share it.

How to visualize SQL data in five easy steps

STEP ONE

Select the SQL tile.

SquaredUp integrations - sql select an integration
STEP TWO

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.

SquaredUp integrations - sql visual section
STEP THREE

Enter your connection string

SquaredUp integrations - sql connection string
STEP FOUR

Supply your query. Your query can be as straightforward (or complicated) as it needs to be to get the job done.

SquaredUp integrations - sql query string
STEP FIVE

(Optionally) Add some finishing touches like showing or hiding columns, making the rows clickable, adding a legend or labels to get the point across.

Available across our suite of products

For the dashboard hero who needs to provide answers across the business.

For cloud teams who need to take control of Azure cost and performance.

For monitoring teams who need to unlock insights from Microsoft SCOM.

Want to learn more?

Find out more about working with the SQL integration in the following blog posts:

Add context to your dashboards from SQL data sources
https://squaredup.com/blog/add-context-to-your-dashboards-from-sql-data-sources/

Dashboard Server: Working with the SQL tile
https://squaredup.com/blog/dashboard-server-working-with-the-sql-tile/

Reduce monitoring silos with SquaredUp Web API and SQL tiles
https://squaredup.com/blog/reduce-monitoring-silos-with-squaredup-webapi-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
https://support.squaredup.com/hc/en-us/articles/360019291097-How-to-configure-access-to-a-database-for-use-with-the-SQL-tile

How to use the SQL tile
https://support.squaredup.com/hc/en-us/articles/360019292177-How-to-use-the-SQL-tile

Troubleshooting the SQL tile

https://support.squaredup.com/hc/en-us/articles/360019292337-Troubleshooting-the-SQL-tile

GET STARTED TODAY

Zero to dashboard hero in 60 seconds

Start now with hundreds of customizable dashboards.

Fully featured trial. 30 days free. No credit card required.