LogoDark mode logo
LogoDark mode logo
Contact SupportLoading Light/Dark Toggle

    • Azure Application Insights provider
    • Azure Log Analytics provider
    • Elasticsearch provider
    • Google API provider
    • Microsoft Entra ID provider
    • PagerDuty provider
    • Pingdom provider
    • Prometheus provider
    • ServiceNow provider
    • SolarWinds provider
    • Splunk provider
      • How to configure access to a database for use with the SQL tile
    • SquaredUp Cloud Provider
    • Uptime Robot provider
    • Web API provider
  • How to integrate and visualize your external data
  • How to create a dashboard
  • Recycle Bin
  • Working with perspectives
  • Action buttons for dashboards and perspectives
  • VADA perspective
  • How to scope tiles
  • Timeframes for tiles
  • Grid Designer
  • Performance Metric Labels
  • How to use wildcards in metrics
  • How to show multiple metrics on one graph (v4.2 and below)
  • How to use Custom Labels
  • How to use criteria when scoping alerts
  • How to use criteria when scoping objects
  • How to run SCOM tasks
  • How to enable graph color matching
  • Sharing Dashboards with anyone - Open Access

dashboardingintegrations sql provider

SQL provider

An EAM edition license (or above) is required for this feature. To upgrade please contact [email protected]

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.

    Access to the SCOM Data Warehouse

    Access to the SCOM Data Warehouse is configured during the SquaredUp DS setup process. If you are able to see graphs in SquaredUp DS, SQL queries have access to the SCOM Data Warehouse (see How to check and reconfigure the Data Warehouse connection).

    Access to other databases

    To be able to query other databases, such as the Operations Manager database, the SquaredUp DS application pool identity needs to be given the db_datareader role in SQL Server Management Studio for the database you wish to query. See How to configure access to a database for use with the SQL tile.

  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:

    If you want to connect to the SCOM Data Warehouse:

    Tip: SquaredUp DS already comes with a default SQL provider that connects to your Data Warehouse, so you don't need to create a provider for this connection. In case you deleted this provider, you can always recreate it with the following connection string:

    global:dw

    If you want to connect to the Operations Manager database:

    Server=<SQLservername>;Database=<OperationsManagerDatabaseName>;Integrated Security=True;

    If the SquaredUp server and SQL server are in the same domain you can just use the SQL server name, if they are not in the same domain you should use the fully qualified domain name.

    Tip: If the Operations Manager database is on the same server as the Data Warehouse you can use the Data Warehouse provider in your tiles, but you need to remember in the Query panel that you have to put the following in front of the query:
    USE <OperationsManagerDatabaseName>;

    If you want to connect to any other data base:

    With integrated security:

    Server=<SQLservername>;Database=<DatabaseName>;Integrated Security=True;

    With username and password:

    Server=<SQLservername>;Database=<DatabaseName>;User Id=<username>;Password=<password>;

    If the SquaredUp server and SQL server are in the same domain you can just use the SQL server name, if they are not in the same domain you should use the fully qualified domain name.

    If you want to specify an instance

    Server=<SQLservername>\\<InstanceName>;Database=<DatabaseName>;Integrated Security=True;

    Example:

    Server=SQLServer1\\Main;Database=CRMDB;Integrated Security=True;

    If you want to specify a port

    Server=<SQLservername>,<PortNumber>;Database=<DatabaseName>;Integrated Security=True;

    Example:

    Server=SQLServer1,51433;Database=CRMDB;Integrated Security=True;

    Note: You need to use 64-bit ODBC drivers.

    Note: When an SQL tile uses an ODBC provider, you can't use mustache values for your queries in that tile.

    If you are using an ODBC driver

    After you've set up your ODBC driver in Windows on the SquaredUp server, add the following at to your connection string:

    Driver=<Name of your ODBC driver>;

    Example:

    Driver=<ODBCdriverName>;Server=<SQLservername>;Database=<DatabaseName>;User Id=<username>;Password=<password>;

    If you are using a System DSN

    Note: You need to use a System DSN, not a User DSN.

    After you've set up your System DSN in Windows on the SquaredUp server, enter the following instead of a connection string:

    DSN=<Name of your System DSN>;

    DSN=<DSNname>

  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?
Submit a ticket

On this page

  • About SQL providers
  • Adding an SQL provider

Footer

Sites

  • SQUAREDUP
  • SQUAREDUP DS
  • DOWNLOAD
  • COMMUNITY ANSWERS

Quick Links

  • SUBMIT A REQUEST
  • EVENTS
  • CAREERS

Small Print

  • PRIVACY POLICY
  • TERMS AND CONDITIONS
Youtubex (Twitter)LinkedIn

© SquaredUp 2025