MongoDB Database Plug-In for OPC Router - License type: Subscription license
- OPC Server, OPC Router
- OPC Router data hub
- Plug-In Modules
- MongoDB Database Plug-In for OPC Router
MongoDB Database Plug-In for OPC Router - License type: Subscription license
OPC Router is a software program that allows you to connect data from various industrial devices and IT/OT systems to each other. All this quickly, automatically and without programming knowledge. In addition, you can see all data flows in a clear visualization.
Collect data, connect systems, perform calculations, compare values and enter results into databases. You can do all this with OPC Router for PLC systems, OPC servers, printers, RFID readers, emails, Excel spreadsheets, databases, cloud systems, MQTT brokers, ERP systems SAP R3, SAP HANA, etc. For installation on a single computer you need a basic module and one or more plug-in modules.
Mongo DB Plug-In
The MongoDB database is one of the most widely used NoSQL databases. This document-oriented database is very well suited for distributed use and the processing of large numbers of JSON documents.
With the MongoDB plug-in and other OPC Router plug-ins installed, you can connect MongoDB databases to various other systems across the Industry 4.0 infrastructure. Systems connected to the OPC Router can read/write data from/to these databases.
Storing PLC process data in a MongoDB database via OPC UA
In the picture below, you can see a connection that has been configured to read data from a PLC connected via KEPServerEX. Whenever the temperature changes, the Data change trigger (1) triggers the connection. Data is read from KEPServerEX (2). In the OPC Router, this data is used to generate a JSON document (3), which is then stored in the MongoDB database (4).
In the top of the picture, you can see the live graph (5), which allows for the monitoring and diagnostics of the connection. Each green dot on the line means that the trigger has been activated and that the connection is fault-free.
System requirements
Computer performance
OPC Router is a server application and needs to run on suitably equipped hardware. We recommend using at least the following components:
- Multi-core processor,
- at least 4 GB RAM,
- hard disk space (with RAID 5 technology).
Operating system
We recommend using Microsoft Windows Server operating systems (see below). Client operating systems (64-bit) can also be used for testing purposes.
- Windows Server 2008 x64
- Windows Server 2008 R2 x64
- Windows Server 2012 x64
- Windows Server 2012 R2 x64
- Windows Server 2016 x64
- Windows Server 2019 x64
- Windows 7 x64
- Windows 8 x64
- Windows 8.1 x64
- Windows 10 x64
- Windows 10 IoT x64
Available OPC servers
OPC servers in OPC Router are used to connect control systems and other devices over OPC UA, OPC DA 4.0, or OPC XML.
To connect an OPC server, you must purchase a Module OPC license.
Available database servers
Database servers must be installed separately and are not part of the OPC Router installation. The OPC Router supports the following database systems:
- MS SQL
- Oracle
- MySQL
- MS Access
- XMLdatabases accessible by ODBC
Plug-ins for connecting database systems are not part of the Basic license, but you need to purchase the appropriate plug-in separately.
SAP-Plug in
The SAP Plug-in supports SAP systems version 4.0b and higher. For functionality, you need to have the so-called
SAP Log-on pad installed on the server where the OPC Router is running.
The SAP Plug-in is licensed and is not part of the Basic license.
New features in the OPC Router 5.1 data hub
The new version of OPC Router 5 brings some big changes. The biggest change is the user interface, which brings the user more comfort when working with the program and the ability to work in Linux, macOS, etc. There are also new options for creating user accounts, improvements in application performance optimization and many other improvements.
Highlighted items are mandatory.