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.

Combining Systems

That’s how easy it is.

Transfer Objects

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.

Trigger Functions

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.

More Plug-ins

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.

Run a free test now

Transfer Objects

Sources and Destinations

Transfer objects are the sources and destinations inside the OPC Router. They contain data fields with read and write functions. Depending on the respective interconnected system, the possible configuration scope of sources and destinations may vary.

Homegeinity on the Outside – Heterogeinity on the Inside 

Inside the OPC Router configuration, the transfer object abstracts the respective system of any connected system into a simple data input and data output block. Thus, the functions can be treated in the same way although each connected system has very individual features.

Trigger Functions

Prompting Connections

Triggers determine execution time of data connections. Various triggers can be used for these connections, independent of transfer object type.  Within each connection, several triggers can be used together via AND/OR-connections.
Triggers can also be useful as data sources if the prompting event is combined with data reception.


Searching and Finding Data Fields

Easy browsing also makes data field configuration easy when establishing transfer objects in order to establish the respective interface connection. The browsing mechanisms may vary, depending on the system and its available plug-in. 

Reading out Structures

Many plug-ins that are available for the OPC Router offer easy search and selection tools for quick identification of respective data fields without the need for specific knowledge about inherent subsystems. The user can easily browse through the data. Data source structures may vary according to the specification of each respective plug-in.