Configure the Historian ETL Extract Settings

Before you begin

Complete the prerequisite steps.

About this task

This topic describes how to configure the Historian ETL Extract tool to modify the default folders to store the extracted data, to specify whether data related to alarms and events must be extracted, and so on.
Note: These settings are saved in the HistorianETLExtract.exe.config file.

Procedure

  1. Run the Historian ETL Extract Configuration file located in the Historian ETL Extract folder.
    Tip: You can also enter ETL Historian Extract in Windows Run.
    The Historian ETL Extract Configuration window appears, displaying the Basic Configuration section.
  2. If the configuration details are stored in a file, select Import Config to import the settings. Otherwise, skip to the next step.
  3. Provide values as specified in the following table.
    Field Description Default Value
    Historian Server Enter the host name or IP address of the onsite Historian machine. If you leave it blank, the local host name is considered. Blank
    Historian User Enter the ID of the user to connect to the Historian server on the onsite Historian 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 Historian server on the onsite Historian 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 Extract tool will extract data. You must enter a value greater than or equal to 60. 300 (that is, a text file is created for data that is extracted in 300 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)
  4. 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 Extract/HistFiles
    Tag Configuration File Enter the path to the tag configuration file that you have created. <Installation folder of Historian ETL>/Historian ETL 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 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 Extract tool is stopped. After you apply the settings, the Historian ETL Extract tool creates this file. <Installation folder of Historian ETL>/Historian ETL Extract/State.xml
  5. Select Alarms and Events, and then provide values as specified in the following table.
    Field Description Default Value
    Enable Export Select False if you do not want to extract data related to alarms and events. True
    Enable Alarms Select False if you do not want to extract data related to alarms. True
    Enable Events Select False if you do not want to extract data related to events. True
  6. 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
  7. Select Save.
    The changes to the settings are applied and saved in the HistorianETLExtract.exe.config file.

What to do next

Start the data extraction.