Data Exchange

Total: ~35 min

Few applications will expect all of the data to remain in a single repository, so you will commonly need to think about how to exchange this data with other systems. Hyper Historian includes several connectors that allow for interchange of data with third-party applications over multiple protocols.

SQL Query Engine

The Historian stores data in a binary flat file for efficiency and performance, but it is still accessible as a relational database through they SQL Query Engine.

SQL Query Engine in Stored Procedures

The SQL Query Engine includes a robust list of queries that can be used upon the Historian, opening up the options for how to efficiently access your data.

Export to CSV with Historian Reader

The Historian Reader is a simple to use program that allows for direct export of historical data for a given data point and time range. It will export the data to a CSV file.

Export to SQL with Data Exporter

Certain situations, such as sharing data to third-party systems or providing structured data exports, will call for exporting data logged in the Historian out to a SQL table. The Historian Reader module can help.

Import from CSV with MergeWorX

The Data Historian comes equipped with the MergeWorX module, which allows for direct import of data into the Process Data Historian  as an alternative to a tag subscription method of data storage. The most common application for MergeWorX is to process and import data from CSV files into the Historian.

Import Edgecross Files with MergeWorX

Edgecross files are efficient CSV datasets which can be merged automatically into the Data Historian. We explain the data format and the configuration of the MergeWorX service.

Archiving

The Data Historian supports data archiving, allowing you to periodically migrate batches of historical data to a separate disk location. This data can still be accessed and used within the primary Historian application.

Use Aliases in Data Exporter

Parameterization through the use of aliases allows for greater flexibility in the configuration of Historian data exporters. It allows for creative re-use of configurations to improve the scalability of your design.