Niagara AX Connection MySQL Database

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