Overview

Introduction

The SQL Connector allows 2Ring Dashboards & Wallboards (DW) to connect to any SQL-compatible database and retrieve data using custom-defined queries or direct table access. It is designed for environments where business metrics are stored in existing databases and no specialized APIs are available.

It provides full flexibility by allowing administrators to define their own Grid and KPI Calculation Functions based on either single-table reads or advanced SQL queries with parameterization. These functions are created and maintained through the DW Administration Tool, without the need for code changes or redeployments.

Key Features

  • Direct integration with any SQL-compliant database (e.g., MSSQL, PostgreSQL, MySQL)

  • Supports databases hosted in Azure, such as Azure SQL and Azure PostgreSQL

  • Supports two types of Grid Functions: TABLE (simple table reads) and QUERY (custom SQL queries)

  • Parameterized queries for dynamic filtering and grouping

  • KPI calculations based on Grid results

  • Optional support for time zones

  • Fully configurable via the DW Administration Tool

  • Excel and CSV files can be used as data sources via ODBC or OleDb providers

Use Cases

Typical use cases include integration with internal business systems, legacy data warehouses, or third-party solutions that provide access to raw data via SQL.

  • Display agent productivity metrics from a legacy database

  • Aggregate sales data across departments using SQL queries

  • Visualize ticketing system data without building a custom connector

  • Create dashboards from internal BI systems with SQL export