As mentioned in this post, we explained how to send data to Oracle Cloud autonomous database via REST endpoint.

Today we are explaining how to send sensor data using Helium MQTT integration. The solution is similar to one we posted here using TTN.

Helium mqtt integration setup

Create an integration in Helium console as follows, you’ll need a mqtt server instance somewhere:

CREATE OR MODIFY AN EXISTING FLOW TO INCLUDE THE NEW INTEGRATION

The same way explained in the mentioned post, drop the mqtt integration and connect to the decoder function as follows:

Modify mqtt to OCI Streaming converter

Change the mqtt server settings in the m2os.sh script as explained in the mentioned post here. For example:

export broker="mqtt://test.mosquitto.org:1883"
export mqtttopic="jxxxxxxxp"
export stream="ocid1.stream.oc1.eu-frankfurt-1.a...q"
export tenancy="ocid1.tenancy.oc1..aaa...a"
export user="ocid1.user.oc1..aaa...a"
export region="eu-frankfurt-1"
export fingerprint="f...a"
export ppkfile=$(cat ./myppk)
export ppkpasswd="-"

pkill -9 m2os
ps -ef | grep -i m2os
go run m2os.go 

VERIFICATION

Depending on the frequency of producing data in the LoRa sensor module you will start watching messages processed by the converter:

Take a look to the data payload containing the values of the humidity, temperature, light and pressure.

As mentioned in the post series regarding TTN, messages are stored in an object storage for later processing using the solution pattern based in external tables as explained here. In comming post we’ll explain how to create the external table for the payload that produces the RAK sensor module utilised here.

That’s all, hope it helps!!!