SQL provider

What are Integrations?

SquaredUp DS Integrations allow you to create your own providers. Each Integration has its own form to help you input the information required for different providers.

What is a provider?

Providers contain the connection details to external platforms. A provider only needs to be set up once and can then be used when creating tiles on a dashboard.

There are two types of integrations and therefore providers:

  • generic Web API providers that can connect to any REST API
  • dedicated providers that connect to a specific external platform or database (SQL, ServiceNow, Azure Active App Insights, Elasticsearch, etc.)

About SQL providers

An SQL provider contains the connection string to the SQL database you want to connect to. You can use Microsoft SQL Server or ODBC drivers for your connection.

Since SquaredUp DS version 5.4 you need an SQL provider to use the SQL tile. Your Data Warehouse is available as a provider by default but if you want to use any other connection you'll need to create a provider.

If you created SQL tiles before SquaredUp DS version 5.4, they were created with a connection string in the tile instead of a provider.
As soon as you update to v5.4 those connection strings will automatically be converted into providers. If identical connection strings are detected, they'll be merged into one provider.
The new SQL providers will be named in the following format: servername.databasename (if server and database name can't be identified they'll be named SQL provider 1, SQL provider 2, etc.)

Adding an SQL provider

  1. Make sure you have access to the database you want to use.
  2. Provider name:
    Enter a name for your provider that makes it easy for you to identify. You can't change the name after you created the provider.
  3. Driver and Connection String:
    The connection string depends on your database and the driver you've chosen:
  4. Click save to save your new provider.

To use the SQL provider in a tile see How to use the SQL tile

Was this article helpful?


Have more questions or facing an issue?