WW INFO-04
Rapid Value-add For InTouch
With Wonderware Historian
Agenda
●Historian 101– It’s Important! Wonderware Historian/Client Overview ●InTouch Trend/HistData Review
●Commissioning Wonderware Historian in 6 (0) Minutes ●Wonderware Online and Historian Publisher
●InTouch and Historian Client Trend Integration ●Transitioning to System Platform
Agenda
●Historian 101– It’s Important! Wonderware Historian/Client Overview ●InTouch Trend/HistData Review
●Commissioning Wonderware Historian in 6 (0) Minutes
●Wonderware Online and Historian Publisher
●InTouch and Historian Client Trend Integration
Historian 101
“If you don't know where you are going,
you'll end up someplace else.”
A Historian Is…
●A
storage repository
for time-based information – a Database
●But a Historian is
much more
than a database
●A Historian stores process data - lots of it
●A Historian lets you retrieve the process data – sensibly ●A Historian Transforms the process data into Information
●A complete system to enable you to make the best use of this data
● Wonderware Historian does this, elegantly
●“Store data at the resolution of your Process – Retrieve at the resolution
of the Problem you are trying to Solve”
Historian Information Management
●Organize information in the context of your production.
● Lots, Materials, Shifts, Machines
●Analyze information at the resolution of your problems.
● Conversion to the Problem Domain ● Trends, Statistics, Time in State
●Alert and notify when deviations occur.
● HMI Alarm Generation, Mobile Delivery, Browser Delivery
●Correct problems and take actions immediately.
● Real Time Command and Control
●All Automation Processes require a Historian – Analog, String, AND
Discrete!
2014 Software Global Client Conference
Wonderware Historian
Wonderware Historian Solution:
Store Analog, String, and Boolean data at full resolution
● Optional Swinging Door, Time and Value dead-band for Analog ● OPC, Suitelink, CSV, SQL, .NET API
Time-Series data storage with industry-standard retrieval (OLE DB -SQL) T-SQL Extensions for Time Series Data
● Cyclic, Delta, Full, Best Fit retrieval resolution control
●Analog Aggregate Transformation (Avg, Max – Time at Max, Min –Time at Min, Std. Dev., Integral, To Discrete)
●Discrete Aggregate Transformation (Count, Total, Max, Min, Round Trip) Answer Automation Questions with Actionable Information
Database?
●I can use Access/MySQL/SQL Server/Oracle
- so why do I need a specialized Historian?
●Using a simple database as a historian – doesn’t quite work
●Databases are transaction based, Process information is asynchronously time based
●Databases were designed for Transactional Data ●Storage and Retrieval is not straightforward
●Plants generate a lot of data, often across slow, distributed networks and at varying rates
2014 Software Global Client Conference
Relational Retrieval Challenges
●Independent Records
●Not samples from a continuum
●Can’t infer values between samples
●Can’t relate samples w/o the same timestamp ●Can’t interpolate Time
●All Data Treated Equally
●Data quality not factored into aggregate calculations ●No distinction between low-level noise
& significant value changes
● No time weighting for aggregate calculations ●Max/Min calculations do not return timestamp
Data Retrieval
January 1, 12:00:00 AM January 1, 12:05:00 AM January 1, 12:10:00 AM 0 10 20 30 40 50 60 70 80 90 100 Linear Stair Step
Analog and String State History
The Face of Wonderware Historian
Bringing plant data to life!
Desktop
●Historian Client Trend
●Historian Client Query
●
Microsoft Office Integration:
●Historian Client Workbook (Excel)
●Historian Client Report (Word)
Information Server Reporting Website
●
Out of the box
functionality –
simply run
install
to get started
●
Use the Historian
Client Desktop
applications to
Create
content
●
Use Information
Server to
Publish
the content
2014 Software Global Client Conference
Why Wonderware Historian?
●Low Risk, High Value
● Installed Base over 70,000 licenses sold
●Optimal use of COTS - Microsoft SQL Server Fast Installation and Quick ROI
●“Checkbox” configuration from Application Server ●Tag importer for conventional InTouch applications ●CSV/SQL bulk Load options
●Wonderware Online – InTouch Historian Publisher Automatically manages historical storage
●Circular, Alternate, Buffer, Permanent Superior Historian Client Tools
Agenda
●Historian 101– It’s Important! Wonderware Historian/Client Overview
●InTouch Trend/HistData Review
●Commissioning Wonderware Historian in 6 (0) Minutes
●Wonderware Online and Historian Publisher
●InTouch and Historian Client Trend Integration
InTouch Trend Advantages
● Built-In to InTouch (“Free”) ● Wizard driven Configuration ● Historical data access with
HistData ● Scriptable
InTouch Trend Disadvantages
● Complex Distributed History ● Terminal Services Limitations ● HistData Limitations
● Requires InTouch Runtime ● Limited Tag Count (Scale)
Agenda
●Historian 101– It’s Important! Wonderware Historian/Client Overview
●InTouch Trend/HistData Review
●Commissioning Wonderware Historian in 6 (0) Minutes ●Wonderware Online and Historian Publisher
●InTouch and Historian Client Trend Integration
Commissioning Wonderware Historian in
6(0) Minutes
● Installation of Microsoft SQL Server/Service Packs (40 min) ● Prerequisites (.NET 4.5, etc.) and Rebooting (15 Min)
● Installation of Historian, InTouch Tag Import (6 min) ● YMMV
●(All time record – 27 min. SQL Server, Historian and InTouch Tag Import)
Agenda
●Historian 101– It’s Important! Wonderware Historian/Client Overview
●InTouch Trend/HistData Review
●Commissioning Wonderware Historian in 6 (0) Minutes
●Wonderware Online and Historian Publisher ●InTouch and Historian Client Trend Integration
Wonderware Online Historian Publisher
1) Receive Wonderware Online Welcome Email/ SmartGlance
Registration Email
2) Register Password (Windows Azure Active Directory)
3) Receive Registration Email Confirmation
4) Navigate to
https://online.wonderware.com
5) Download and install InTouch Historian Publisher on InTouch node
6) Install Historian Client 2014R2
●Data available in Trend and SmartGlance immediately!
Agenda
●Historian 101– It’s Important! Wonderware Historian/Client Overview
●InTouch Trend/HistData Review
●Commissioning Wonderware Historian in 6 (0) Minutes
●Wonderware Online and Historian Publisher
●InTouch and Historian Client Trend Integration ●Transitioning to System Platform
InTouch and Historian Client Trend
Integration
Leveraging Dual Historians on Top of
InTouch
Agenda
●Historian 101– It’s Important! Wonderware Historian/Client Overview
●InTouch Trend/HistData Review
●Commissioning Wonderware Historian in 6 (0) Minutes
●Wonderware Online and Historian Publisher
●InTouch and Historian Client Trend Integration
Taking it to the Next Level w/ System
Platform
●System Platform Offers Compelling Historian Solutions:
– Superior Data Acquisition Availability
– App Engine Redundancy / Redundant DI Object
– Active/Standby Engine Store-Forward
– Dual Historians (Don’t Forget 25k/7 Day as an Option!)
– Tiered Historians
● InTouch is the Configuration Source ● Creating the Simple Object.PV
Leveraging Dual Historians & App
Server on Top of InTouch
HCAL HCAL
SP2012R2 >
Historian 11
Leveraging Dual Historians & App
Server on Top of InTouch
Leveraging Dual Historians & App
Server on Top of InTouch
●
Convert InTouch DB to App Server Model1. Create Simple Analog with PV UDA
2. Extend with Input and History 3. Create one instance
4. Galaxy Dump the instance
a) Remove unnecessary columns
5. DB Dump the InTouch App
a) Sort each IO group by “Logged” b) Remove unnecessary columns
6. Copy InTouch Dump Columns to GR Dump Columns
a) Prepend DIObject.ScanGroup to Item Name
7. GR Load 8. Deploy
Leveraging Dual Historians & App
Server on Top of InTouch
Leveraging Dual Historians & App
Server on Top of InTouch
Leveraging Dual Historians & App
Server on Top of InTouch
Leveraging Dual Historians & App
Server on Top of InTouch
Leveraging Dual Historians & App
Server on Top of InTouch
Leveraging Dual Historians & App
Server on Top of InTouch
●To Test:
• 2,000 Simple Analog Objects
• Live Data
Leveraging Dual Historians & App
Server on Top of InTouch
Leveraging Dual Historians & App
Server on Top of InTouch – 5K IO
Wonderware Historian and the Existing
InTouch User
● Wonderware Historian has significant capabilities for the existing InTouch User
● Adding Simple Local Historian (25K/7Day) – Historian Client Availability
● Adding System Platform with Massaged InTouch GR Load ● Superior Data Availability
– NOTE: The addition of SP to an existing Historian DB adds the .PV to the TagName
– Tag Rename Utility for History Blocks – Reports may have to be Massaged
Questions???
●Ray Norman
Related Support, Services, Training &
Expo Demos
● [insert Support options here]
● [sample: Proactive System Monitoring] ● [sample: Software Asset Manager] ● [sample: …]
Support
Training
> [insert Training options here]
> [sample: Application Server 2012 R2 Web-Based Training]
> [sample: InTouch Alarms Webinar] > [sample:…]
> [insert Services options here]
> [sample: Project Mgmt Services] > [sample:…]
> [sample:…]
Services
Expo Demos
> [insert related Expo Demos here]
> [sample: Control Room Console for W&WW (booth #2)]
> [sample: Process Information with Historian (booth #4)]
