1 of 1 people found this helpful
I believe that you may be interested in the PI Integrator for Business Analytics.
To complement Gregor's comment, here is a demonstration video of PI Integrator for BA from the OSIsoft website:
From the video description:
This is a demonstration of the PI Integrator for Business Analytics exporting to Microsoft Power BI, using the Transmission & Distribution industry as an example. To learn more visit http://www.osisoft.com/corporate/busi... . You'll see how you can optimize production, operate equipment efficiently, and avoid damaging events and costly maintenance. This demo illustrates how you can build large, complex data sets with a simple drag and drop user interface with little or no knowledge of the control systems.
This video shows:
the PI Integrator for Business Analytics User Interface
Microsoft Power BI
Multiple ways to achieve this, depends on your skill set, or your team's skill set.
PI ODBC Driver, SQL Server Integration Services
PI Integrator for BA (as Gregor points out)
Write your own utility to extract the data and push into a SQL Server table set.
There is a bit more to it than just accessing the data, normally you need to bash it into shape before consuming it.
PI Integrator for BA does not required you to create a linked server with PI OLEDB Enterprise or PI OLEDB Provider.
It access data through ODBC 64bit Data Source.
Over a year late but others might find this page like I did.
Set up a linked server with OLEBD Enterprise using this guide:
Get Data -> SQL Server
Enter master as the Database
Expand Advanced Options and enter your OPENQUERY query for example:
SELECT * FROM OPENQUERY(LINKEDAF,' SELECT eh.Name + ''.Forecast'' Element, ta.*
FROM [Sandbox].[Asset].[ElementTemplate] et
INNER JOIN [Sandbox].[Asset].[Element] e
ON et.ID = e.ElementTemplateID
INNER JOIN [Sandbox].[Asset].[ElementHierarchy] eh
ON e.ID = eh.ElementID
CROSS APPLY [Sandbox].[DataT].[TransposeArchive_FutureTemplate]
WHERE et.Name = N''FutureTemplate''
ORDER BY Time ASC
OPTION (FORCE ORDER, IGNORE ERRORS, EMBED ERRORS)')
Make sure it works in SSMS first