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.
These and other customers rely on the OPC Router
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.
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.