In Detail:
I am working with OPC UA protocol and receive Data from an OPC UA Server and i am saving them to a Oracle Database. I want to call that Information with an OPC UA Client and send it to Grafana, to display it.
As i understood there is no native official plugin for Oracle Database from Grafana Labs. But i found this inofficial plugin to use with Oracle Database:
Should i use this instead of developing my own plugin? I don’t have much time left.
if i generate Data in a java-Project and i want to connect Grafana to my
java-Project, what would i have to do?
That depends very much on the format of the data your “java-Project” is
generating.
Would i need to develop a Grafana-Plugin with “specific Query Editor that
is customized for the features and capabilities that my particular
java-project exposes”? As descriped at Data sources | Grafana documentation
I think you’d be far better off getting your “java-Project” to generate data in
a format natively understood by one of the data sources listed on that page.
You might as well try it and see if it works for you.
If it doesn’t, select a data source from the first link you posted above
which seems suitable for the data you’re working with, and which can accept
input data in a format you can generate as simply as possible.
Any particular reason for choosing a data source not supported by Grafana?
well we began with saving to a database before we knew that we will use Grafana. So it was random at this point.
So, OPC UA Server → Oracle → OPC UA Client → data source → Grafana?
Hm, seems overly complex to me.
well basicly its more complex than you already wrote… but basicly it’s nearly correct. This is okay, i should not explain to much, because of Non Disclosure Agreement of my company
Sorry to hear that.
I have 80 working hours left for this project. So i search for something to do in 20-40 hours.
Well if we only connect Grafana to the Database (maybe an other one, thats supported) and we display the data, it looks good. But if we want to analyse the data with a Client and THEN show it in Grafana… i need to develop a plugin?
Antony,
this is the greatest answer i have read to one of my questions in this year
Thanks
Well if we only connect Grafana to the Database (maybe an other one, thats
supported) and we display the data, it looks good.
Okay.
But if we want to analyse the data with a Client and THEN show it in
Grafana… i need to develop a plugin?
No, you just need to send the result of the Client analysis into a data source
which Grafana is happy with.
However:
It depends on what that “analysis” is, and whether a Grafana query can
achieve the same thing for you
It depends how you “connect Grafana to the Database and we display the
data” (your previous paragraph), and whether that connection (eg: telegraf?)
can do the “analysis” for you
It depends on what data input/output formats the OPC UA Client can handle
(this being something I have no familiarity with at all).
You asked for the Type of Data i get in OPC UA.
Well on the Client i get a java.util.List of Objects (OPC UA Class “DataValue”), which contain my information i want to display in Grafana.
Lets say i have a simple List of Integer + TimeStamp (basicly i realy have now). Which of the official supported DataSources would be the easiest way my Client should sent the Data to, to make this DataSource to be displayed by Grafana?
// List list_of_integer = “OPCUA.givemethatstuff(…);”
TableView tView = new TableView();
tView…setItems(list_of_integer);
Is something possible like that for grafana?
All i saw until now needs to be saved to HardDisk. I don’t want to save the data to harddisk, again. I only want to call it from DB and send it to Grafana after receiving from OPC UA Server.
Or to say it easy: I first want to display simple two dimensional data (value, time) in a two dimensional graph from a java-project. Which Dashboard / technology should i use?