I want to fetch data from OSI Pi for my Pentaho Dashboard reports. How to do it. My Pentaho server is installed on Ubuntu 14 LTE. How to do it?
What kind of data source can the Pentaho tool consume? Depending on the compatibility of the Pentaho tool, different data access options to PI can be available.
A few options that come to mind:
If you can give us additional information about the data access options for the Pentaho system, we will be able to provide further suggestions. Perhaps other community members that have used the Pentaho system can chime in as well.
PI Integrator for Business Analytics presents PI System data perfectly suited to business intelligence tools including but not limited to Tableau, Tibco Spotfire, QlikView, and Microsoft Power BI for reporting and analytics. Business Intelligence (BI) client tools offer the ability to run retrospective analyses on a much larger set of your real-time PI System data. BI helps you learn from operational behaviors and patterns, identifying dependencies and correlations of various factors within your operations.
Native time series data, asset context, and event context are exposed through web-configured PI Views and can be accessed using a standard ODBC connection. Data are perfectly dimensionally modeled, cleansed, and presented with appropriate metadata so that BI tools can properly browse, query, and consume PI System data seamlessly. Data can also be directly integrated and loaded into data warehouse platforms. PI Integrator for Business Analytics eliminates the need for programming or SQL expertise and manages the complete data lifecycle, including access, updates, and data provenance.
Retrieving data ...