OCS now supports Microsoft Power BI with new connector
As of February 2022, AVEVA Data Hub is the official name for the product formerly known as OSIsoft Cloud Services (OCS).
Many industries use Microsoft® Power BI® to collaborate and share information for enterprise reporting, visual analytics and operations monitoring. Now, users of OSIsoft Cloud Services (OCS), the cloud-native data management platform from the makers of PI System, can automatically flow their contextualized operations data directly into Power BI-based analyses and reports.
We designed the OCS Power BI Connector for the growing number of industrial companies which manage operations through a hybrid approach, bringing together cloud, edge and on-premises technologies. OCS gives you a more complete view of your operations by aggregating data captured at the edge and data captured across multiple on-premises locations to create a centralized, cloud-based data platform.
How OCS can foster operational agility
OCS helps you securely share operations data with diverse user groups, from executives to operations staff. This OCS-supported exchange of real-time data enables users to collaborate more deeply, paving the way for more sophisticated data science applications and more connected workers. Whether delivering real-time insights into manufacturing operations to support OEE initiatives, or aggregating industrial data in the cloud for cross-plant visibility, OCS gives you the operational agility you need to react promptly and intelligently.
As a SaaS platform built on Microsoft Azure®, OCS is easy to use: there’s nothing to build or maintain. Additionally, OCS complements existing or future IT/OT-based enterprise architectures.
Overview and general use cases
OCS Power BI Connector ensures that shared and contextualized PI System or Edge Data Store data is secure and ready for analysis in Microsoft Power BI. The OCS Power BI Connector enables robust operations reporting and data visualization for OCS users.Capabilities include:
- Import OCS Data Views into Microsoft Power BI
- Interpolated and stored data retrieval options
- Supported on Microsoft Power BI Desktop and the Power BI service (through an on-premises data gateway)
- Configure dynamic time ranges for Data Views
Many industries use Microsoft Power BI to collaborate and share information for enterprise reporting, visual analytics and operations monitoring. By delivering the OCS Power BI Connector, we can bring value to people across your organization - from operators and engineers to data scientists and managers.
You won’t need developer skills to configure the OCS Power BI Connector, or coding knowledge to import OCS operations data. Once you’ve imported the data, your team can leverage Microsoft Power BI knowledge to analyze the data.
You can use OCS Power BI Connector to help with data science analysis, remote monitoring and data sharing with trusted third parties.
OCS Data Views
OCS Power BI Connector imports user defined data through OCS Data Views, giving you the flexibility to easily create reports based on how you want to display and analyze your operations data. OCS Data Views represent subsets of data from one or more OCS sources, such as streams and assets, which can serve as a bridge between raw OCS data and data-driven applications like Microsoft Power BI.
How to get started
Current OCS subscribers can start using the Power BI Connector immediately by downloading the install kit found on the Products tab, in their Customer Portal.
Learn more about what OCS can do for you.