Important: This documentation is about an older version. It's relevant only to the release noted, many of the features and functions have been updated or replaced. Please view the current version.

Sqlyze data source for Grafana

Enterprise

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