What is the best way to get data out of PI and into a CSV?
I have a new piece of software that wants a CSV updated every minute with PI data. There are about 1800 PI tags that will need to be pulled., and they are on different scan times. Some will update every 3 minutes up to every second. In the past I have just used Excel to pull in PI tags with Datalink, and save that out to a CSV but we only do that once per day using Windows Task Scheduler. Not on a minute by minute basis. With 1800 tags and the way Excel 365 works with Datalink now this will take longer than 1 minute to extract the data and write the file. Is there a better way to set this up?
The application is Braincube. They have an interface they can setup to the plant system, but with the way our security is setup it'll never get done. Infosec and the admins will never allow it.
Anyone else have experience with this?
