Instructor-Led Training
The Historian Server 2017 Update 3 Instructor-Led Training course is a 2-day, online instructor-led class designed to provide a fundamental understanding of the features and functionality of Historian Server for both Application Server and InTouch HMI applications. This course provides lectures and hands-on labs to present and reinforce the knowledge necessary to use Historian Server for SCADA and factory data. This information includes how to configure, historize, and retrieve historical data; retrieve auto-summary data; implement data replication to a remote historian; and insert, update, and import historical data.
The Historian Client 2017 Update 3 Instructor-Led Training course is a 2-day, online instructor-led class designed to provide a fundamental understanding of the features and functionality of the Wonderware Historian Client software. The course provides lectures and hands-on labs to supply and reinforce the knowledge necessary to use Wonderware Historian Client.
The Wonderware Historian Client trending, analysis, and reporting software offers a suite of data analysis and reporting clients that maximize the value of data stored in Historian. Wonderware Historian Client enables individuals at all levels of an organization to easily access plant- and process-related data through simple point-and-click dialog boxes.
Let us know if you are interested to have this training course, kindly fill up the enquiry form below.
Upon completion of this course, you will be able to:
- Start and configure Historian Server
- Configure and historize Application Server and InTouch HMI data
- Distinguish between retrieval modes
- Retrieve data with SQL queries
- 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 Wonderware Historian Client Trend to retrieve and represent Historian Server data in graphical and tabular formats
- Use Wonderware Historian Client Workbook to retrieve historical data in Microsoft Excel
- Use Wonderware Historian Client Query to build and execute queries against Wonderware Historian Server data and represent them in the desktop utility and in Microsoft Excel
- Use Wonderware Historian Client Workbook to execute queries from Wonderware Historian Client Query represent them in Microsoft Word
Historian Server
Module 1 – Introduction
- Section 1 – Course Introduction
- This section describes the Historian Server course objectives and agenda.
- Section 2 – Introduction to Historian Server
- This section describes the main functions and features of Historian Server and explains the ca- pabilities of Wonderware Online.
- Section 3 – System Requirements and Licensing
- This section provides an overview of the general hardware recommendations and software re- quirements for Historian. It also explains the licensing model.
Module 2 – Historian Configuration
- Section 1 – Configurator
- This section describes the Historian Server configuration options: alarm options, the ArchestrA SMC access, and how to drop and recreate a database. 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 ArchestrA 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 Server 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 – IDAS: Historian and InTouch HMI
- This section explains the basics of historizing data from InTouch HMI applications (IDAS). It describes the Tag Importer Wizard, defines storage options, and explains manual tag configuration.
Module 5 – Data Retrieval
- Section 1 – Insight
- This section describes how to retrieve data using an on-premises version of Insight. It explains the different methods of data representation. It also discusses block gap behavior when retrieving data. In addition, it explains how to add annotations to a chart and how to save and share content with Insight.
- Section 2 – Data Retrieval Subsystem
- This section describes the Historian Server 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 Server retrieval modes, with a focus on Cyclic, Delta, Full, and BestFit. It also explains how to use retrieval modes in SQL queries.
- Section 4 – Retrieval Options
- This section describes Historian Server 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 5 – Advanced Retrieval Modes
- This section describes phantom cycles. It defines Historian Server advanced retrieval modes, including Average, Counter, Integral, Interpolated, Maximum, Minimum, RoundTrip, Slope, and ValueState retrieval modes.
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.
- 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.
- 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 from 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 Server databases.
Historian Client
Module 1 – Introduction
- Section 1 – Course Introduction
- This section describes the fundamentals of the Wonderware Historian Client 2017 Update 2 software course, the objectives of the course, intended audience, prerequisites, and course agenda.
- Section 2 – Introduction to Wonderware Historian Client
- This section introduces the Wonderware Historian Client applications, and the main features.
- Section 3 – Introduction to Wonderware Historian Server
- This section introduces the main features of Wonderware Historian Server.
- Section 4 – System Requirements and Licensing
- This section explains the recommended system requirements and licensing information.
Module 2 –Wonderware Historian Client Trend
- Section 1 – Introduction to Wonderware Historian Client Trend
- This section describes the features of Wonderware Historian Client Trend and explains how to create and configure trends using Wonderware Historian Client Trend.
- Section 2 – Trend Annotations and Data Logs
- This section describes how to add annotations to a Wonderware Historian Client Trend and explains how to access data logs and trend statistics.
- Section 3 – Public and Private Groups
- This section describes the function of the Public and Private Groups folders that are used in Wonderware Historian Client Trend 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 takes you through the steps necessary to configure Retrieval styles.
Module 3 –Wonderware Historian Client Workbook
- Section 1 – Introduction to Wonderware Historian Client Workbook
- This section explains the basic functionality of Wonderware Historian Client Workbook.
- Section 2 – Enhanced Workbook with Excel Functionality
- This section explains how to use the features of the Wonderware Historian Client Workbook with Excel functionality to create reports to get data for a specified shift.
Module 4 –Wonderware Historian Client Query
- Section 1 – Introduction to Wonderware Historian Client Query
- This section introduces Wonderware Historian Client Query uses and operation.
- Section 2 – Direct Query in Wonderware Historian Client Workbook
- This section describes how to use the Direct Query function use queried data in the Wonderware Historian Client Workbook.
Module 5 –Wonderware Historian Client Report
- Section 1 – Introduction to Wonderware Historian Client Report
- This section introduces the uses and operation of Wonderware Historian Client Report.
- Section 2 – Report Editing and the Use of Wildcards in Reports
- This section describes how to edit reports, and explains how to use wildcards for time options and report editing.
- Knowledge of the following tools, features, and technologies is required:
- For all students:
- Industrial automation software concepts
- Structured query language fundamentals for data retrieval
- For historizing data from Application Server:
- ArchestrA IDE
- Automation Objects
- Historization of attributes
- Deployment model
- Object Viewer
- For historizing data from InTouch tags:
- InTouch HMI tag development
- For all students:
- Knowledge of Microsoft Office Excel and Microsoft Word
- Individuals who need to historize, analyze, and maintain data from Application Server or from an InTouch HMI application
- Audience for this course includes plant floor operators, managers, and other individuals whose jobs include using Historian Server data for assessment and reporting within production or administrative environments.
