Best way to add historical data to tag created with OPC DA?

Question

Hello all,

I have quite a few tags that were created years ago, and have been gathering data since.

I would like to add new tags using the same interface (OPC DA) and same source (Foxboro/AIM Historian), but the trouble is that they'll only get data from today forward, even though there are many years worth of data in the historian the interface is pulling from.

Now that I have a tag created and collecting data, how can I backfill.

I've thought of OPC HDA, or mass export and import with UFL. Is there any other option?

Can I even have OPC HDA writing to a tag that was created with OPC DA? Same for UFL.

Thanks for any insight.

Christoph Rose · Accepted Answer

The best option for importing large amounts of historical data is to use UFL. It is no problem to write into a tag with UFL that was created with opc da. It might require you to have the Buffering subsystem running on the computer running the UFL Interface.

Note that because you are going to be writing out of order data, that no exception or compression testing will be done. Every value you send via UFL will be stored.

Best way to add historical data to tag created with OPC DA?

Top Replies