I'm looking for some kind of reference architecture for using the Osisoft BI Business Integrator, AWS and Tools like Power BI,... (how is it usually done) - because just naked json files are not really helpful (and always exporting the full data in one json files is also not a good idea) - what is the "right database" afterwards.
1.) usecase analyse Eventframe data (Trend over certain batch attributes).
- how do you deal with "dynamic attributes" (or 100 different of templates from different sites)
2.) use it for standard trends in power BI. (using AWS as a datastore, so no connection to PI System is necessary).
- Production Trends (AWS IOT Timeseries is still beta,..)
- IOT sitewise would be an option (it supports also the concept of asset hierachy)
(Batch not realtime)
3.) row-asset based exports ...