Good night friends! I'm developing a screen where I need to store data, such as dates and equipment anomalies! I'm thinking of developing with vba, does any one suggest me another alternative, or can you give me a light?
Dear Magno Marinho
As per my understanding, you would like to fetch tag/ equipment data with timestamp and store the results in another database? Is my understanding correct?
If yes, you can explore the option of using PIOLEDB (for PI Data Archive) and PIOLEDB Enterprise (for PI AF) for the same. By using PIOLEDB, PI Server exposes the data in the form of relational database tables. You can write SQL queries for fetching and storing the data on another database of you can directly display the query results on your web page.
Option 1 : PI Integrator for business analytics (Targets & Edition)
Option 2 : PI OLEDB Enterprise (you can use SSIS package to export data from PI To SQL target)
Option 3 : PI AF SDK (custom programming to export data to required target)
Retrieving data ...