Skip to main content

HT-EX

Functionality of HT-EX​

This project is also known as Extractor. It take data from a variety of sources ODBC, SQLite... and extracts the data into a format that the Transformer can understand aka SQLite.

Solution and Projects​

HT-EX solution is named ScadaExtractor.sln. This solution contains 2 projects called ScadaExtractor.csproj and HTLogger.csproj.

From a clean pull you will need to do the following:

  • Right Click on the ScadaExtractor project and go to properties.
  • Go to debug.
  • Add a command line argument to the config.toml file.
  • Save the configuration.
  • NOTE: Make sure there are no spaces in any of the folder names.

To change the network or modify the run change the config.toml file in the ScadaExtractor project.

Files used to Test HT-EX​

Input Files​

  • Historian.db3 - This will have one table called tblScadaTagRawData.

Output Files​

  • Extracted.db3 - This will have several tables.

Questions to go over with Jake:​

We have switched over to config.toml do we still need to keep around the App.config?

Last updated on by jacobgqc