Extract Historical Data
About this task
Procedure
- Create a regeneration file, specifying the start time, end time, and interval for which you want to capture the historical data. For a sample regeneration file, refer to Example of a Regeneration File.
-
If you want to extract data from Proficy Historian, run the Historian ETL Extract Configuration file located in the Historian ETL Extract folder. If you want to extract data from PI Historian, run the Historian ETL PI Extract Configuration file located in the Historian ETL PI Extract folder.
Tip: You can also enter ETL Historian Extract or ETL PI Extract in Windows Run.The Historian ETL Extract Configuration or the Historian ETL PI Extract Configuration window appears, displaying the Basic Configuration section.
-
Select Advanced Configuration, and then provide values as specified in the following table.
Field Description Default Value Regen File Enter the path to the regeneration file that you have created. <installation folder of Historian ETL>\Regen.xml Catch Up Time Limit Enter the duration, in hours, for which you want to extract historical data. For example, if you want to extract data for the past one day, enter 24. 168 Temp Regen File Enter the path to the temporary regeneration file. <installation folder of Historian ETL>\Temp_Regen.xml Generate Temp Regen File Select True. False - As needed, provide values in the remaining fields for Proficy Historian or PI Historian.