Sending sensor data to Oracle Cloud from IoT device with LoRa via Helium network and MQTT integration

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:


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 script as explained in the mentioned post here. For example:

export broker="mqtt://"
export mqtttopic="jxxxxxxxp"
export stream=""
export tenancy=""
export user=""
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 


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!!!

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.