How to integrate and visualize your external data
SquaredUp DS 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.
Data can come from a whole range of data sources:
Web API for data from any REST API
PowerShell to visualize 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:
If you're looking for some real-life examples of dashboards, check out the Dashboard Gallery. You'll find dashboards that users from SquaredUp and the Community have created to help you get the most out of SquaredUp DS:
The Web API tile allows you to pull data from external APIs and display this data using a variety of visualizations.
What kinds of APIs are supported?
The Web API tile works with any REST API that returns JSON.
How do I connect to the API I want to use?
The connection details are not stored in the tile, but in the provider. You need to create a provider before you can use the Web API tile. Adding an API provider is a one-time configuration task to be carried out by a SquaredUp DS administrator.
How do I get data from the API into the tile?
The Web API tile supports
POST requests. For the format of those requests, you need to refer to the API documentation of the service you want to integrate with.
Once a provider has been configured for a particular API provider it can be used in multiple tiles.
Using the PowerShell tile you can transform and visualize data from external tools and data stores and even combine data from several sources.
The SQL tile can show many visualizations using SQL queries.
Native Data Integrations
Query Log Analytics data from Azure Monitor and display the information on your dashboard using a range of visualizations.
Query App Insights and display grid and scalar data in SquaredUp DS.
The SquaredUp DS Elasticsearch integration allows you to easily show data from your Elasticsearch instance.
The ServiceNow tile offers easier configuration than the Web API tile. You can display incidents and change request with the ServiceNow tile. If you want to use any other data from ServiceNow, you need to use the Web API tile.
The Web API tile can display other data in addition to incidents and change requests, it gives you more flexibility and advanced configurations.
Visualize your Splunk queries using the easy to use dedicated Splunk tile.
The Web Content tile enables you to enrich your dashboards with data from other web pages and custom HTML.
With a Web Content tile you can:
Add HTML, for example to add formatted text or links to other websites.
Embed web pages via 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.