We are getting ready to change over to PI at our mine site and I am trying to figure out best way to migrate legacy Intellution Historian data. Has anyone done this?
Pretty much the standard approach is to dump all the data into excel using SQL queries and then setup the UFL interface to process the data into PI. My company, and others, have developed tools to further automate this process. For example, we develop our utility to read the data directly for the data source and then write it to PI with SDK calls to speed up the process and do error checking. So far that is the fastest approach I have seen and is important if you have a lot of data.
Retrieving data ...