Export data from Historian behind the scene
Hello,
Our process typically takes about 4/6/7 hours to complete, and all the process data were recorded in the historian, we have developed a few axiom dashboards for the process owner to view the status.
We would like to acquire the data for the certain period of time and export them into a csv file whenever the process is completed. However, the time period is not fixed, it depends on what type of product the process is running.
Is there anyway in Canary we can automatically exporting the data between a certain period of time with a trigger of an event? Or is it possible for us to query through the historian to pick the range of the start and end datetime, then we can export them into a csv file.
Please advise.
Thank you,
Yudong
-
Hi yudong. zhang ,
There is nothing that automates this out of the box, but we do make the Events available through the Read API so that you could query them to retrieve the start and end times, then use that for your export. We store our events in a sqlite db by default, but they could be configured to be stored in an external SQL db so that you could query that table instead. (See Storing Events in an External SQL Database)
Print this page