Workflow for Transferring Data from Proficy Historian

To transfer data from Proficy Historian, you must perform the following steps.
Step Number Description Notes
1 Install Historian ETL. This step is required. You must install ETL on both the source and destination machines of the data transfer.
Note: If you want to upgrade ETL:
  1. Uninstall the existing version of ETL.
  2. Backup the configuration files, and delete them.
  3. Install the latest version of ETL.
2 Specify the tags and tables whose data you want to extract. You can do so manually, using a template, or using a blank spreadsheet. This step is required. It involves providing a list of tags whose data you want to extract and the tables from which you want to extract data.
3 Configure the extract settings. This step is required. It involves providing the .xml files that contain the tags list and the tables list, along with other parameters. You can also extract alarms and events data.
4 Start the data extraction. This step is required. It involves extracting tag data and compressing it so that it can be transferred to the destination Historian server.
5 Transfer the data using BITS, FTP, or any other file-sharing application. This step is required. It involves setting up the file-sharing application that you want to use and then transferring the data to the machine on which the destination Historian server is installed.
6 Load the data into the destination Historian server. This step is optional. It involves extracting the .zip files transferred by the file-sharing application and then loading the data into the destination Historian server.
Note: Depending on the use case, you can use these tools independently or together.