Accelerate operational insight by formatting your PI Server data for fast, easy, and native integration into cloud platforms, advanced analytics, relational databases, geographic information systems, and business intelligence tools.
How PI Integrators work
PI Integrators wrangle and format complex datasets so that you don’t have to.
- Cleanse outliers and uneven data points
You have thousands of sensor readings that stream into your PI Server. Clean up the data from physical systems that comes with occasional outliers, different timestamps, communications gaps, and other imperfections.
- Shape and augment raw sensor data
Transform all the mismatched and offset timestamps into a neat table— formatted, interpolated and ready for consumption by business intelligence and machine learning tools.
Pull relevant information from Asset Framework, such as manufacturer or operating contractor, to identify the key factors that impact performance.
- Transmit analysis-ready data to BI tools and machine learning algorithms
Set and forget it. As new data from your sensors arrives, PI Integrators push fresh data to your tools. You’re always working with the latest data.
Data integration technologies
Data scientists sometimes joke that they are “data janitors,” because they spend up to 80% of their time gathering and cleaning data. It’s not surprising that many analytics programs take a year or more to deliver results.
It doesn’t have to be this way. Spend less time wrangling and formatting raw data and more time running advanced analytics. PI System data integration products reduce the burden of data preparation so you achieve business insights faster.
- PI Integrator for Business Analytics
PI Integrator for Business Analytics provides a drag-and-drop interface so you can select, cleanse, and shape data for analysis. Transform raw sensor readings into data formatted in rows and columns, ready for relational databases and cloud database platforms such as AWS, Google Cloud Platform, or Microsoft Azure. Merge operations data with other business data for deeper insight.
PI Integrators let you analyze operations data using familiar tools such as IBM Cognos, Oracle Analytics, Power BI, Qlik, SAP BI, Sisense, Tableau, TIBCO Spotfire, or any tool that accesses data using Open Database Connectivity (ODBC) or SQL standards.
With faster access to operations data, your analysts can:
- Identify opportunities to increase production and reduce operating costs
- Prepare compliance and regulatory reports
- Run predictive analytics
- Integrate operations data with other business data
- PI Integrator for Esri ArcGIS
PI Integrator for Esri ArcGIS brings your maps to life by combining real-time operations data with visualization and geo-analytics. Data from sensors, control systems, and calculations enhances GIS analysis, providing up-to-the-minute status information for real-time situational awareness.
Every asset that generates data about temperature, pressure, and speed also has another data point: location. Combine this data in one display to help:
- Maintenance engineers react to alarms using map-based navigation
- Field technicians receive real-time proximity alerts as they approach assets
- Operations engineers compare conditions across geography
- Planners analyze where to deploy new assets and decommission existing ones
Data integration in action
The city of Riverside will save $3 million over five years
with smart city dashboards.