---
title: "Sqlyze Datasource plugin for Grafana"
description: "Grafana Sqlyze Data Source. Generic datasource plugin to connect SQL databases via ODBC driver. Sqlyze Datasource plugin for Grafana by Grafana Labs."
---

> This is the Markdown version of https://grafana.com/grafana/plugins/grafana-odbc-datasource/

# Sqlyze Datasource

- Developer: Grafana Labs
- Version: 1.5.25
- [Change log](https://grafana.com/grafana/plugins/grafana-odbc-datasource/changelog.md)

# 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**

```sql
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.