SQLite is a program library in the public domain, which contains a relational database system. SQLite supports a wide range of SQL voice commands for the SQL92-standard. SQLite is an embedded SQL database engine that provides direct data access.
Achieve More with Combined Systems
Combining SQLite with the OPC Router allows distribution and processing of valuable data between systems. This elimiates stand-alone or island systems because they are turned into cross-connected systems in an industry 4.0 environment. SQLite can be used powerfully in such contexts.
Industry 4.0 for SQLite
Data contained in SQLite,-bases applications often provide valuable information. The OPC Router ensures that your SQLite-based data is made available within your industry 4.0 infrastructure.
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 SQLite plug-in gives access to Tables, and Views available in the SQLite database. The SQLite database is a file.
The SQLite Plug-in does not have a trigger function of its own but uses that of the OPC Router.
The SQLite plug-in makes use of available Tables and Views in the SQLite database.
Tables and Views
The user can make use of all tables and views that can be accessed in the SQLite database. Once they have been accessed, columns and their respective types can be selected.
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.