I'm face to the following case.
We would like to retrieve data from ou entire SCADA/PCS/DCS/... into OSI-Pi.
For the time series, it will not be complicate because the data willbe stored as OSI-Points.
But the question is what to do with "non time series" data like :
- Audit trails.
- Batch execution data.
- Systems events.
All those data are "table data" with "a lot of columns".
The data could be stored :
- As a Pi-Point with a value = Concatenated data but then it will not be possible to do analtics on the datas.
- In an SQL Table but then the data will not be available in PI-Vision and RTReports (Reporting for pharma companies ...).
Do you have any use case about this ?
Thanks a lot for your answers.