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

From ESS-WIKI
Jump to: navigation, search
 
(6 intermediate revisions by the same user not shown)
Line 7: Line 7:
 
<span style="font-size:medium;">&nbsp;</span>
 
<span style="font-size:medium;">&nbsp;</span>
  
<span style="font-size:medium;">2.Copy&nbsp;“'''node-red-contrib-rmm3.1'''”&nbsp; folder to path: “'''C:\Program Files (x86)\Advantech\NodeRed Server\nodejs\node_modules'''”, and restart '''NodeRed service'''</span>
+
<span style="font-size:medium;">2.Copy&nbsp;“'''node-red-contrib-rmm3.1'''”&nbsp; folder to path: “'''C:\Program Files (x86)\Advantech\NodeRed Server\nodejs\node_modules'''”, and restart '''NodeRed service.'''</span>
  
 
<span style="font-size:medium;">&nbsp;</span>
 
<span style="font-size:medium;">&nbsp;</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;">3.Open '''node-red''' and import flow from "'''NodeRed transfer ODBC to influxdb.txt'''".</span>
 
 
 
 
  
  

Latest revision as of 08:39, 17 September 2018

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