SquaredUp brings together data from your existing platforms and tools on-demand, creating interactive, consistent dashboards and drilldowns for real-time insights and better decision making.
SquaredUp Dashboard Server is all about data from a whole range of data sources:
- Web API for data from any REST API
- PowerShell to visualise and combine data from virtually any source
- SQL for data from SQL databases
This is made easy using native data integrations in the form of dedicated tiles for popular providers:
Dashboards can be further enriched by embedding web page content, custom HTML and images:
Web API tile
The Web API tile can utilise any API which returns JSON. In particular, REST (Representational State Transfer) APIs, which are a type of stateless web API, are ideal. The tile can connect to services using various authorization methods (more details below).
Your first port of call is the API documentation on the providers website for the service you wish to integrate with. Firstly, you should search for information about the API you want to use (for example, Google rest api docs or oauth2), and then read the API provider's documentation looking for the information you need to use in SquaredUp. Queries are written using the syntax of the remote system you're connecting to, so these will vary between vendors.
Before you use the Web API tile with an API you may need to add that API as a provider in SquaredUp. Adding an API provider is a one-time configuration task to be carried out by a SquaredUp administrator.
Once a provider has been configured for a particular API provider it can be used in multiple tiles.
2 minute introduction about how to visualise APIs using the Web API tile:
Using the PowerShell tile you can transform and visualise data from external tools and data stores and even combine data from several sources.
2 minute introduction about how to visualise using a PowerShell script:
The SQL tile can show many visualisations using SQL queries.
For more information see How to use the SQL Tile
Native Data Integrations
Azure Log Analytics
Query Log Analytics data from Azure Monitor and display the information on your dashboard using a range of visualisations.
Azure App Insights
Query App Insights and display grid and scalar data in SquaredUp.
The SquaredUp Elasticsearch integration allows you to easily show data from your Elasticsearch instance.
The ServiceNow integration allows you to quickly and easily show incidents and change requests in SquaredUp.
Visualise your Splunk queries using the easy to use dedicated Splunk tile.
Web Content tile
- HTML can be used to add text, for example a title, or hyperlinks, so example a link to another website.
- Webpages can be embedded in your dashboard, as an iframe, for example to show web content from another site alongside the data in other tiles on the dashboard.
The Image tile allows you to add any image to your dashboard.