About Extracting Data

You can extract data from one of the following sources:
  • Proficy Historian: This is performed by the Historian ETL Extract tool as follows:
    1. Extracts data related to tags into text files, which are named in the following format: YYYYDDMMHHRR_<onsite Historian computer name>.txt. These files are stored in the following folder: <Historian ETL installation location>/Historian ETL Extract/HistFiles.
      Note: Data related to alarms and events is stored in .lax files. You can choose not to extract data related to alarms and events.
    2. After a specified number of files are extracted (by default, 6), the files are compressed into a .zip file, which is named in the following format: YYYYDDMMHHRR_<onsite Historian computer name>.zip. These files are stored in the following folder: <Historian ETL installation location>/Historian ETL Extract/ZipFiles.
    3. Deletes the text files in the <Historian ETL installation location>/Historian ETL Extract/HistFiles folder after they are compressed.

    Before you extract data using this tool, you must configure this tool.

  • PI Server: This is performed by the Historian ETL PI Extract tool as follows:
    1. Extracts data related to tags into text files, which are named in the following format: YYYYDDMMHHRR_<onsite Historian computer name>.txt. These files are stored in the following folder: <Historian ETL installation location>/Historian ETL PI Extract/HistFiles.
    2. After a specified number of files are extracted (by default, 6), the files are compressed into a .zip file, which is named in the following format: YYYYDDMMHHRR_<onsite Historian computer name>.zip. These files are stored in the following folder: <Historian ETL installation location>/Historian ETL PI Extract/ZipFiles.
    Note: Encryption is not supported by the Historian ETL PI Extract tool.

    Before you extract data using this tool, you must configure this tool.