<img src="https://secure.leadforensics.com/24951.png" alt="" style="display:none;">

AVEVA Historian and Historian Client 2020



The AVEVA Historian and Historian Client 2020 course is a 4-day, instructor-led class designed to provide a fundamental understanding of the features and functionality of Historian Server and Client for both System Platform (Application Server) and InTouch tag-based applications. This course provides lectures and hands-on labs to supply and reinforce the knowledge necessary to use the products.

Book Training

cement factory at night


Upon completion of this course, you will be able to:

  • Start and configure Historian
  • Configure and historize Application Server and InTouch HMI data
  • Retrieve data with Historian tools
  • Retrieve data with SQL queries
  • Distinguish between retrieval modes
  • Use time domain extensions in SQL queries
  • Update, insert, and import historical data
  • Use a Tier-2 Historian for replication and summarization
  • Back up and restore Historian data
  • Use Historian Client Trend to retrieve and represent historical data in graphical and tabular formats
  • Use Historian Client Workbook to retrieve historical data in Microsoft Excel
  • Use Historian Client Query to build and execute queries against Historian Server and display results in the Historian Client Query and in Microsoft Excel
  • Use Historian Client Report to execute queries using Historian Client Query and represent the results in Microsoft Word
4 Day Course
£1800 / €2100
Available virtually

Available Dates in 2021

4th October 


13th December


For more information or to book a place on a course, please get in touch.

Get in touch


Knowledge of the following tools, features, and technologies is required:

  • Industrial automation software concepts
  • Structured query language (SQL) fundamentals for data retrieval
  • Knowledge of Microsoft Excel
  • Knowledge of Microsoft Word


Individuals who need to historize, analyze, and maintain data from Application Server or from an InTouch HMI application. Useful for many roles including, Plant floor operators, managers, and other individuals whose jobs include using Historian data for assessment and reporting within production or administrative environments.

Historian Server

Course Outline
Module 1 – Introduction

Section 1 – Course Introduction
This section describes the AVEVA™ Historian Server course objectives and agenda.
Section 2 – Introduction to Historian
This section describes the main functions and features of Historian, explains how it relates to
other AVEVA software offerings, describes the relationship to other AVEVA software offerings, and explains the capabilities of AVEVA Online.
Section 3 – System Requirements and Licensing
This section provides an overview of the general hardware recommendations and software
requirements for Historian. It also explains the licensing models.

Module 2 – Historian Configuration Section 1 – Configurator
This section describes the Historian configuration options. It also discusses the Historian security options, describes the Historian search configuration, and explains the Historian reporting configuration.
Section 2 – Historian and the System Management Console
This section describes the System Management Console (SMC). It provides an overview of
its interface and explains how to set startup permissions and start Historian, as well as use it
to register Historians. It also describes Historian options and system parameters and discusses Historian history block configuration and behavior.

Module 3 – Historian and System Platform
Section 1 – Integrating Historian with System Platform
This section explains the basics of how Historian integrates with the Galaxy. It also describes
how to configure platforms, engines, and object attributes for historization.

Module 4 – Historian and InTouch HMI
Section 1 – Historian and InTouch HMI
This section explains the basics of historizing data from InTouch HMI applications. It describes the Tag Importer Wizard (IDAS), the historization option from InTouch configuration
(HCAL), defines storage options, and explains manual tag configuration.

Module 5 – Data Retrieval
Section 1 – Historian Data Retrieval Tools
This section describes how to retrieve data using Historian Client Web. It explains the different methods of data representation, adding annotations, and explains how to save and share
content. It also demonstrates how to retrieve data using Microsoft Excel. Section 2 – Data Retrieval Subsystem
This section describes the Historian data retrieval subsystem, the Historian OLE DB provider,
and extension tables for history data. It explains the syntax for basic SQL queries and
demonstrates how to use Live, History, Wide History, and Summary History options for retrieved data. It discusses the auto-summary features of Historian and explains the syntax for
the OPENQUERY function in SQL queries.
Section 3 – Retrieval Modes
This section describes Historian retrieval modes, with a focus on Cyclic, Delta, Full, and BestFit. It also explains how to use retrieval modes in SQL queries.

Module 6 – Manual Data
Section 1 – Data Definitions
This section defines Historian data categories. It explains original versus revision data, as
well as streamed versus non-streamed original data. Further, it explains the possibilities of
inserting data into future retrievals.
Section 2 – INSERT and UPDATE Query Syntax
This section describes data versioning and explains the INSERT and UPDATE query syntax.
Section 3 – Importing and Backfilling Historical Data
This section describes the methods of importing historical data using a .CSV file. It discusses
Historian data folder methods and executable methods and explains how to backfill autosummary data.
Section 4 – Importing Data with Questionable Quality
This section discusses the effects of data quality when importing historical data. It also explains the wwQualityRule options when querying historical data.

Module 7 – Summaries and Data Replication
Section 1 – Data Summarization and Replication
This section explains the concept of Tiered Historians, describes analog and state summary
replication, and explains naming schemes for the replication process. It describes how to
summarize data locally, as well as how to summarize to a Tier-2 Historian. It also describes
how to do simple replication to a Tier-2 Historian.
Section 2 – Summarized and Replicated Data Retrieval
This section describes how to retrieve summarized and replicated data from a Tier-2 Historian. It also reviews AnalogSummaryHistory and StateSummaryHistory views.

Module 8 – Historian Maintenance
Section 1 – History Block Maintenance
This section explains how to back up history blocks.
Section 2 – Historian Database Management
This section explains how and when to back up Historian databases

Historian Client

Course Outline
Module 1 – Introduction
Section 1 – Course Introduction
This section describes the fundamentals of the Historian Client 2020 software course, the objectives of the
course, intended audience, prerequisites, and course agenda.
Section 2 – Review of Historian Server
This section introduces the main features of Historian Server needed in order to understand the use of
Historian Client tools for the retrieval of Historian Server data.
Section 3 – Introduction to Historian Client
This section introduces the Historian Client applications and explains the main features.
Section 4 – System Requirements and Licensing
This section explains the recommended system requirements and licensing information.

Module 2 – Historian Client Trend
Section 1 – Introduction to Historian Client Trend
This section describes the features of Historian Client Trend and explains how to create and configure trends
using Historian Client Trend.
Section 2 – Trend Annotations and Data Logs
This section describes how trend annotations and data logs are used in Historian Client.
Section 3 – Public and Private Group Organization
This section describes the function of the Public and Private Groups folders that are used in Historian Trend
Client to store and share tags.
Section 4 – Time Offset and Target Regions
This section describes how to configure time offset and target region in a trend for tag configuration.
Section 5 – Retrieval Styles and Data Transformations in Trend
This section discusses how to configure Retrieval styles and create Custom Retrieval styles in Historian
Client Trend.

Module 3 – Historian Client Workbook
Section 1 – Introduction to Historian Client Workbook
This section explains the basic functionality of Historian Client Workbook.
Section 2 – Enhance Workbook with Excel Functionality
This section explains how to use the features of the enhanced workbook with Excel functionality to create
reports to get data for a specified shift.

Module 4 – Historian Client Query
Section 1 – Introduction to Historian Client Query
This section introduces Historian Client Query uses and operation.
Section 2 – Direct Query in Historian Client Workbook
This section explains how to use Direct Query to insert a query into Historian Client Workbook.

Module 5 – Historian Client Report
Section 1 – Introduction to Historian Client Report
This section introduces the uses and operation of Historian Client Report.
Section 2 – Use of Wildcards in Reports
This section explains the use of wildcards for time options and report editing