ODBC – Open Database Connectivity.
The ODBC interface has been available very early on – successfully establishing connections with various databases. The ODBC standard allows immediate abstraction of the databank system – as well as addressing the database in a generalized manner. In connection with the OPC Router, access to smaller databases can be established easily. To make the connection work, the appropriate ODBC driver for the respective database needs to be installed. For well-known databases, native access ist often more appropriate because of its higher functional scope and its better performance.
Achieve More with Combined Systems
Combining ODBC databases via the OPC Router has several advantages: Important data can be distributed and recorded between various systems, thus creating seamless data streams. Isolated applications or stand-alone systems can be connected via the OPC Router, including the use of the ODBC plug-in, which is a cost-efficient solution for connecting older systems to high-end industry 4.0 systems. This is good news for companies who do not want to invest in complete replacement of older systems, for the time being.
Industry 4.0 for ODBC
Connecting ODBC databases with a wide array of systems opens up many new data usages and data development scopes, bridging current data gaps in order to facilitate industry 4.0 in your industrial plant or enterprise.
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 ODBC plug-in allows access to Tables and Views of the ODBC 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 ODBC Plug-in does not have trigger functions of its own but uses the standard trigger functions of the OPC Router instead.
The ODBC plug-in can browse all available Tables and Views of the connected ODBC database.
Tables and Views
All available tables and views that are accessible to the user can be read out of the ODBC database system. When accessed, columns and types 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.
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.
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.