Length: 2 days
Time: 8:30am – 4:30pm
Objective: Upon completion of this course, you will be able to:
- Historize data from Wonderware Application Server
- Historize InTouch and I/O server data points
- Distinguish between multiple retrieval modes
- Retrieve data using time domain extensions
- Configure Historian Server tags for local summarization
- Use a Tier-2 Historian for replication and summarization
- Import, update, and insert history data
- Create and configure events
- Manage and maintain historical data
Audience: Application developers, engineers, system integrators, and other individuals who need to either historize, analyze, and maintain data from Wonderware Application Server or from a tag-based InTouch application.
Prerequisites: The prerequisites for this course are:
- Completion of an InTouch or Application Server course
- Manufacturing industry experience
- Some knowledge of Transact-SQL would be helpful
Module 1 – Introduction
Section 1 – Course Introduction
This section describes this Wonderware Historian Server course and outlines Wonderware software solutions.
Section 2 – Introduction to Wonderware Historian
This section introduces the Wonderware Historian Server software and describes its main functions and features.
Section 3 – System Requirements
This section provides an overview of general hardware recommendations and software requirements for installing Wonderware Historian Server and explains the licensing model.
Module 2 – Historian Configuration
Section 1 – ArchestrA System Management Console
This section introduces the ArchestrA System Management Console, including an overview of its interface and how to use it to register and start Historians. It also introduces system parameters and describes Historian security mechanisms.
Section 2 – Historian and System Platform
This section describes how Historian integrates with the Galaxy and how to configure platforms, engines, and attributes to historize data using Historian and System Platform.
Section 3 – IDAS – Historian and InTouch
This section explains the basics of historizing data from tag-based InTouch applications and describes storage options.
Module 3 – Data Retrieval
Section 1 – Data Retrieval
This section describes Historian’s data retrieval subsystem and explains SQL query structures.
Section 2 – Retrieval Modes
This section describes Historian’s Delta, Cyclic, Full, and BestFit retrieval modes. It also explains how to specify a retrieval mode in a SQL query using wwRetrievalMode.
Section 3 – Retrieval Options
This section describes Historian’s wwResolution, wwCycleCount, wwEdgeDetection, and wwFilter retrieval options in SQL queries.
Section 4 – Advanced Retrieval Modes
This section describes Historian’s advanced retrieval modes in SQL queries. The advanced modes include Interpolated, Average, Minimum, Maximum, Integral, Slope, Counter, ValueState, and RoundTrip.
Module 4 – Summaries and Data Replication
Section 1 – Data Summarization
This section explains data summarization and how to summarize data on a local Historian.
Section 2 – Tiered Historians
This section explains Tier-2 replication and how to replicate data on a Tier-2 Historian. It also reviews naming schemes from the replication process.
Section 3 – Summarized and Replicated Data
This section shows how to query summarized data from the local Historian and replicated data from a Tier-2 Historian.
Module 5 – Manual Data
Section 1 – Data Definitions
This section describes how Historian data is categorized and explains data versioning.
Section 2 – INSERT and UPDATE Query Syntax
This section explains how to use INSERT and UPDATE statements to insert and update data with SQL queries.
Section 3 – Data Import
This section shows how to import data into Historian using CSV files, as well as with the Historian Data Importer.
Module 6 – Historian Event System
Section 1 – Event System Overview
This section introduces the Historian Event system. It explains how to create and configure event tags and defines elements associated with event tags, such as event detectors and action strings.
Section 2 – Event Data Retrieval
This section explains how to query event data.
Section 3 – Active Event
Module 7 – Historian Maintenance
Section 1 – History Block Maintenance
This section introduces history block maintenance and explains how to back up and restore history blocks.
Section 2 – Historian Database Management
This section introduces Historian database management and explains how to back up a Historian database.