How to provide a direct access to PI Archive Data in Tableau? How can we achieve this goal without storing the data in a separate Database.
Please see PI Integrator for Business Analytics Overview for the recommended approach to integrate PI Data with Tableau. You may be able to utilize PI ODBC Driver instead but the way data usually is stored in the PI System isn't ideal for BI Tools. For this reason, the Integrator performs some data preparation (cleansing and augmentation) which you do not get out of the box with PI ODBC Driver.
Retrieving data ...