How to connect OpenPDC with Influx?

Hello to everyone,
I’m trying to connect OpenPDC with Influx using Window 10 (I must use this OS) but I’m getting a lot of problems. I’m not even sure if I’m doing it in the right way. I’m trying both with Influx1.8 and Influx2.0 without getting grat results. Is there a kind of tutorial or something to do that? Or maybe someone did it already or knows how to do it and can help me writing a couple of lines here?
I thank anyone who can give me some help.

1 Like

Several people have used the STTP2HIDS tool to help with this:

It basically uses STTP (IEEE 2664) to collect streaming data from openPDC and then send this to InfluxDB.

Examples:

> Forward STTP from 10.21.35.90:7165 to InfluxDB on 10.21.35.95:8086:
       STTP2HIDS 10.21.35.90:7165 10.21.35.95:8086

> Forward STTP to InfluxDB with a specific token ID:
       STTP2HIDS -t=Qv02== openhistorian:7175 influxdb:8086

Hi Ritchie,

From my side I’m doing the same here: trying to send some frequency values to a influxDB bucket (in the same host, so no networking issues involved). The motivation here is to be able to use Alerting from Grafana using influxDB as a intermediary in the process (it is compatible with Grafana Alerting).

Can you please provide some examples on how to configure a Custom Output Stream to send data to influxDB?

This is the connection string I configured:

ServerUri=http://localhost:8086/; InputMeasurementKeys={44316d7c-8002-4c42-bf8f-72390311f086;4c819afc-115f-462b-8b63-748d11e5b8d6;b34c627a-9ef4-4ea6-9a38-b480a9911958;14739a7e-25c5-4284-93c5-e2c3ba3af89b}; DatabaseName=651cc0dbd26e5305; Password={OJNBEcj_VOVWsbRFbViYkXgHAK2pHj4kBKPkINhCsenWYRpKDLMgMiLvkDmpqA1xk1LGZkiHnyDecnFhNjLRNw==}; UserName=admin

Note that for the DataBaseName and Password I already tried differnet alternatives, using the name of the database and its ID. Similar for password, where as per above, I’m using a token I created. The user is the one I created to acess influxDB.

Any recommendation/documentation here would be welcomed!

Thanks!
Ricardo

PS.: In the logs I can see some encouraging messages about this attempt to send data to influxdb:

In this case, the STTP2HIDS tool is a standalone application that forwards data received over STTP into InfluxDB, so you would not need to use the InfluxDBOutputAdapter that is built into openHistorian. Instead, you could just point the STTP2HIDS tool to the openHistorian STTP output stream, normally listening on 7175 – also, running this command line tool would imply disabling the InfluxDB output adapter.

The STTP2HIDS tool will connect to the STTP publisher and directly forward received data to Influx, using the command line parameters you specify, token ID, point bucket, etc.

FYI, looks like this tool has no release, i.e., you would need to compile the code yourself in order to run it. That said, if you are interested in trying this out - let me know and I will compile and publish a release for you to test.

Thanks,
Ritchie

1 Like

Hi Ritchie,

So deciding to go forward with the influxDB integration, could you please guide me to deploy STTP2HIDS tool, building it from the code as you mentioned? Let´s give a try and see what can we do with Grafana/InfluxDB integration.

Note: I only want to send few selected signals to InfluxDB, I hope this is still possible with this method.

Thanks!