MySQL Plug-in for the OPC Router

Integrating MySQL and MariaDB Database Server into Industry 4.0

The MySQL server is a widely used open source database and MariaDB is the compatible further development. The OPC Router supports the connection of MySQL versions up to version 8. The database servers are accessed natively. With the OPC Router the data exchange between MySQL/MariaDB and various other systems is configurable. The connection between data sources and targets can be created graphically.

MySQL

These and other customers rely on the OPC Router

Volkswagen
tesa
Smurfit Kappa
Vitakraft
frischli
Beiersdorf

Bringing Industry 4.0 to life with MySQL

  • Achieving more with coupled 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 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.

Test the MySQL Plug-in now.

Test OPC Router with the MySQL Plug-in without any obligation and request your free demo now.

Connecting Systems

Transfer-Objects

The transfer object of the MySQL Plug-in allows acces to  Tables and Views inside the MySQL database.

Tables

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.

Views

To access views a Select query is necessary.

Trigger

The MySQL Plug-in does not have a trigger function of its own but uses the standard trigger of the OPC Router.

Browsing

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.

Haven’t found the right information yet?

Here you will find more information on our software as well as an overview of all available OPC Router Plug-ins. We also provide a free demo with which you can test a fully functional version of OPC Router.