▶ Engineer's best friend for learning: https://realpars.com/ ============================ ▶ You can read the full post here: https://realpars.com/database-enabled-controllers/ ⌚Timestamps: 00:00 - Intro 01:01 - MQTT communication 02:01 - OPC UA communication 02:39 - JSON data format 03:26 - Accessing the database 04:55 - Wind turbine and weather station data 06:20 - Database queries 07:07 - Summary ============================= In this video, we will demonstrate how Omron’s Sysmac Studio and an NX machine controller can directly access a relational database without a separate computer or middleware. We use Sysmac Studio to move and use data from IoT sources and store some of this data in the NX Controller Database. We’re going to move and use data from a wind turbine and an outdoor weather station. We’ll show you how to easily perform insert and select operations on this database. In this demonstration, we are going to use MQTT to capture the wind turbine and weather station data. MQTT is a very popular publish/subscribe messaging communication protocol for IoT devices allowing the exchange of data via Cloud services. MQTT uses an MQTT Server or Broker intermediary entity that enables MQTT clients to communicate. The Server collects Published messages from MQTT clients and delivers the messages addressed to receivers that were Subscribed. An MQTT Client can work simultaneously as a publisher or a subscriber on several topics. Sysmac Studio and the NX machine controller can also speak using OPC UA which is another mechanism for transferring information between servers and clients. Omron controllers can accomplish MQTT via Sysmac Studio communication Function Blocks. Sysmac Studio has an MQTT Library with simple-to-use FBs to Connect, Ping, Publish & Subscribe to an MQTT server. JSON (JavaScript Object Notation) is a very popular data format with the IoT and can be used to exchange data via MQTT. OMRON has created a JSON library to convert Sysmac variables to JSON string and to extract variables from a JSON string. Messages can be encoded with JSON at the source, communicated via MQTT, and decoded at the receiver using JSON. Unlike most other PLCs or control systems, OMRON controllers do not need any additional software, hardware, or Server Middleware. Sysmac Studio has several DB Function blocks to perform functions such as insert, select, and delete. Connecting with one of several possible relational database types servers to choose from is easily accomplished. https://www.youtube.com/channel/UCjRXmrLirV8SmPDSbJOUQjQ ============================= Omron PLC Basics: Fast-Track Training in NX & NJ Series: https://learn.realpars.com/courses/omron-nx-and-nj-plcs Omron PLC Programming Basics - Sysmac Studio: https://learn.realpars.com/courses/Omron-PLC-Programming-Basics-Sysmac-Studio ============================= TWEET THIS VIDEO: https://ctt.ac/d64T7 ============================= Follow us on Facebook 👉 https://www.facebook.com/therealpars Follow us on Twitter 👉 https://twitter.com/realpars Follow us on LinkedIn 👉 https://www.linkedin.com/company/realpars Follow us on Instagram 👉 https://www.instagram.com/realparsdotcom #RealPars #mqtt #database