Connecting to Grafana

Hello,

if i generate Data in a java-Project and i want to connect Grafana to my java-Project, what would i have to do?

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 https://grafana.com/docs/features/datasources/#data-source-overview

==========

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.

Thanks - Enomine

Hello,

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.

In Detail:
I am working with OPC UA protocol

OPC Unified Architecture - Wikipedia I assume?

and receive Data from an OPC UA Server and i am saving them to a Oracle
Database.

Any particular reason for choosing a data source not supported by Grafana?

I want to call that Information with an OPC UA Client and send it to
Grafana, to display it.

So, OPC UA Server → Oracle → OPC UA Client → data source → Grafana?

Hm, seems overly complex to me.

As i understood there is no native official plugin for Oracle Database from
Grafana Labs.

Correct.

But i found this inofficial plugin to use with Oracle Database:
Oracle Database plugin for Grafana | Grafana Labs
Should i use this instead of developing my own plugin?

  1. You might as well try it and see if it works for you.

  2. 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.

  3. You might find that Telegraf | InfluxData
    helps.

I don’t have much time left.

Sorry to hear that.

Regards,

Antony.

Antony,
this is the greatest answer i have read to one of my questions in this year =)

OPC_Unified_Architecture I assume?

yes

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 :wink:

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?

Thanks - Enomine

Antony,
this is the greatest answer i have read to one of my questions in this year

Thanks :slight_smile:

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:

  1. It depends on what that “analysis” is, and whether a Grafana query can
    achieve the same thing for you

  2. 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

  3. It depends on what data input/output formats the OPC UA Client can handle
    (this being something I have no familiarity with at all).

Hope that helps,

Antony.

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?

Thanks - Enomine

If i would use Java FX i would do something like:

// 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.

Thanks - Enomine

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?

Thanks - Enomine