Oracle Plug-in

Oracle DB Client

The Oracle database is a top-performing database for manifold business applications. Via OPC Router a native connection can be established by using the respective Oracle client driver and TNS. You can find a dedicated video about the topic “connection of database systems” by visiting our tutorial stream.

Oracle DB Client

These and other customers rely on the OPC Router

Volkswagen
tesa
Smurfit Kappa
Vitakraft
frischli
Beiersdorf

Bringing Industry 4.0 to life with Oracle

  • Achieving more with coupled 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 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.

Test the Oracle Plug-in now.

Test OPC Router with the Oracle Plug-in without any obligation and request your free demo now.

Connecting Systems with the OPC Router OPC UA Client Plug-in

Transfer-Objects

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

Tables

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.

Views

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

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.

Browsing

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.

Haven’t found the right information yet?

Here you will find more information on our software as well as an overview of all available OPC Router Plug-ins. We also provide a free demo with which you can test a fully functional version of OPC Router.