InfluxDB and TTN

[Qmick]

Has anyone managed to connect a TTN V3 application to an AWS hosted InfluxDB?

This should be easy but it appears to be extremely complex - or at least poorly documented.

Any pointers would be appreciated.

[vaasseniot]

Run an instance of NodeRed…mqtt connection to TTN v3 → Influxdb

[Baxter]

@Qmick

e managed to connect a TTN V3 application to an AWS hosted InfluxDB?

This should be easy but it appears to be extremely complex - or at least poorly documented.

Any pointers would be appreciated.

my influx runs on AWS while the nodered runs on a pi (gateway), check this to prepare the data if you want

GitHub - baxtery/TTN_V3_Node-Red

If you don’t want node-red to run locally, IBM cloud (i remember) offers a free instance for nodered

[Qmick]

Thank you Baxter, that was very helpful and I am now getting data out of TTN onto my AWS hosted Node-Red. Now I need to figure out how to use Node red to do stuff with the data- have you managed to do the same? For example how would I get it into a database?

[Qmick]

Thanks Vaasseniot,

Do you have any pointers to getting it out of Node-Red and into Influx?

[vaasseniot]

Hi @Qmick ,

first of all to start is this post a good one to read:

MQTT in Node-RED [HowTo]

Node-RED has built-in support to act as an MQTT client, which can be used with TTN’s MQTT Data API. For new developments, one should not use the The Things Network’s node-red-contrib-ttn, which is no longer supported. Setting up the MQTT client The following may seem a lot of steps, but Node-RED will guide one through the initial setup. For the current version V2 as used on the TTN community network: Drop an “mqtt in” node on your flow: [mqtt in] Double-click it: [mqtt in] …

and publish the data to InfluxDB is realy easy, install palete InfluxDB → connect to database → write to measurment.

Here some sample flows:

node-red-contrib-influxdb

[Qmick]

@vaasseniot

and publish the data to InfluxDB is realy easy, install palete InfluxDB → connect to database → write to measurment.

Thanks but it all comes to tears here: “and publish the data to InfluxDB is realy easy, install palete InfluxDB → connect to database → write to measurment.”

My Influxdb is a cloud instance somewhere else and I have no idea how to connect to it
I don’t see any sample scripts there which show how to do this as they all point to Localhost

Sorry to take your time.

[dreimal8]

The Influx Connection Node works with an ip and port - so it doesn’t matter if your DB is local or somewhere else. Give it a try.

[vaasseniot]

@Qmick it doen’t matter if it is a cloud instane. hostname - portnumber is fine.