PACEdge User Manual
Section 6
GFK-3178B
Nov 2020
PACEdge Usage Examples
20
6.
If the connection to the MySQL database was successful a green icon with test connected
will appear right under the MySQL icon:
.
7.
Click on the Inject button of the first flow. This will create a new table in MySQL with entries
to store person ID, last name, first name, etc. You can explore request that was sent to
MySQL by opening the template icon
8.
Next, click on the Inject button of the second flow. This will insert a new entry into the
database. You can modify the entry being inserted by modifying the functio
n’s
Insert
Value.
9.
Finally, click on the Inject button of the last flow. This will send a query to the database and
return your entries.
6.5
Grafana Use Example
6.5.1
Example Description
This example shows how to configure Grafana to display data that is stored in InfluxDB.
6.5.2
Prerequisites
Requires running InfluxDB Example, as described in Section 6.2.
6.5.3
Example Installation
Open Grafana by using a shortcut from the PACEdge Home page.
6.5.4
Example Walk Through
1.
Within Grafana, go to Configuration, then Data Sources.
2.
Click on Add Data Source and select InfluxDB.
3.
Enter the following configuration:
a.
b.
Database: test (or your own database name, need to match Node-RED)
c.
User: admin
d.
Password: edgestack
e.
HTTP Method: GET
f.
All other entries: default
