Transfer ODBC data from RMM to Influxdb

Transfer ODBC data from RMM to Influxdb with Node-RED set steps.

1.install “NodeRed Server IoT Gateway_v1.1.2.exe”

 

2.Copy “node-red-contrib-rmm3.1”  folder to path: “C:\Program Files (x86)\Advantech\NodeRed Server\nodejs\node_modules”, and restart NodeRed service.

 

3.Open node-red and import flow from "NodeRed transfer ODBC to influxdb.txt".

4.Edit ServerSetting node, input information as below.

Type : Basic

URL: RMM server url

Username: RMM server account

Password: RMM server password

 

Node-RED “ServerSetting” node

5.Edit ODBC_Handler node，input RMM Agent device id

Node-RED “ODBC_Handler” node

6.Edit ODBC-SensorGet node, input RMM Agent device id

Node-RED “ODBC_Handler” node

7.Edit influxdb out node, input information as below. Remember to create influx datebase by self.

Note: Time Precision must set milliseconds(ms).

Node-RED “influxdb out” node - 1

Node-RED “influxdb out” node - 2