1 of 1 people found this helpful
Hello Jaco. Best approach is using the PI Integrator for business analytics. Business Intelligence This product shapes PI data (AF) into time-series tabular form for egress to SQL. And does the rollups you need.
As mentioned by @Steve Edwards, PI Integrator for business analytics does the job as per your requirement. If you are having small dataset then you can use Microsoft SSIS to get data from PI OLEDB Enterprise(AF) to SQL server or AF SDK to get data from PI server and write to SQL tables as per your requirement.
PI Integrator for BA seems to be the right tool at the first sight. But I would also check to see if you can make a use of data retrieval method of AF server feature.
For more information, please see below: