2 of 3 people found this helpful
We suggest using PI Integrator for Business Analytics for making PI Data available in Business Intelligence tools because the integrator has been designed especially for this purpose. I recommend watching the following 2 videos.
PI OLEDB Enterprise offers read access to the Asset Framework. PI OLEDB (Classic) provides read / write access to the PI Data Archive. PI SQL DAS is kind of a layer on to of PI OLEDB Enterprise and PI OLEDB Classic that serves clients like PI JDBC and PI ODBC.