Integrating ESIA with Grafana

⚠️ Firstly, it is advisable to create a PostgreSQL user with READ ONLY. Grafana does not check whether a query might be malicious or not. ⚠️

In the Connection menu, click on “Data sources” then “Add new data source”

then search for ‘postgres’ in the search bar and click on it

You must enter all the necessary parameters according to your server

Once everything is correct, click on “Save & test”

This step requires a thorough understanding of the ESIA database.

When creating the widget, you will need to query the database using SQL

Examples of some widgets

Below the temperature widget is an example of an SQL query.

For further information or assistance with widget integration, please do not hesitate to contact ESIA support.