Getting TTN Data into InfluxDB the Easy Way
A presentation at The Things Conference in in Amsterdam, Netherlands by David G. Simmons
Integrating The Things Network with InfluxDB David G. Simmons Senior Developer Advocate, InfluxData
Agenda ✦ Sign up for InfluxCloud2 ✦ Configure to accept metrics ✦ Configure Telegraf ✦ Collect local stats ✦ Connect to The Things Network ✦ Build a Dashboard @davidgsIoT
Sign up! https://cloud2.influxdata.com/signup @davidgsIoT
@davidgsIoT You will have to verify your email address in order to complete your signup!
Choose a Cloud ✦ AWS ✦ US-West ✦ EU-central (Germany) ✦ GCP ✦ Azure coming soon! @davidgsIoT We will be using AWS, so choose one of the AWS regions for your account.
@davidgsIoT
@davidgsIoT
@davidgsIoT Choose a plan. I recommend the Free account for now. You can always upgrade later Take note of the restrictions.
Load Data ✦ We’re going to configure an instance of Telegraf to collect some system metrics on the host ✦ There are other options ✦ We will customize later! @davidgsIoT
@davidgsIoT Next we’re going to load some data!
@davidgsIoT We will create a telegraf configuration from here.
@davidgsIoT For now, we will just monitor the system.
@davidgsIoT
@davidgsIoT
We Need Telegraf! ✦ This assumes you already have it running ✦ If you do, you can simply copy/paste and go! ✦ If not we will get it running next! ✦ You should have Docker running already @davidgsIoT
@davidgsIoT
Run Docker davidgs@Davidgs ~ % docker pull telegraf davidgs@Davidgs ~ % mkdir telegraf davidgs@Davidgs ~ % cd telegraf davidgs@Davidgs telegraf % docker run —rm telegraf telegraf config > telegraf.conf davidgs@Davidgs telegraf % docker run -privileged -e “INFLUX_TOKEN=TOKEN” telegraf <paste> @davidgsIoT Get your Token from the Browser screen Get your Telegraf command from your browser screen
@davidgsIoT
@davidgsIoT
Data flowing in! @davidgsIoT
Get a better configuration Click on the name @davidgsIoT
Download your new Config! This is where we customize it! @davidgsIoT
Time for some LoRaWan Data ✦ You’ll need your The Things Network info handy! ✦ Decode a packet ✦ Send it to MQTT ✦ Read it from MQTT ✦ Put it into InfluxDB @davidgsIoT
Decode Your Payload function Decoder(bytes, port) { var decoded = {}; var co2Int = (bytes[0] << 8) | bytes[1]; // CO2 is a single byte var cInt = (bytes[2] << 8) | bytes[3]; // temperature ºC is 2 bytes var rem =(bytes[4] << 8) | bytes[5]; // humidity % is 2 bytes var pre = (bytes[6]) + ((bytes[7]) << 8) + ((bytes[8]) << 16) + ((bytes[9]) << 24) ; // pressure is a 4-byte value var alt = (bytes[10]) + ((bytes[11] << 8)) +(bytes[12] << 16) + (bytes[13] << 24); // Altitude is 4 bytes // Decode integer to float decoded.co2 = co2Int; decoded.temp_c = cInt / 100; decoded.humidity = rem / 100; decoded.pressure = pre / 100; decoded.altitude = alt / 100; } return decoded; @davidgsIoT
Get your access Key Also your application name @davidgsIoT
Edit your Telegraf.conf [[inputs.mqtt_consumer]] servers = [“tcp://uswest.thethings.network:1883”] qos = 0 connection_timeout = “30s” topics = [ “+/devices/+/up” ] client_id = “ttn2” username = “APPLICATION NAME” password = “ACCESS KEY” data_format = “json” @davidgsIoT
Restart telegraf davidgs@Davidgs telegrafPreso % docker run —rm —name=telegraf -e “INFLUX_TOKEN=TOKEN” -v pwd/ telegraf.conf:/etc/telegraf/telegraf.conf:ro telegraf
-e Sets the environment variable to your token -v pwd/telegraf.conf:/etc/telegraf/telegraf.conf:ro Mounts your new config in your Docker container
@davidgsIoT
Browse your data You should see lots of meta-data along with your payloads @davidgsIoT
Save it as a Dashboard! @davidgsIoT
Questions? @davidgsIoT
This is a complete walk-through of setting up and sending data from The Things Network to InfluxDB Cloud2
Resources
The following resources were mentioned during the presentation or are useful additional information.
Buzz and feedback
Here’s what was said about this presentation on social media.
