Copyright 2011 OSIsoft LLC 1 PI System Product

© Copyright 2011 OSIsoft, LLC 1

PI System Product Roadmap Presented by Ana Vivas Field Service Engineer OSIsoft México PI System Product Roadmap 2

Achievements since UC 2010 • • PI Servers PI Analytics PI Clients PI Data Access Achievements since UC 2010 3

PI 64 -Bit Products • Servers: – – PI Server 2010 PI Notifications 2010 R 2(*) PI ACE 2010 R 2 OSIsoft Utilities Gateway • Data Access – – PI SDK PI OLEDB 3. 3 PI OLEDB Enterprise 2010 PI Web Services 2010 • Clients – PI Web. Parts 2010 R 2 – PI Data. Link for Excel Services 2010 4

PI Server 2010 Data Access Services SQL-Based Web Services SDKs OPC PI Notifications PI Analytics Health Monitoring PI Asset Framework PI Data Archive Windows Security High Availability (option) Real-time Interfaces Real-Time Data Custom Data DCS / PLC / SCADA / OPC APIs / SDKs HISTORIANS / INTERFACES IT Data Relational Data OLEDB / ODBC SQL SERVER / ORACLE Batch Data BATCH EXECUTION SYSTEMS 5

PI Server 2010 in 2010 • PI AF Link Subsystem • PI AF Scaling and Performance • PI AF Builder AF Link Subsystem AF Scaling and Performance AF Builder 6

Migrating Module DB to PI Asset Framework (PI AF) MDB based Applications ISV/Internal Apps Batch. View PI ACE Module Database PI AF Element Database PI AF Link Subsystem PI AF based Applications PI Web. Parts PI Process. Book Custom via Data Access 7

Trends of PI AF Server Performance Total Objects Insert Rate Read Performance Search Time Trends of AF Server Performance 8

PI Analytics PI Notifications 2010 R 2 PI ACE 2010 R 2 PI for Stream. Insight 9

PI Notifications 2010 R 2 • Message formatting • Option to control tag usage • 64 -bit! PI Notifications 2010 R 2 10

PI ACE 2010 R 2 • • PI ACE Schedulers running on multiple machines Higher scale. Faster startup. Visual Studio 2005, 2008 & 2010 Both 32 - and 64 -bit! PI ACE 2010 R 2 11

PI System and Microsoft Stream. Insight Application Development . NET C# LINQ Stream. Insight Application at Runtime Event sources Input Adapters Stream. Insight Engine Output Adapters Event targets PI Server Query Logic Stock ticker, news feeds Query Logic PI Interface (future) PI for Stream. Insight PI Server Pagers, Mobile Trading stations 12

PI Clients PI Web. Parts 2010 PI Data. Link 2010 13

PI Web. Parts 2010 (& R 2) • Support for PI AF Data Reference types – All time series data • Formula • Table Lookup • Custom • Share. Point 2010 PI Web. Parts 2010 (& R 2) 14

PI Data. Link 2010 • Support for Microsoft Office 2010 • Fully internationalized – 8 languages • PI Data. Link Server 2010 – Support for Share. Point 2010 – 64 -bit! PI Data. Link 2010 15

Localization in 2010 • • • PI Active. View • PI Process. Book • PI Web. Parts • PI Data. Link French German Russian Spanish • Korean • Japanese • Brazilian Portuguese • Simplified Chinese Saluton Localization in 2010 16

PI Data Access Services SQL-Based Web Services OPC SDKs PI OLEDB Enterprise 2010 PI JDBC 2010 PI Web Services 2010 17

PI OLEDB Enterprise 2010 (& R 2) • Access to PI AF structures • Data access to PI AF Attribute data – Snapshots, compressed, interpolated – With Unit of Measure conversions PI OLEDB Enterprise 2010 (& R 2) 18

PI JDBC 2010 (& R 2) • • Access to PI AF Compliant with JDBC 4. 0 API Bulk insert JNDI Directory Service support – JDBC 2. 0 Optional Package PI JDBC 2010 (& R 2) 19

PI Web Services • Access to PI System data using standard web service technologies Microsoft Web Server (IIS) PI Web Services Intranet Extranet Internet Web Service Client application PI Web Services 20

