Workflow for Transferring Data from an ODBC Data Source
To transfer data from an ODBC data source, 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:
|
| 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. |
| 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.