Access is a useful small Microsoft database. The database is used in office settings as well as for smaller system setups. More demanding applications are not suitable for Access because of lack of multiple user profiles and a limited performance scope. The OPC Router connects Access databases to other systems within the higher system architecture of any company.
Achieve More with Combined Systems
Combining Access databases via the OPC Router has several advantages: Important data can be distributed and recorded between various high-performant systems. Moreover, insular system solutions or stand-alone systems can be connected via the OPC Router, including crosslinking various enterprise systems in your interconnected production plants whilst also making the best possible use of the available data in the Access database.
Industry 4.0 for Access
Data from small access-based applications often contain valuable data. With the OPC Router you can also integrate this data into your industry 4.0-structure.
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.
Easy configuration, sophisticated monitoring and robustness are main distinguishing features of the OPC Router.
That’s how easy it is.
The transfer object of the Microsoft Access plug-in allows access to Tables and Views in the Access database. The Access database is a data file.
The Microsoft Access plug-in does not have its own triggers and therefore works with the standard triggers of the OPC router.
The Microsoft Access Plug-in can browse the available tables and views from the Access database.
Tables and Views
All tables and views can be accessed by the user are read from the database system. The columns and their types are 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.
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.
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.