I have a few questions regarding Ignition’s Historian:
- Is the best way to collect the factory’s historical data by manually configuring each tag and Enabling its History option and selecting the desired DB as the storage provider?
- The structure of the DB is documented here: https://docs.inductiveautomation.com/display/SE/Tag+History+Tables+Reference
I would like to use this DB only for short-term trending.
Any advice on how to dump this DB into another Historical DB that can be used by other applications?
- When do you recommend to use the Ignition Modules “Tag Historian” vs “SQL Bridge”? From what I saw on the forums, SQL Bridge is particularly good for PLC to DB hand-shakes, such as load recipe.
- To work with the raw historical data, any advice on techniques for partitioning and storing the data, so it can be easier to use it afterwards for other applications?