All Units

Introduction 

  1. Architecture

Core Concepts 

  1. Installation
  2. Configuration

Data Connectivity 

  1. Basics
  2. Mitsubishi Electric FA
  3. OPC Classic
  4. OPC UA
  5. DeviceXPlorer
  6. SNMP
  7. Modbus
  8. Web Services
  9. Databases
  10. Other Connectivity Options

Dashboard Visualization 

  1. Basics
  2. Symbols
  3. Commanding
  4. Navigation
  5. Aliasing
  6. Asset Navigator
  7. Alarm Viewer
  8. Grid Viewer
  9. Trend Viewer
  10. Recipes
  11. Schedules
  12. Fault Viewer
  13. Camera Integration
  14. Helper Controls
  15. Advanced Controls
  16. 3D Graphics
  17. Security
  18. Cloning

Clients 

  1. Basics
  2. Desktop Deployment
  3. Web Browser Deployment
  4. Mobile Deployment
  5. KPI Self-Service Dashboard

Data Historian 

  1. Basics
  2. Visualization
  3. Calculations
  4. Data Exchange
  5. Advanced Architectures

Asset Organization 

  1. Basics
  2. Defining Assets
  3. Commanding
  4. Asset Templates
  5. Visualization
  6. Bulk Asset Configuration
  7. Advanced Topics

Alarming & Notifications 

  1. Basics
  2. Hyper Alarm Server
  3. Hyper Alarm Logger
  4. Alarm Visualization
  5. AlarmWorX64 Server
  6. AlarmWorX64 Logger
  7. Converting AlarmWorX64 to Hyper Alarm Server

Helper Modules 

  1. Recipe Management
  2. Scheduling
  3. Triggers
  4. Localization
  5. Unified Data Manager
  6. Workflows
  7. Expressions

Security 

  1. Basics
  2. Security Server
  3. Audit Logging
  4. Securing Data in Transit
  5. Securing Data at Rest

Cloud & IoT 

  1. Basics
  2. Broker Configuration
  3. Data Connectivity
  4. IoTWorX

Reporting 

  1. General
  2. Report Data Formats
  3. Advanced Topics

Automated Transactions 

  1. Basics
  2. Process Files
  3. Processing Data Sources
  4. Notifications
  5. Advanced Topics

Business Intelligence 

  1. Basics
  2. Data Flows
  3. Data Models
  4. Data Views
  5. Visualization

Project Management 

  1. Project Backups

Fault Detection & Diagnostics 

  1. Basics
  2. Fault Rules
  3. Diagnostic Models
  4. Cost Analysis
  5. Visualization

SPC/SQC Analysis 

  1. Basics
  2. Visualization

Energy Analysis 

  1. Basics
  2. Energy Calculation
  3. Visualization
← Return to Data Historian
SECTION 4

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.

4:59 min

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.

2:04 min

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.

1:30 min

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.

6:03 min

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.

4:25 min

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.

9:10 min

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.

2:51 min

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.

3:34 min