SAP HANA DB Plug-In for OPC Router - License type: Subscription license

SAP HANA DB Plug-in
SAP HANA DB Plug-in

SAP HANA DB Plug-In for OPC Router - License type: Subscription license


This OPC Router plug-in allows you to access the SAP HANA database and read/write data from/to it. You can also change data and call stored procedures. The plug-in is an OPC Router accessory. More

Manufacturer: Inray Code: OPCR-SAPHAN-SUB-PROD

880 EUR excl. VAT (1 064,80 EUR incl. VAT)
Variant does not exist

In stock
pcs

This OPC Router plug-in allows you to access the SAP HANA database and read/write data from/to it. You can also change data and call stored procedures. The plug-in is an OPC Router accessory. More

Manufacturer: Inray Code: OPCR-SAPHAN-SUB-PROD

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.

SAP HANA DB - OPC Router Plug-In

With HANA, SAP has created a development platform for Big Data applications and provides a high-performance in-memory database. The relational database in SAP HANA stores all data in the working memory and can therefore guarantee optimal access times to large amounts of data.

The SAP HANA database is not only designed for applications with SAP, but can also be used for various high-performance database applications.

With the SAP HANA plug-in of the OPC Router, connections to the HANA database can be configured graphically. With this plug-in, the OPC Router can write data to the database, change data, read from it and call procedures in SAP HANA.

Calling a SAP HANA procedure

In the picture below, you can see a connection that has been configured to read data from an OPC UA server and store it as parameters in a SAP HANA stored procedure. The procedure returns values, which are then written back to the OPC UA server.

Whenever the PalletID changes, the Data change trigger (1) triggers the connection. Using the OPC UA/DA object (2), the PalletID, the PalletWeight and the PalletHeight are read out from the OPC UA server and, using the Database object, sent to the SAP HANA stored procedure (3). The procedure returns values, which are then written back to the OPC UA server using the OPC UA/DA object (4).

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.