SAP HANA®

SAP HANA® Database Connection

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.

The procedure for connecting external applications to SAP HANA® is very similar to other relational databases. With the SAP HANA® plug-in of the OPC router, connections to the HANA database can be configured graphically. With its plug-in, the OPC Router can write data to the database, change data, read from it and call procedures in SAP HANA®. These options, in combination with the other available plug-ins, make it easy to quickly integrate us into the SAP HANA® infrastructure.

Example of a SAP HANA® connection:

Example for a query of data from SAP HANA In-Memory database for a PLC process

Achieving more with coupled systems

By coupling the SAP HANA® database with the OPC Router, you can insert and retrieve data from the high-performance SAP® in-memory database. This provides for the coupled systems fast access to database query results for large amounts of data. Big Data can therefore also be used directly by subsystems.

Industrie 4.0 with SAP HANA®

In industry 4.0, systems are networked in the best possible way and live from the mutual exchange of data among each other. With the integration of SAP HANA® into Industry 4.0, systems can make even better process decisions and optimize themselves with the help of Big Data.

About OPC Router

With the OPC Router you realize the networking of your systems in a graphical way. Numerous plug-ins enable it to be used as middleware in industrial environments.

Simple configuration, sophisticated monitoring and robustness characterize it.

Connecting Systems

It can be that simple.

Transfer-Objects

The transfer object of the SAP HANA® plug-in allows access to tables, views and procedures of the SAP HANA® database.

Tables

Select, Update, Insert and Delete actions are available for the tables.

Views

The access to views is done exclusively as a select query.

Procedures

When accessing a procedure, the OPC Router carries out an Execute. Input parameters can be passed, as well as a call result and the return parameters (also results) can be read back.

Trigger

The SAP HANA® plug-in includes a HANA database trigger.

Database-Trigger

The database trigger checks a column of a table for changes. The OPC Router triggers the connection in case of changes. The database trigger does not have any outgoing data fields.

Browsing

The SAP HANA® plug-in can browse the available objects from the SAP HANA® database.

Tables and Views

All accessible tables and views for the user are read from the SAP HANA® database. Then the columns and their types are determined and made available for selection.

Procedures

The available procedures are also read out. For each procedure, the input and output parameters are read out and made available for selection, including the type specification. The obligatory return value is provided automatically.

Application-Examples for SAP HANA® Pug-in

Providing Big Data applications with data

The SAP HANA® database is perfect for Big Data applications due to its in-memory structure. With OPC Router it is possible to supply them with necessary data. The connection is made simply in the graphical connection editor. Data can be obtained from various plug-ins of OPC Router and transferred to in-memory database. A classic data memory in production is the MS SQL database. With the SQL Server plug-in, data can be obtained from tables, views or preprocessed from stored procedures and transferred to SAP HANA®.

MS SQL Server
OPC UA Client / OPC DA Client
MS SQL Server

Controlling PLC with Big Data

For the connection and data exchange with other systems OPC Router uses only the graphical designer. After the connection parameters of the database have been announced and tested, the database objects can be searched and selected. In the connections the data transfers between an external system (SAP, MQTT, OPC, REST, etc.) and the SQL Server are established. Once the project has been published, all data transfers can be checked and viewed in the graphical monitoring system.

More Plug-ins

What are transfer objects, triggers and browsing?

The connections in OPC Router for networking systems can be established with these core functions of the OPC Router.
Depending on the Plug-in, the functions have different characteristics, depending on the functionality of the connected system.

Transfer-Objects

Sources and objectives

Transfer objects are the sources and destinations of data transfer within the connections. Each transfer object has data fields from which data can be read or written. The way in which transfer objects are configured depends strongly on the systems whose data they provide.

Uniform outside, individual inside

In OPC Router configuration, the transfer object abstracts the specialties of the respective system into a simple data input/output block.

Trigger

Trigger of connections

Triggers determine the time when connections are executed. Any trigger can be used in the connections, regardless of the type of transfer object. Several triggers can be used per connection, which work together either in an AND-operation or in an OR-operation. Triggers can also serve as data sources if the triggering event is associated with the reception of data.

Browsing

Search and find data fields

The configuration of data fields required in the transfer objects to establish the connection is simplified by browsing. Depending on the system/plug-in type, different browsing mechanism are available.

Reading structures

In many plug-ins comfortable browsing is available, so that finding and selecting the desired data fields is very easy and requires very little detailed knowledge about the subsystem. The plug-ins present the structures of the data sources in a plug-in-specific way.

2019-08-13T11:02:57+01:00