MySQL Database Server.
The MySQL Server is a widely used Open Source database, which is supported by the OPC Router via its MySQL plug-in for MySQL versions up to version 5. Native access is provided.
Achieve More with Combined Systems
Combining MySQL with the OPC Router allows easy distrituation and registration of valuable data between systems. Stand-alone systems that were formely disconnected without the possibility of utilizing the data in them, can now be connected and made a part of a cross-connected systems environment.
Industry 4.0 via MySQL
When you connect MySQL servers with other systems in your enterprise, you turn your production into an intelligent, well connected industry 4.0 production environment, allowing for new ways and opportunities to make use of valueable data.
About the OPC Router
The OPC Router offers a visual network configuration interface for successful cross-linking of your systems. A high variety of plug-ins turns the OPC Router into a powerful data hub for industrial applications.
That’s how easy it is.
The transfer object of the MySQL plug-in allows acces to Tables and Views inside the MySQL database.
For tables the following actions are available: Select, Update, Insert and Delete. Once the datasets have been processed, they can be marked by the OPC Router as transferred.
To access views a Select query is necessary.
The MySQL plug-in does not have a trigger function of its own but uses the standard trigger of the OPC Router.
The MySQL plug-in can browse all available objects of the MySQL server.
Tables and Views
The Tables and Views that are accessible to the respective user can be read out from the MySQL server. Thereupon, columns and type can be determined and made available for selection.
How do Transfer Objects, Triggers and Browsing work?
The OPC Router establishes connections between systems that address core functions of the OPC Router.
Functions of the respective plug-ins may vary, due to the different nature of each connected system.