AVEVA™ Historian Server

Objectives

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
• Backup and restore Historian data

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 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 Operations Control Management Console (OCMC). It provides an overview of its interface and explains how to set startup permissions and start Historian. It also describes Historian options and system parameters and discusses Historian history block configuration and behavior. This section also discusses the configuration of engineering units and describes the engineering units catalog.

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. This section also discusses extended properties for tags using aliases.

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. This section also discussed extended properties for tags in the OCMC.

Module 5 – Data Retrieval

• Section 1 – Retrieve Data with Historian Client Web
  • 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 discusses the alarm retrieval tool and explains searching for tags using extended properties.
• 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 to display data, as well as UOM conversion using queries. 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. It goes on to discuss using wwResolution and wwCycleCount for cyclic retrieval as well as wwExpression for scaling to alternative engineering units.

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 auto-summary 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 and restore history blocks. It goes on to discuss the volume shadow copy.
• Section 2 – Historian Database Management
  • This section explains how and when to back up Historian databases.

Appendix A – Additional Retrieval Options for Queries

• Section 1 – Retrieval Options
  • This section describes Historian retrieval options, with a focus on wwResolution, wwCycleCount, wwEdgeDetection, and wwFilter. It also explains the usage of wwRetrievalmode = Startbound/Endbound when querying history, and the usage of SliceBy options when retrieving data from AnalogSummaryHistory.

• Section 2 – Advanced Retrieval Modes
  • This section describes phantom cycles. It defines Historian advanced retrieval modes, including Average, Counter, Integral, Interpolated, Maximum, Minimum, RoundTrip, Slope, and ValueState retrieval modes.

Prerequisites

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

• For all students:
  • Industrial automation software concepts
  • Structured query language (SQL) fundamentals for data retrieval
• For historizing data from Application Server:
  • IDE
  • Automation Objects
  • Historization of attributes
  • Deployment model
  • Object Viewer
• For historizing data from InTouch tags:
  • InTouch HMI tag development

AVEVA™ Historian Client

Objectives

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

• 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

Outline

Module 1 – Introduction

• Section 1 – Course Introduction
  • This section describes the fundamentals of the Historian Client 2020 R2 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 Microsoft 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.

Prerequisites

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

• Microsoft Excel
• Microsoft Word

**หมายเหตุ**
– สถานที่อบรม Enlighten Technology (ลำลูกกา คลอง 5)
– จำกัดจำนวนผู้เข้าอบรม ไม่เกิน 12 ท่านต่อคอร์ส
– สงวนสิทธิ์เฉพาะท่านที่ลงทะเบียนและยืนยันสิทธิ์ก่อน
– สงวนสิทธิ์เฉพาะ Registered Partner และ End User ที่ใช้สินค้าของ Enlighten Technology เท่านั้น
– ผู้ที่มีสิทธิ์อบรมจะได้รับการตอบกลับทางอีเมล์ ท่านที่ไม่ได้รับอีเมล์ตอบกลับถือว่าไม่ได้รับสิทธิ์ในการอบรมครั้งนี้
– ผู้เข้าอบรมจะต้องดาวน์โหลดไฟล์จำลองที่ติดตั้งโปรแกรมให้เรียบร้อยก่อนวันเทรนนิ่งเพื่อไม่ให้เสียเวลาในการอบรมของท่านอื่น
– ขอสงวนสิทธิ์การเปลี่ยนแปลงตามความเหมาะสม โดยไม่ต้องแจ้งล่วงหน้า

ลงทะเบียนเข้าร่วมคอร์ส

Click here