Transfer ODBC data from RMM to Influxdb

From ESS-WIKI
Jump to: navigation, search

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

Node-red ServerSettings.jpg



5.Edit ODBC_Handler node,input RMM Agent device id

Node-RED “ODBC_Handler” node

Node-red ODBCHandler.jpg




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

Node-RED “ODBC_Handler” node

Node-red ODBCHandler.jpg




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 InfluxdbOut 1.jpg

Node-RED “influxdb out” node - 2

Node-red InfluxdbOut 2.jpg