PI Web Services 2010 (& R 2) • Support for PI System timeseries data: – Both PI tag & AF Attribute paths – Snapshots, compressed, interpolated, plot, summaries – Performance Equations • Basic PI tag search PI Web Services 2010 (& R 2) 21

PI Interfaces • 43 Interface Releases in 2010 • First AMI Interface Released • Modbus Serial and Modbus Ethernet Interfaces Completely Rewritten • Improvement in message logging PI Interfaces 22

New Releases in PI Interfaces – – – – – Siemens Spectrum Power TG Interface (Windows) Silver Spring Network Interface (AMI) ESC Stack. Vision Interface Read/Write ESC Stack. Vision Read-Only Modbus Serial Interface Modbus Ethernet Interface Siemens Simatic Batch Interface REpower. Event List Plug-In for OPC DA Interface Simca Batch On. Line Interface (64 -Bit) GE i. Batch Interface New Developments in PI Interfaces 23

Our current development efforts 24

2011 Development Efforts What is OSIsoft working on in 2011 to help you? The fastest, easiest way to visualize PI data Also, significant work in: Asset-PI, Security, Interfaces, Data Access 25

A tour through the PI System Interfaces Servers Analytics Data Access Visualization Real-Time Data DCS / PLC / SCADA / OPC HISTORIANS / INTERFACES IT Data PI SDK PI Process. Book Interface 1 PI Server(s) Custom Data PI Analytics AF SDK APIs / SDKs Relational Data OLEDB / Interface 2 Web Services ODBC SQL SERVER / ORACLE Batch Data SQL Batch Execution Systems Interface N AF Server(s) PI Web. Parts PI Notifications OLEDB PI Data. Link 26

PI System – Interfaces Real-Time Data DCS / PLC / SCADA / OPC HISTORIANS / INTERFACES IT Data Interface 1 Custom Data APIs / SDKs Relational Data OLEDB / Interface 2 ODBC SQL SERVER / ORACLE Batch Data Batch Execution Systems Interface N PI Data. Link 27

Interfaces • OSIsoft commitment: – 440 interfaces – 22 developers in 6 locations – Over 160 effort-years of expertise • Interface Development – – – – IEC 61850 OPC. NET Web Services IPMI Modular Mining SAFER Weather Station Thermotron 8800 Controller • Batch Interfaces – Performix x. Batch – Werum PAS-X – Foxboro Batch • AMI Interface Development – Trilliant Unity – Multi. Speak – Eschelon 28

PI System - Servers PI Server(s) SQL AF Server(s) 29

Security • Goal – • How – – • Your trusted source of real time data Continually improve the PI System Infrastructure Dedicated Cyber Security Manager Work Underway – – – Engagement with Idaho National Labs Security Reviews with Microsoft Designed-In on new efforts Security 30

Some of the World Largest Databases 10 20 TB 130 M items 5 323 TB 1. 9 trillion call records 9 42 TB inventory, items 4 2, 800 TB (2006) 8 45 TB +65 K videos/day online/on tape 220 TB 3 6, 000 TB 7 250 TB 6 2. 85 TRow 2? not available US demographics proprietary 70 K calls/sec 1? 2007 Article: http: //www. focus. com/fyi/operations/10 -largest-databases-in-the-world/ 31

Customers want to use more PI 270 TB Synchro Phasors Automated Metering 4, 800 data streams at 60 Hz 150 M data streams, 15 min 3 years online 7 years online Unique events: 27 Trillion Estimated data size: 270 TB 200 TB Unique events: 16 Trillion Estimated data size: 200 TB 32

PI System - Analytics PI Notifications 33

Analytics Product Suite PI Analytics Configuration Programming Performance Equations AF Configured Analytics PI Advanced Computing Engine (PI ACE) Totalizers Microsoft Stream. Insight & PI for Stream. Insight Statistical Quality Control PI AF formula data reference PI AF custom data reference 34

