Analyzing Sensor Data in SAP HANA in Real Time

  • by Dominik Schrank, Senior Consultant, SAP Deutschland SE & Co. KG
  • June 7, 2017
The following solution design for applications allows for the combination of real-time sensor data with data from other sources within SAP HANA. The architecture is based on the SAP Manufacturing Integration and Intelligence (SAP MII) and SAP Plant Connectivity technologies. This flexible architecture enables the consumption of data from any system that collects sensor data and supports the OPC Unified Architecture (OPC-UA) industrial communication standard.

Learning Objectives

Reading this article, you will learn:

  • The architectural concepts and characteristics of consuming and analyzing sensor data in SAP HANA via SAP Manufacturing Integration and Intelligence (SAP MII) and SAP Plant Connectivity
  • The solution design and configuration steps to connect SAP HANA to systems that collect sensor data and support the OPC Unified Architecture (OPC-UA) communication standard
  • Step-by-step instructions to connect SAP HANA to an OSIsoft PI system
  • How to build SAP HANA calculation views that combine different types of sensor data with information from other sources
Key Concept

Internet of Things (IoT) technologies provide new opportunities for organizations to collect and analyze data from sensor devices. Flexible software solutions facilitate the information retrieval from systems that support common communication standards and thus enable great insight into operational data.

Businesses including pharmaceutical, oil and gas, and industrial, just to name a few, leverage the OPC Unified Architecture (OPC-UA) industrial communication standard to facilitate machine-to-machine communication between industrial equipment and systems that collect data. 

OPC-UA is a cross-platform standard that is freely available. The concept is based on a service-oriented architecture. This standard is developed by the OPC Foundation. The SAP Plant Connectivity solution allows you to connect to systems that support the OPC-UA standard. The architecture described in this article is applicable for systems that support the OPC-UA communication standard. This makes the concept very flexible and sets the basis for the implementation of advanced analytics use cases. The connectivity to an OSIsoft PI system is highlighted to demonstrate one use case. More details on the OPC-UA standard can be found on the OPC Foundation’s website: https://opcfoundation.org/about/opc-technologies/opc-ua/.

I examine the architectural concepts and characteristics for using sensor data in SAP HANA. As an example, I highlight the real-time connectivity to an OSIsoft PI system in SAP HANA without persisting this data. The required configuration steps in the SAP solutions are revealed, and options to build SAP HANA calculation views that consume sensor data as well as data that is already available in SAP HANA are discussed. 

Dominik Schrank

Dominik Schrank is a senior consultant for Business Intelligence solutions at SAP Deutschland SE & Co. KG. He has comprehensive experience in designing and implementing large business analytics applications based on the SAP HANA-, SAP BusinessObjects BI-, and the SAP HANA Cloud Platform- solution portfolio for global customers.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.