PostgreSQL Plug-In for OPC Router - License type: Subscription license for 1 year

OPC Router is a software program that allows you to interconnect data from different industrial devices and IT/OT systems. With OPC Router, you can do all of this quickly, automatically and without any programming knowledge. In addition, you can see all data flows in a clear visualisation.  

Collect data, connect systems, perform calculations, compare values and store results in databases. With OPC Router, you can do all this for PLC systems, OPC servers, printers, RFID readers, emails, Excel spreadsheets, databases, cloud systems, MQTT brokers, SAP R3, SAP HANA, etc. For installation on a single computer you need the Base Module and one or more plug-in modules. 

PostgreSQL Plug-In

The PostgreSQL database is an open source relational database renowned for its reliability, performance and scalability. 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 small applications as well as large enterprise systems.  

OPC Router plug-ins allow you to connect a wide range of industrial infrastructure systems. With the PostgreSQL plug-in, you can send data directly to the PostgreSQL database and, using additional plug-ins, make it available to different applications and systems for analysis or reporting.

How to Use the PostgreSQL Plug-In: An Example

Connecting to the PostgreSQL database using the OPC Router software is easy, intuitive and fast thanks to its drag and drop functionality. This screenshot illustrates a specific example of this connection. Try it for free with the trial version of OPC Router.

Are you wondering why PostgreSQL is so popular?

It is one of the most powerful and advanced databases on the market today. Let's summarise its main features:

1. Open source and free: PostgreSQL is distributed under an open source licence, which means that it is free to use and can be customised according to the user's needs.
2. Scalability: PostgreSQL is highly scalable and allows users to create custom data types, functions and procedures, making it a flexible solution for a wide range of needs.
3. Reliability: PostgreSQL is known for its high reliability and fault tolerance. It provides advanced backup, recovery and replication mechanisms to minimise the risk of data loss.
4. Support for ACID properties: PostgreSQL provides full support for ACID (Atomicity, Consistency, Isolation, Durability) properties, ensuring consistency and reliability of transactions.
5. Rich 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.
6. Active community and support: PostgreSQL has a large and active community of users and developers, which means it is well supported, with lots of documentation, tutorials and resources available.

Overall, PostgreSQL is a popular choice for organisations and developers due to its high reliability, scalability and broad functionality.