Difference between revisions of "Transfer ODBC data from RMM to Influxdb"

From ESS-WIKI
Jump to: navigation, search
Line 1: Line 1:
<span style="font-size:large;">'''Transfer ODBC data from RMM to Influxdb with Node-RED User guide'''</span>
+
<span style="font-size:large;">'''Transfer ODBC data from RMM to Influxdb with Node-RED set&nbsp;step by step.'''</span>
  
  
Line 13: Line 13:
 
<span style="font-size:medium;">3.Open '''node-red''' and import flow from "NodeRed transfer ODBC to influxdb.txt".</span>
 
<span style="font-size:medium;">3.Open '''node-red''' and import flow from "NodeRed transfer ODBC to influxdb.txt".</span>
  
<span style="font-size:medium;"></span>
+
 
  
  

Revision as of 11:32, 18 January 2018

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


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