Plugins 〉Sqlyze Datasource
14 day trial Install plugin
1 Enterprise plugin Upgrade and install
Sqlyze Datasource
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 |
Impala
- Driver: https://www.cloudera.com/downloads/connectors/impala/odbc/2-6-14.html
- Settings: https://docs.cloudera.com/documentation/other/connectors/impala-odbc/latest/Cloudera-ODBC-Driver-for-Impala-Install-Guide.pdf
Databricks
- Driver: https://databricks.com/spark/odbc-drivers-download
- Settings: https://docs.databricks.com/integrations/bi/jdbc-odbc-bi.html#odbc-driver
Third party drivers
Settings vary per driver. This plugin allows any key/value pair to support various ODBC drivers.
Grafana Enterprise
- Available with a Grafana Enterprise license
- Access to all Enterprise plugins
- Run fully managed or self-manage on your own infrastructure
Installing Sqlyze Datasource:
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
Installing plugins on a Grafana Cloud instance is a one-click install; same with updates. Cool, right?
Note that it could take up to 1 minute to see the plugin show up in your Grafana.
For more information, visit the docs on plugin installation.
Installing on a local Grafana:
For local instances, plugins are installed and updated via a simple CLI command. Plugins are not updated automatically, however you will be notified when updates are available right within your Grafana.
1. Install the Data Source
Use the grafana-cli tool to install Sqlyze Datasource from the commandline:
grafana-cli plugins install The plugin will be installed into your grafana plugins directory; the default is /var/lib/grafana/plugins. More information on the cli tool.
Alternatively, you can manually download the .zip file for your architecture below and unpack it into your grafana plugins directory.
Alternatively, you can manually download the .zip file and unpack it into your grafana plugins directory.
2. Configure the Data Source
Accessed from the Grafana main menu, newly installed data sources can be added immediately within the Data Sources section.
Next, click the Add data source button in the upper right. The data source will be available for selection in the Type select box.
To see a list of installed data sources, click the Plugins item in the main menu. Both core data sources and installed data sources will appear.
Changelog
1.1.2
- Chore - Backend binaries are now compiled with Go 1.20.4
1.1.1
- Chore - Backend binaries are now compiled with Go 1.20.3
1.1.0
- Feature - include unixodbc libs in linux amd64 dist
1.0.2
- Chore - Backend binaries are now compiled with Go 1.19.4
- Chore - Backend Grafana dependencies updated to latest version
- Chore - Add spellcheck
1.0.1
- Fix - default time to UTC not Local
1.0.0
- Fix - run button position on variable page
0.4.1
- Fix - set exec permission
0.4.0
- Feature - Template variables
0.3.0
- Feature - Infer data types
0.0.2
- Beta release.
