SAP & PI System Integration

If your answer(s) are yes, then don’t worry – you are not alone! A recent survey by Bain & Company shows that more than 30% of industrial companies are concerned about IT/OT integration. Another recent report by McKinsey & Company states that 70% of companies are still in “Pilot Purgatory” mode. Clearly, the implementation of industrial analytics is not a trivial task – whether it’s IT/OT data integration or building machine learning (ML) models for predictive maintenance purpose.

DeepIQ’s DataStudio software is built with one motto – Self Service Analytics for the Industrial World. The application, in the truest sense, offers self service capabilities. You can:

DataStudio’s built-in connectors for industry standard data historians (e.g. Pi System from OSIsoft) enable seamless fetching of time series data, data cleansing, and data preparation for ML model building exercises and real time execution of validated models. Similarly, the wide range of relational data connectors (e.g. SAP-Plant Maintenance) makes the data import a trivial task. The user-friendly, drag-n-drop functionality, coupled with built-in sophisticated mathematical functions, empower you to manage your data at ease – right from merging of multiple data streams to data cleansing, including building supervised and/or unsupervised ML models. The wide choice of classification and regression algorithms, along with numerous switches in each of them to augment the accuracy of your model, ensures that you implement the best ML models for accurate performance predictions.

You can fully leverage Pi System’s Asset Framework (AF) structure to extract the right data at the right frequency for your analysis, and subsequently blend that with the selected columns from maintenance records in SAP-Plant Maintenance (SAP PM) to generate aggregated data sets with appropriate markers for segregating pre-failure, pre-preventive maintenance and post-restart datasets. BAPI based SAP connector simplifies the data extraction task tremendously. These features significantly accelerate your preparation time to start building models to days, instead of weeks or months. If you are already reaping the benefits IT and OT data integration through SAP Manufacturing Intelligence and Integration (SAP MII), then you can increase the returns on your investment (ROI) by adopting the ML module of DataStudio.

DataStudio offers a perfect environment for collaboration between an organization’s entire Digital Team – Data Scientists, Subject Matter Experts and Information and Operations Software Teams. Each persona can perform his/her tasks and contribute to the overall project delivery with maximum efficiency. As the entire data processing step is performed within the application itself, and not in Excel, there is no loss of knowledge and/or information between model building or validation exercises and the real time execution of the analytics model. This and many other functionalities of DataStudio are developed primarily to help Digital Teams manage the change in the organization during the software roll out phase.

Figure 1: Sample Screen of DeepIQ's DataStudio

Use case

Heat exchangers are widely used in multiple industries including oil & gas, chemicals and power. The overall performance efficiency of the heat exchanger depends on multiple components – hot and cold fluid properties, configuration of heat exchanger, preventive maintenance schedule.

Figure 2: Heat exchanger sample use case
Figure 2: Heat exchanger sample use case

It’s not uncommon to collect the real time data of both cold and hot fluids such as flow rates, inlet and outlet temperatures, inlet and outlet pressure, etc. in Pi System. Similarly, the typical maintenance report includes the conditions of shell and tubes, fouling and corrosion locations if any, associated photographs, etc. This valuable information resides in maintenance software such as SAP-PM.

The typical predictive maintenance program is comprised of the following five steps. DataStudio allows your interdisciplinary team to perform their respective tasks swiftly and collaboratively.

After following these five steps, you can get real time alerts on the condition of your heat exchangers and successfully transition from preventive or reactive maintenance to predictive maintenance.

For further information, please contact us at

Download the whitepaper here