Grafana Integration on RapidScada 6

[DonRapid]

How should we go about integrating graphana with Rapid Scada 6?
I’ve tried using the previous method from 3 years ago but haven’t had success.

[greenfoxx]

Hi!
We faced that Grafana plugins, such as grafana-simple-json-datasource, become obsolete too often and unpredictable.
We decided not too use special plugins to integrate Rapid SCADA and Grafana. With Rapid SCADA 6.x you should configure archives to store historical data into database, then display data by Grafana. I suggest storing historical data to PostgreSQL.

Could you please check short instructions for working with Grafana
PostgreSQL data source and Rapid SCADA.

Work at Grafana:
1. Choose as data source PostgreSQL.
2. Set the data source’s basic configuration options in setting tab.
For example:
Host: The IP address/hostname your PostgreSQL instance
Database: rapid_scada
User: postgres
Password: Database user’s postgres password – postgres
3. Write a sql-query. You can use Query builder or Query editor.
4. Simple query example (Query on one channel, not including into stat = 0, and also not showing a gap, if there is no data in a certain period of time)

SELECT
time_stamp AS "time",
val
FROM mod_arc_postgre_sql.mincopy_historical
WHERE
cnl_num = 101
ORDER BY 1

[zzz]

You can also try influxd, it has much better storage efficiency (if you plan to store long term data in influxd) and better time series analysis support.
It’s just the configuration is a bit inconventional for DBAs used to sql dbs. Interfacing with SQL db is not hard from influxd, but interfacing with influxd from SQL is a different story.

• This reply was modified 2 years ago by zzz.

[DonRapid]

Great Advice thank you.

Is it possible to simply link Rapid Scada 6 to Influx DB Cloud? Or can this only be done with a local hosted DB?

Has anyone done this that can help us with setup instructions?

[Mikhail]

Is it possible to simply link Rapid Scada 6 to Influx DB Cloud?

Yes, it’s possible. Take into account that a free Influx DB cloud tier is very limited.

[chika]

hello I have tried to follow the youtube tutorial, but the runtime page displays “localhost refused to connect.” (https://drive.google.com/file/d/12FC7OO7hiFGqtKtUP9RXug-e_TYuucd3/view?usp=sharing)

[chika]

On the Grafana dashboard, the data is displayed. but on fast scada the grafana dashboard is not there https://drive.google.com/file/d/1bbsQ2ZDodRatEUN_1QY1Ztkn_O2V8-NL/view

• This reply was modified 1 year, 8 months ago by chika.

[Mikhail]

Hello,
Press F12 in browser and find the error details.
You should enable displaying data in frames in the Grafana config.

• This reply was modified 1 year, 8 months ago by Mikhail.

[Author]

Posts