Difference between revisions of "Transfer ODBC data from RMM to Influxdb"
(14 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
− | <span style="font-size:large;">'''Transfer ODBC data from RMM to Influxdb with Node-RED | + | <span style="font-size:large;">'''Transfer ODBC data from RMM to Influxdb with Node-RED set steps.'''</span> |
Line 7: | Line 7: | ||
<span style="font-size:medium;"> </span> | <span style="font-size:medium;"> </span> | ||
− | <span style="font-size:medium;">2.Copy “'''node-red-contrib-rmm3.1'''” folder to path: “'''C:\Program Files (x86)\Advantech\NodeRed Server\nodejs\node_modules'''”, and restart '''NodeRed service''' | + | <span style="font-size:medium;">2.Copy “'''node-red-contrib-rmm3.1'''” folder to path: “'''C:\Program Files (x86)\Advantech\NodeRed Server\nodejs\node_modules'''”, and restart '''NodeRed service.'''</span> |
<span style="font-size:medium;"> </span> | <span style="font-size:medium;"> </span> | ||
− | <span style="font-size:medium;">3.Open '''node-red''' and import | + | <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;">4.Edit '''ServerSetting node, '''input information as below.</span> | |
− | |||
− | <span style="font-size:medium;">4.Edit '''ServerSetting node, '''input below | ||
<span style="font-size:medium;">Type : Basic</span> | <span style="font-size:medium;">Type : Basic</span> | ||
Line 33: | Line 29: | ||
<span style="font-size:medium;">Node-RED “ServerSetting” node</span> | <span style="font-size:medium;">Node-RED “ServerSetting” node</span> | ||
− | <span style="font-size:medium;">[[File:Node-red ServerSettings.jpg|upright]]</span> | + | <span style="font-size:medium;">[[File:Node-red ServerSettings.jpg|upright|Node-red ServerSettings.jpg]]</span> |
+ | |||
+ | |||
+ | |||
− | |||
<span style="font-size:medium;">5.Edit '''ODBC_Handler node''',input RMM Agent device id</span> | <span style="font-size:medium;">5.Edit '''ODBC_Handler node''',input RMM Agent device id</span> | ||
Line 41: | Line 39: | ||
<span style="font-size:medium;">Node-RED “ODBC_Handler” node</span> | <span style="font-size:medium;">Node-RED “ODBC_Handler” node</span> | ||
− | <span style="font-size:medium;">[[File:Node-red ODBCHandler.jpg|upright]] | + | <span style="font-size:medium;">[[File:Node-red ODBCHandler.jpg|upright|Node-red ODBCHandler.jpg]]</span> |
− | |||
− | |||
Line 55: | Line 51: | ||
<span style="font-size:medium;">Node-RED “ODBC_Handler” node</span> | <span style="font-size:medium;">Node-RED “ODBC_Handler” node</span> | ||
− | <span style="font-size:medium;">[[File:Node-red ODBCHandler.jpg|upright]] | + | <span style="font-size:medium;">[[File:Node-red ODBCHandler.jpg|upright|Node-red ODBCHandler.jpg]]</span> |
− | |||
− | |||
Line 67: | Line 61: | ||
<span style="font-size:medium;">7.Edit influxdb out node, input information as below. Remember to create influx datebase by self.</span> | <span style="font-size:medium;">7.Edit influxdb out node, input information as below. Remember to create influx datebase by self.</span> | ||
− | <span style="font-size:medium;">Note: Time Precision must set milliseconds(ms). | + | <span style="font-size:medium;">Note: Time Precision must set milliseconds(ms).</span> |
<span style="font-size:small;">Node-RED “influxdb out” node - 1</span> | <span style="font-size:small;">Node-RED “influxdb out” node - 1</span> | ||
− | <span style="font-size:small;">[[File:Node-red InfluxdbOut 1.jpg|upright]]</span> | + | <span style="font-size:small;">[[File:Node-red InfluxdbOut 1.jpg|upright|Node-red InfluxdbOut 1.jpg]]</span> |
<span style="font-size:small;">Node-RED “influxdb out” node - 2</span> | <span style="font-size:small;">Node-RED “influxdb out” node - 2</span> | ||
− | <span style="font-size:small;">[[File:Node-red InfluxdbOut 2.jpg|upright | + | <span style="font-size:small;">[[File:Node-red InfluxdbOut 2.jpg|upright|Node-red InfluxdbOut 2.jpg]]</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
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