PI AF Configured Analytics - Philosophy • Rich Configuration in PI AF – Merge of Performance Equations and Formula Data Reference syntax – Configuring rollup calculations • OSIsoft takes care of – Scheduling – Dependencies – Writing results to the PI System • Very Large Scale – Improvements in data access – OSIsoft managed scale-out AF Configured Analytics - Philosophy 35

PI Analytics – Simple Configuration • Equation defined on an attribute or a template Analytics – Simple Configuration 36

PI System – Data Access PI SDK AF SDK Web Services OLEDB 37

Data Access – AF SDK • Rich Data Access – – • • Full featured Bulk operations Calculations Updates . NET exposure PI Points Data Access – AF SDK 38

Data Access • PI Web Services – – • PI OLEDB Enterprise & PI JDBC – • Data by exception Event Frames PI SDK – – – Buffering of new data and edits Fanning to all members of an HA Collective Windows Security Data Access 39

PI System - Visualization PI Process. Book PI Web. Parts PI Data. Link 40

PI Data. Link • • • PI AF attribute paths PI tag paths Search Units of Measure 64 -bit Excel Support PI Data. Link 41

PI Coresight • Fastest, easiest way to visualize PI System data 42

PI System – Event Frames Interfaces Servers Analytics Data Access Visualization Real-Time Data DCS / PLC / SCADA / OPC HISTORIANS / INTERFACES IT Data PI SDK PI Process. Book Interface 1 PI Server(s) Custom Data PI Analytics AF SDK APIs / SDKs Relational Data OLEDB / Interface 2 Web Services ODBC SQL SERVER / ORACLE Batch Data SQL Batch Execution Systems Interface N AF Server(s) PI Web. Parts PI Notifications OLEDB PI Data. Link 43

What can you do with PI Event Frames? • Any event in your process – Such as a downtime or incident • Automatically identify important events – Based upon patterns in your PI Data • Search these events • Visualize and analyze them – To improve your process • Imagine: – A simple downtime tracking tool – Configuration, no programming What can you do with Event Frames? 44

PI Event Frames – Infrastructure changes • Interfaces • – Batch Interfaces • • – AF SDK – PI Web Services – PI OLEDB Enterprise & PI JDBC Servers – Events Frames stored in PI AF Server – Batch to EF transition Analytics – Generating Event Frame on patterns Data Access • Clients – – PI Data. Link PI Web. Parts PI Process. Book New Visualization Targeted by 2012 User’s Conference Event Frames – Infrastructure changes 45

PI System – Summary Interfaces Servers Analytics Data Access Visualization Real-Time Data DCS / PLC / SCADA / OPC HISTORIANS / INTERFACES IT Data PI SDK PI Process. Book Interface 1 PI Server(s) Custom Data PI Analytics AF SDK APIs / SDKs Relational Data OLEDB / Interface 2 Web Services ODBC SQL SERVER / ORACLE Batch Data SQL Batch Execution Systems Interface N AF Server(s) PI Web. Parts PI Notifications OLEDB PI Data. Link 46

PI System – Summary Servers Analytics Data Access Visualization Ne w In te rfa ce s Interfaces 47

PI System – Summary Analytics Data Access Visualization y cu rit Sc ala bi lit y Servers Se Ne w In te rfa ce s Interfaces 48

PI System – Summary Analytics Data Access Visualization ics aly t An AF y cu rit Sc ala bi lit y Servers Se Ne w In te rfa ce s Interfaces 49

PI System – Summary Analytics Data Access ch Ri AF aly t An AF y ics Da y bi lit cu rit ala Sc Visualization ta Servers Se Ne w In te rfa ce s Interfaces 50

in PI ta k Data Access Da Tu ne ta Li d n AF ay St PI ch Ri Analytics Da ics aly t An y bi lit ce s Servers AF AF y cu rit Se ala te rfa In Interfaces Sc w Ne PI System – Summary Visualization 51

PI System – Summary Analytics Data Access Visualization PI in St ay AF PI PI Event Frames Da Tu ne ta Li d n Da AF Ri ch ics aly t An AF y cu rit Sc ala bi lit y ta k Servers Se Ne w In te rfa ce s Interfaces 52

Ana Vivas avivas@osisoft. com Field Service Engineer 53

54