Grafana Sqlyze Data source

A Grafana data source plugin that connects to hundreds of datasources using one language: SQL. Connect to your favorite SQL databases, NoSQL databases, and many other non-SQL sources…and query them with SQL.

This plugin is not yet supported in Grafana Cloud.

The data source uses ODBC

This plugin has a dependency on ODBC. Windows/Linux/MacOS all support ODBC. Some dependencies may need to be installed.

Using ODBC with Linux ARM or MacOS

Install or make sure unixODBC is installed

https://www.ibm.com/docs/en/db2/11.5?topic=managers-installing-unixodbc-driver-manager

This plugin requires an ODBC driver. ODBC Drivers are available through 3rd parties. See below for a list.

Time series

To format your queries for time series, simply use the alias: as time

select date_start as time, foo, avg(bar) as bar
from foo_bar

Short list of known drivers and settings

DB2

Can be downloaded from IBM Fix Central where you can choose your DB2 Version and Platform: https://www.ibm.com/support/fixcentral/swg/selectFixes?parent=ibm%7EInformation%20Management&product=ibm/Information+Management/IBM+Data+Server+Client+Packages&release=11.5.*&platform=Mac+OSX&function=all
Driver Settings - set the path to where the driver is installed and add required settings (MacOS example below)

Setting	Example Value
Driver	/Applications/dsdriver/lib/libdb2o.dylib
Timeout (seconds)	10
host	127.0.0.1
port	50000
uid	db2inst1
pwd	••••••••••••
database	sample