A “data collection agent” is required to write data to any database, generally a database does not connect to directly source devices.
The collection agent sits between the source of the data, in your case the R-1, and the database. It’s job is to collect, normalize, and write to a database.
The agent can reside on the same PC as the database. There are purpose built agents like Telegraf from influx. And many write their own agent, using their preferred language of choice (python, Nodejs, Golang…..).
[Source] <-[Agent]-> [DB]
In most cases Node-RED is sufficient and provides a great visual way to debug and parse your payloads and can write to any database of your choice. In addition to having nodes supported by Opto22, specifically for snap and groov.