Configure Historian ETL PI Extract Settings
Before you begin
About this task
This topic describes how to configure the Historian ETL PI Extract tool to modify the default folders to store the extracted data.
Note: These settings are saved in the PIHistorianETLExtract.exe.config file.
Procedure
- Run the Historian ETL PI Extract Configuration file located in the Historian ETL PI Extract folder.
Tip: You can also enter ETL PI Extract in Windows Run.The Historian ETL PI Extract Configuration window appears, displaying the Basic Configuration section.
- If the configuration details are stored in a file, select Import Config to import the settings. Otherwise, skip to the next step.
- Provide values as specified in the following table.
Field Description Default Value Historian Server Enter the host name or IP address of the PI Server machine. Blank Historian User Enter the ID of the user to connect to the PI Server machine. A value is required only if security is enabled for the Historian server. Blank Historian Password Enter the password of the user to connect to the PI Server machine. A value is required only if security is enabled for the Historian server. Blank Unit ID Enter the unit ID of the machine from which you want to transfer data. OSMName Run Interval Enter the interval, in seconds, at which the Historian ETL PI Extract tool will extract data. You must enter a value greater than or equal to 60. 150 (that is, a text file is created for data that is extracted in 150 seconds) Min # of Files to Compress Enter the number of files that must be compressed into a single .zip file. 6 (that is, a .zip file is created for every six text files) - Select Files, and then provide values as specified in the following table.
Field Description Default Value Historian Export Path Enter the path to the folder in which the text files containing the extracted data must be stored. <Installation folder of Historian ETL>/Historian ETL PI Extract/HistFiles Tag Configuration File Enter the path to the tag configuration file that you have created. <Installation folder of Historian ETL>/Historian ETL PI Extract/OSM_OSMName.xml Zip Export Path Enter the path to the folder in which the compressed files must be stored. <Installation folder of Historian ETL>/Historian ETL PI Extract/ZipFiles State File Enter the path to the file that contains the timestamp of the last successful export. This file is updated each time .zip files are transferred to the destination Historian server or when the Historian ETL PI Extract tool is stopped. After you apply the settings, the Historian ETL PI Extract tool creates this file. <Installation folder of Historian ETL>/Historian ETL PI Extract/State.xml - Select Advanced Configuration, and then provide values as specified in the following table.
Field Description Default Value Log Level Enter the log level to indicate the amount of information to be logged. A value of 1 indicates the least information and 5 indicates the highest level of information. 1 Catch Up Interval Enter the catch up interval, in minutes, used to size files when catching up to the current time. 10 Regen File Enter the path to the regeneration file. <installation folder of Historian ETL>\Regen.xml Save Limit Enter the number of files to be exported after which the State.xml file must be updated. 20 Catch Up Time Limit Enter the maximum time, in hours, to go back when catching up after a restart. 168 Delay Interval The duration, in seconds, by which the data retrieval time will be reduced. For example, if data will be retrieved for 10 minutes, and if you enter 60 in this field, data for the last 60 seconds will not be retrieved in that batch; it will be retrieved in the next batch. This will ensure the retrieval of any dynamic records that were updated in that duration. 60 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 if you want to generate the temporary regeneration file. False - Select Save.The changes to the settings are applied and saved in the PIHistorianETLExtract.exe.config file.