You can translate the document:

Goal

This document explains how to connect from Grafana to Denodo. Grafana is an open-source, general-purpose dashboard and graph composer that runs as a web application. It supports graphite, InfluxDB, and opentsdb as backends.

Content

Running Grafana

You can run Grafana in the cloud or installed on Windows, Mac, Linux, Docker, or ARM platforms:

  1. Download Grafana from https://grafana.com/grafana/download
  2. Start the server (<GRAFANA_HOME>/bin/grafana_server.sh|exe)
  3. Open the app in your browser, go to http://localhost:3000/login
  4. Login. Use admin/admin by default, but the GUI will ask you to change the password after the first login.

Setting up a Denodo Data Source in Grafana

  • Click the “Add Data Source” button, then search for the PostgreSQL type.

  • Click the “PostgreSQL” button and define these variables:
  • Name: Denodo
  • Host URL: <Denodo host name>:9996 (default ODBC port)
  • Database name: <virtual database name>
  • Username: <Denodo user>
  • Password: *******
  • TLS/SSL mode: use require or disable depending on whether you want to SSL or not.
  • Click “Save & Test”

Grafana’s Timeseries

To use Grafana’s Timeseries capabilities, you should have a timestamp column in the Denodo view you access from Grafana.

For instance, if you have a view with a column representing a date but of ‘text’ data type, you can convert the date string to timestamp value with the following function:

to_timestamp(‘format’, str value, locale)

With this string input ‘Tue Mar 29 2024 17:36:44 GMT’, it will look something like this:

to_timestamp('EEE MMM dd yyyy HH:mm:ss z', <input>, 'en_US')

You can find references for date formatting here: SimpleDateFormat.

You also need to make sure that the values used in Grafana are of a numeric type. You can convert those values using the cast function:

CAST(<value> AS FLOAT)

Creating a Dashboard Panel in Grafana

  • Click the “Add visualization” button in your selected dashboard.

  • Select the Denodo Data Source.
  • Click the “Add query” button and type your VQL query:

SELECT

    $__time("resourcepollingdate"), cpupercentage

FROM

  denodo_dashboard.server_resources

Disclaimer
The information provided in the Denodo Knowledge Base is intended to assist our users in advanced uses of Denodo. Please note that the results from the application of processes and configurations detailed in these documents may vary depending on your specific environment. Use them at your own discretion.
For an official guide of supported features, please refer to the User Manuals. For questions on critical systems or complex environments we recommend you to contact your Denodo Customer Success Manager.

Questions

Ask a question

You must sign in to ask a question. If you do not have an account, you can register here