Integrating PI System Data with Oracle Portal: Approaches and Considerations

Organizations often need to present process and operational data from OSIsoft PI System within enterprise portals, such as Oracle Portal, to enable broader access and streamline business workflows. In this post, we explore considerations, challenges, and common approaches for integrating PI data into Oracle Portal environments.

Why Integrate PI System Data with Oracle Portal?

Many enterprises use Oracle Portal to provide a unified interface for accessing various business applications and data sources. Integrating real-time and historical PI data into such portals can:

• Enable business users to access operational insight alongside other enterprise data
• Streamline decision-making by reducing the need to switch platforms
• Support dashboards and key performance indicators (KPIs) that rely on process data

Common Integration Methods

1. PI Web API

The PI Web API is a RESTful interface to PI System data and a preferred method for modern web platforms:

• Oracle Portal can use HTTP requests to query the PI Web API and pull live or historical data.
• Data can be embedded into portal pages using AJAX calls, Oracle web services, or custom widgets.

2. OLE DB/ODBC Access

PI System offers PI OLEDB and PI ODBC drivers:

• These drivers allow Oracle Portal or associated reporting tools to query PI data much like relational data sources.
• Useful for creating tabular reports and integrating with Oracle BI tools.

3. PI Integrators and PI to SQL Interfaces

• PI Integrator for Business Analytics or custom interfaces can push data to Oracle databases.
• Oracle Portal then displays the data directly from the Oracle DB, keeping all access within the Oracle ecosystem.

Security and Performance Considerations

• Authentication: Use integrated security or SSO mechanisms to avoid redundant logins.
• Performance: Query only necessary data, and consider data caching for high-frequency requests.
• Access Control: Apply appropriate access rights at the PI System level and within the portal.

Real-World Experiences

While detailed user stories are rare, some companies have successfully linked PI System data to Oracle Portal via web services, REST APIs, or by staging data in Oracle databases. Challenges often relate to authentication, performance, and presenting time-series data in flexible dashboards.

Additional Resources

• Review relevant community posts and documentation for Oracle Portal Web Service integration.
• OSIsoft Learning (now part of AVEVA) provides guides for Web API and ODBC integration.

Conclusion

Presenting PI data within Oracle Portal is achievable and brings multiple business benefits. The best integration method depends on your organization's technical landscape and requirements. Ensuring secure, performant, and maintainable solutions is critical to long-term success.

Have you integrated PI System data into your enterprise portal? Share your experiences or questions in the comments below!