Steps are as follows
1. Install Niagara AX (3.8.38);
2. Install MySQL (5.6.25): put MYSQL\CONNECTOR.J 5.1\mysql-connector-java-5.1.35-bin.jar under $niagara_home\jre\lib\ext ;
Establish database Mikedb, set up table point, insert data, such as:
3. Start station:station test;
4. Open workplace, connect station test;
5. Create a new rdbmsnetwork under the config/drivers of the connected station test;
6. Create a new mysqldatabase under the new Rdbmsnetwok;
7. Configure the properties of the mysqldatabase;
8. Create a new rdbmspointquery under the points of mysqldatabase;
9. Select the Rdbmspointquery RDBMS Query view to view the results of the SQL statement execution;
10. Double-click Rdbmspointquery to enter its default view RDBMS point Query Manager, create a new two numeric point, set its name and corresponding value Column respectively;
11. Configure the new numeric point's proxy ext key Value1 as the ID of the record in the query result;
12. Double-click Rdbmspointquery to see the value of the new two numeric point's out property displayed as the value of the query result;
Follow up: Perform insertions, deletions, etc...
Niagara AX Connection MySQL Database