Skip to main content

How to integrate data into SquaredUp

Catherine
  • Updated

SquaredUp brings together data from your existing platforms and tools on-demand, creating interactive, single-pane-of-glass dashboards and drilldowns for real-time insights.

SquaredUp Dashboard server is all about data from a whole range of different providers, using SQL databases, iframes or any REST API.

Snag_992ead0.png

There are three main SquaredUp tiles that help you integrate third party applications:

1. Web API tile for RESTful APIs

2. SQL tile for SQL databases

3. Web Content tile for showing sites in an iframe or HTML directly

You might like to watch this 2 minute introduction to Integrations:

Or this longer webinar - "Integrating with Splunk, New Relic, Solarwinds and more" (38 mins) which demos different methods.

1. 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. 

How to add a Web API provider

Once a provider has been configured for a particular API provider, for example Pingdom, it can be used in multiple tiles.

How to use the Web API tile

Some APIs have dedicated tiles in SquaredUp. If there's a dedicated tile we recommend you use the dedicated tile, over the Web API tile, for a quicker and simpler integration:

  • Elasticsearch tile
  • Azure Log Analytics tile
  • Azure App Insights tile (Enterprise edition)
  • Splunk tile (Enterprise edition)
  • ServiceNow tile (Enterprise edition). If you want to display incidents or change requests from ServiceNow, you can use the dedicated ServiceNow tile which is quick and easy to set up. If you want to show any other data from ServiceNow, use the Web API tile.

Along with this general article, we've also written specific articles about how to integrate with some popular APIs using the Web API tile:

Or jump into our webinar for demos integrating these applications:

For other APIs, take a look at our Community Answers site, where there's a wealth of knowledge about APIs:

2. SQL tile

The SQL tile can show grid or scalar results using SQL queries, as seen in the webinar demo of Solar Winds.

For more information see How to use the SQL Tile.

3. Web Content tile

It is often useful to render a website in an iframe, or to render HTML directly, and using the Web Content tile in this way you can very effectively combine web content with data pulled into other tiles on a dashboard.
 

 

 

Related articles