Data integration

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.

PI Integrators diagram - base image
PI Integrators diagram - cleanse
PI Integrators diagram - shape
PI Integrators diagram - transmit

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.

See how our customers use PI Integrators


How Newcrest Mining increased throughput and decreased downtime 50%

person in brewery by silver tank
Food & Beverage

Deschutes Brewery improved quality and postponed an $8 million capital upgrade

Person in cherry picker servicing electrical
Power & Utilities

Genesis Energy predicted 50 operating problems with machine learning and Power BI

person in lab coat working in pharma lab

Pfizer improved compliance reporting, productivity, and product quality

Learn more about data integration with the PI System


Enable advanced analytics with PI Integrators


Merge OT and IT data with PI Integrator for Business Analytics


Seeing is believing: watch an ArcGIS demo specific to your industry

Talk to us

Twenty four of our first 25 customers still use our platform. How will you tap the power of the PI System?

Request a demo

Get a walkthrough with one of our experts and see how the PI System can help you.

©2022 OSIsoft, LLC