Data Exchange

Total: ~25 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.

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.