Oracle DB Client

Oracle Database.

The Oracle database is a top-performing database for manifold business applications. via Via the OPC Router a native connection can be established by using the respective Oracle client driver and TNS.

Achieve More with Combined Systems

Combining Oracle via the OPC Router has several advantages: Important data can be distributed and recorded between various high-performant systems.  Moreover, insular system solutions or stand-alone systems can be connected via the OPC Router, including crosslinking various enterprise systems in your interconnected production plants whilst making use of the powerful Oracle database.

Industry 4.0 via Oracle

Interlinking your Oracle database with other systems in your enterprise architecture (EA), opens up many possible data usages and data development opportunities for better organization of information, data and dataflows toward a successful implementation of industry 4.0 for your entire business.

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.

Combining Systems

That’s how easy it is.

Transfer Objects

The transfer objekt of the Oracle plug-ins gives access to Tables, Views and
Stored Procedures  of the Oracle database system.


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.

Stored Procedure

Upon access to any given Stored Procedure, the OPC Router carries out an Execute, which can include tranferring input parameters and reading back call results or return parameters.

Trigger Functions

Oracle has a database trigger.

Datenbase Triggers

The database trigger checks any table’s column for changes. The OPC Router triggers a connection when a change occurs.


The Oracle plug-in can browse all available objects of the Oracle database.

Tables and Views

The Tables and Views that are accessible to the respective user can be read out from the Oracle database. Thereupon, columns and types can be determined and made available for selection.

Stored Procedures

Any given accessible Stored Procedures can be read out. Per procedure, input and output parameters are read out and made available for selection –  including type information. Return values are generated automatically.

More Plug-ins

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.

Run a free test now

Transfer Objects

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.

Trigger Functions

Prompting Connections

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.