Controller NX NJ MySQL SQL 2.0 Quick Start EN 202002 SW 103 (EN)

The most widely used relational databases in the world are MySQL, Oracle and Microsoft SQL server. This document covers how to configure and run NJ/NX SQL 2.0 with MySQL 8. Specifically, the document walks you through the configuration and setup of the database, creating a connection between the controller and database, enabling error logging, controlling spooling, creating batch inserts and configuring and running stored procedures. Note: MySQL is Open Source and free to use. Using TLS for authentication is not covered in this guide. Basic DB Creation and Connection Testing Open Sysmac Studio Connect directly to the controller using the controllers IP address (default IP address:

port 1 192.168.250.1, port 2 192.168.251.1). Select “Ethernet connection via hub” and press “Connect”. Note: Your computer must be on the same subnet (ex. 192.168.250.XXX) as the controller. Trademarks • Sysmac and SYSMAC are trademarks or registered trademarks of OMRON Corporation in Japan and other countries for OMRON factory automation products. • Oracle, Java, and MySQL are registered trademarks of Oracle Corporation and/or its affiliates in the USA and other countries.

Стр. 2

The connection will start in online mode. Note: The program that currently resides on the PLC will not be uploaded. If the program is required, press the synchronize button followed by “transfer from controller”. The nice thing about connecting directly to the controller is it configures the device and connection parameters. To check to see the version of the controller, right click the controller icon. Select “Change Device”.

Стр. 3

Note: SQL 2.0 is only available on firmware 1.33 and up. Note: Controllers with XX20 have SQL functionality. If you created a new program and did not connect directly to the controller, you must set the IP address of the controller in Sysmac Studio to go online. Select Controller>Communication Setup.

Стр. 4

Select “Ethernet connection via hub”. Set the IP Address of the controller and select “Ethernet Communication Test”. Close the window if the test comes back “OK”. If the test fails, make sure your computer is connected to the controller. The next step is to install and setup MySQL 8.0.

Стр. 5