PostgreSQL Plug-in for OPC Router - License type: Subscription license 1 year
- OPC Server, OPC Router
- OPC Router data hub
- Plug-In Modules
- PostgreSQL Plug-in for OPC Router
PostgreSQL Plug-in for OPC Router - License type: Subscription license 1 year
Variants2
License type | Availability | Code | Price excl. VAT | |
---|---|---|---|---|
Subscription license 1 year | In stock | OPCR-PGSQL0-SUB-PROD | 450 EUR | |
Perpetual license | In stock | OPCR-PGSQL0-PRP-PROD | 779 EUR |
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.
PostgreSQL plug-in
The PostgreSQL database is an open-source relational database that is known for its reliability, performance and extensibility. It has the advantage of combining the classic table structure of relational databases (such as SQL Server) with a more flexible object-oriented database. PostgreSQL allows developers to efficiently manage complex data structures and is suitable for both small applications and large enterprise systems.
With OPC Router plug-ins, you can connect a variety of industrial infrastructure systems together. With the PostgreSQL plug-in, you can send data directly to the PostgreSQL database and make it available to various applications and systems for analysis or reporting using additional plug-ins.
Connection example
Connecting to the PostgreSQL database using the OPC Router software is simple, intuitive and fast thanks to the drag & drop function. The screenshot illustrates a specific example of this connection.
Why is PostgreSQL so popular?
It is one of the most powerful and advanced on the market. Let's summarize the main features:
- Open-source and free: PostgreSQL is distributed under an open-source license, which means it is free to use and can be customized to suit the user's needs.
- Extensibility: PostgreSQL is highly extensible and allows users to create custom data types, functions and procedures, making it a flexible solution for a wide range of needs.
- High reliability: PostgreSQL is known for its high reliability and fault tolerance. It offers advanced data backup, recovery and replication mechanisms to minimize the risk of data loss.
- Support for ACID properties: PostgreSQL provides full support for ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring consistency and reliability of transactions.
- Extensive functionality: PostgreSQL offers a wide range of advanced features and capabilities, including support for a variety of data types, geographic data types, full support for working with text and XML, and much more.
- Active community and support.
Overall, PostgreSQL is a popular choice for organizations and developers due to its high reliability, extensibility, and broad functionality.
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.