1 / 31

Data Access

Data Access. Ray Verhoeff Bodo Bachmann. Agenda. The data access “surface area” PI AF & RtBaseline Services OPC SQL-based data access. Data Access. RtBaseline Services for Thin Clients. OPC. OLE DB. ODBC & JDBC. “Surface Area”.

trevor
Télécharger la présentation

Data Access

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Data Access Ray VerhoeffBodo Bachmann

  2. Agenda • The data access “surface area” • PI AF & RtBaseline Services • OPC • SQL-based data access Data Access RtBaseline Services for Thin Clients OPC OLE DB ODBC & JDBC

  3. “Surface Area” • Collection of all techniques for accessing all or part of the PI System • PI SDK • PI API* • AF SDK • Including AN SDK • OPC • Both COM-based and OPC UA • SQL-based access • OLE DB • ODBC • JDBC

  4. RtBaseline ServicesData Access for OSIsoft Thin Client Applications RtBaseline RtPortal HTML Data Thin Client • RtReports Generator RtBaseline Services* HTML Internet Explorer PI Server RtWebParts RtReports RtPortal iViews HTML Thin Client • RtWebParts Transactional, Web service, and other data

  5. Data Access through the AF SDK • …and add Events AFElement GetValue(…) AFAttributes GetValues(…)* GetValue(…) AFAttribute GetValues(…)

  6. AF SDK Data Access with RtBLS • RtBaseline provides: • Access to many data sources • Connection pooling • User session management • Data caching • AF will use Data References based on RtBaseline Services AF Data Reference RtBaseline Services

  7. OSIsoft and OPC • OPC COM-based standard • DA and HDA Servers • What is the OPC Foundation doing next? • OPC Unified Architecture (UA)!

  8. Why a new OPC architecture? • Organize data around Nodes and Relationships • Unified API for different classes of data access • Browse & Search to aid in discovery • Extensibility for supporting complex data structures • Mitigate security threats • Standards-based, flexible transport • Binary/TCP • XML/SOAP • Cross-platform interoperability

  9. OPC UA Address Space • “Set of objects and relationships exposed by an OPC UA Server” • Nodes: • Have Attributes, which have values • Minimum: • Node name • Node type • Node id • All objects are nodes, not all nodes are objects

  10. Mapping OSIsoft’s Technology into OPC UA OSIsoft Technology OPC UA Technology AnalysisFramework InformationModeling Real-time andHistorical data Data Access and Historical Access PI Notifications, Analytics Events, A&C,Programs High Availability,PI Security Redundancy,UA Security

  11. OPC UA Information Model • Definition: • Specific design of Nodes and Relationships to support the data access requirements of an industry domain • For example, in upstream oil & gas: Well Tubing Casing

  12. Collaboration and Partnership • Collaboration with ISA (S88, S95, S99) • Collaboration with MIMOSA • Partnership with ISA • Partnership with PRODML • Collaboration with IEC • Collaboration with OAGi • Collaboration with EDDL • Collaboration with FDT • Collaboration with PLCOpen • Partnership/Collaboration with automation.com • Collaboration with MS MUG & NAMUR • Partnership with OPCconnect.com

  13. OPC UA Security • Client and Server hold X.509 v3 Certificates • How they are obtained is not defined by UA • GetSecurityPolicies to exchange certificates • RequestSecurityToken to create secure session

  14. OPC UA Security • Requirements • authentication • integrity • confidentiality • authorization • non-repudiation • availability

  15. OPC UA Security Threat Types • Message flooding • Eavesdropping • Message spoofing • Message alteration • Message replay • Malformed messages • Server profiling • Session hijacking • Rogue Client or Server • Compromising user credentials

  16. OPC UA Transport Profiles Message Encoding Layer UA XML UA Binary UA Binary WS Secure Conversation UA Secure Conversation Secure Channel Layer Message Transport Layer SOAP 1.2 SOAP 1.2 UA TCP HTTP/HTTPS HTTP/HTTPS TCP/IP • UA Stack Profiles: • XML Web Service (XML or UA Binary) • Native Binary (UA Binary, UA Secure Conversation, UA TCP) • Native Binary with SOAP/HTTP • Message Encoding: • UA XML = XML Schema + WSDL • UA Binary = OPC Binary Schema • Transport: • HTTP/HTTPS • TCP/IP XML Web Services Native Binary

  17. Windows Linux Windows Embedded OS UA - WCFClient 1 UA - Java Client 2 OPC-COM with UA Proxy Client 3 UA - ANSI CClient 4 Binary via HTTP/HTTPS Binary via UA TCP XML via HTTP/HTTPS XML/Binary via HTTP/HTTPS OPC UA Server for PI System OPC UA Server for PI System The PI System Internal Data Access Services Replication and Management Services PI Server Subsystems PI Notifications AF Server Event Frames

  18. SQL based Data Access

  19. Data Access - Overview PI Data is available via common standards Data Access RtBaseline Services for Thin Clients OLEDB ODBC OPC • WebServices (i.e. RtBaseline Services) – Provide Data to Web Applications • OLEDB – Data Access via SQL Queries • ODBC – Data Access via SQL Queries • OPC DA/HDA/UA – Data Access to the PI System via OPC Standard

  20. Data Access Via PI OLEDB PI OLEDB provider allows applications (OLE DB consumers) working with PI data through SQL queries: renew PI OLEDB Architecture introduce JDBC support „PI System“ OLE DB/COM Client Application PI Server SQL Engine SQL Queries OLE DB Consumer PI OLEDB Provider

  21. AF in the PI System • Data structured and organized by Assets • Spans multiple PI Systems • Incorporates non time series Data PI Server 1 PI Server 2 AF Vendor Specific Interfaces Vendor Specific Interfaces Generic Interfaces Generic Interfaces Asset-Equipment Centric access to the Data Honeywell Interface Honeywell Interface ABB Interface ABB Interface Delta-V Interface Delta-V Interface Rockwell Interface Rockwell Interface OPC Interface OPC Interface XML Interface XML Interface Modbus Interface Modbus Interface SNMP Interface SNMP Interface Time Series Data Sources Time Series Data Sources Non Time Series Data Sources … … … Honeywell Honeywell ABB ABB Delta-V Delta-V Rockwell Rockwell Other Other SCM RDBMS MES Time Series Data Time Series Data „Meta“-Data

  22. PI SQL DAS Network Network New Architecture • Multi-standard andmulti-platform architectureOne connection allows querying multiple data sources • Standard implementation separated from SQL functionality • Prepared for heterogenious query engine Consumer / Client Consumer / Client Consumer / Client Consumer / Client New SQLStandards ODBC (possible) OLE DB JDBC Third party data source PI Servers AF Database

  23. Consumer / Client Consumer / Client OLE DB JDBC PI SQL DAS PI DAS Network Network New Resource Management • Paging • Protects server from huge data requests • Decreases memory requirements • Caching • Smart memory management • PI SQL DAS Deployment optionsfor example: • 1x PI SQL DAS for Web Farm • 1x PI SQL DAS for Reporting • 1x PI SQL DAS for Clients Third party data source PI Servers AF Database

  24. Demo • Linux (ubuntu7.10) • DBVisualizerallows to access and explore any jdbc Driver • PI JDBC (Bridge)talking to PI OLEDB

  25. PI JDBC BridgeArchitecture Details PI JDBC PI OLEDB PI SQL DASprotocol Network • PI JDBC Bridge v1 • Windows + Linux 32bit • requires PI OLEDB • meant to support Java server apps Client Application C++Library Multi-Platform JDBC WCF RDSA RDSA WCF C++ PI Servers

  26. Demo

  27. PI SQL DAS Network PI System OLEDB v1 Architecture • Windows based • Linked to AF SDK • Access via AF Server Consumer PISysOLEDB AF SDK AF Server Third party data source PI Servers AF Server

  28. Development Roadmap - PI SQL DAS • PISysOLEDB v1 • OLE DB w. integrated PI SQL DAS • Mainly AF tables • Read-only • Release schedule ~ Q2/2009 • PI SQL DAS v2 • Server side PI SQL DAS • JDBC (Linux supported) • Event Frames • Release ~ 2010

  29. Examples: GoTo • Expo - Data Access: PI OLEDB, PISysOLEDB, JDBC Bridge • Learning Labs / Tutorials

More Related