Universal Data Adapter

1
Universal Data Adapter

• Ray Verhoeff

2
Agenda

• Features and Benefits
• How does it work?
• Building UDA points
• Systems supported
• Deploying UDA
• Writing a COM Connector

3
UDA Architecture
PIArchive
COM Connectors
Foreign Historians
4
Client Applications

• Supports all client software
• Any PI-API and PI-SDK application, including yours

5
Interfaces

• Supports all interfaces
• as long as foreign data system can support insert
  of data

6
How does it work?
Client Connections
7
Snapshot from PI
Request
PI NetMgr
Response
RPC Call
Snapshot
RPC Response
Snapshot Array
8
Snapshot from UDA
Request
PI NetMgr
Response
RPC Call
Snapshot
RPC Response
COM call
Return Data
COMConnector
Foreign Data System
9
COM Connector
COM Object
IPIUDAPointConnector
IPIUDASnapshotConnector
IPIUDAHistoryConnector
Foreign API
Foreign Data System
10
Defining UDA Points

• Three identifying point attributes
• uda_progid
• String
• Name of COM object
• uda_strmap
• String
• uda_lmap
• Integer

11
Defining UDA Points

• Two point attributes insufficient?
• Developers are free to define additional
  attributes
• Use PI-SDK or PI-API to call back into PI
• COM Connector provided with connect back
  information
• name of system and TCP/IP port

12
Point Building

• Currently, build points using available PI tools
• piconfig
• Tag Configurator
• Honeywell PHD
• udaphdbuild utility

13
Auto Point Sync

• New product to synchronize PI and UDA databases
  with DCS database
• edit, delete, create

14
Auto Point Sync

• Three Modules
• GUI to configure rules settings
• Sync Engine to monitor DCS for changes
• APS Connector to get DCS database information
  (DCS specific)
• Communication between three modules is based on
  COM
• APS Runs on NT

15
APS Connectors

• APS Connectors implemented on NT
• Vendor API on NT
• Vendor API on VMS UNIX
• DCE RPC

16
APS Connectors

• Fisher-Rosemount CHIP
• OSI PItoPI
• Honeywell PHD
• NT-based interfaces first

17
APS Future

• Initial release synchronizes existing interface
  points (edit, delete)
• Second release provides point creation
• APS development will be integrated with standard
  interface development

18
Point Building for UDA

• APS can monitor Foreign System
• Create new UDA mapped points
• APS-defined interface could be exposed by COM
  Connector

19
Hybrid Systems

• UDA can host native points
• Calculated points
• Batch points
• Alarm points

20
OSI-provided COM Connectors

• Honeywell PHD
• Microsoft OLE DB
• Aspen Tech CIMIO
• IP/21, InfoPlus, InfoPlusX
• Aspen Tech CIM/21
• ABB Enterprise Historian

21
Possible COM Connectors

• Foxboro Historian
• Westinghouse Historian
• Wonderware
• Westinghouse Enterprise Process Historian

22
Deployment - 1 UDA
UDA
PHD
PointX
PointX
PHD sees 1 client
Client connections
23
Deployment - 2 UDAs
UDA
PointX
Client connections
PHD
PointX
UDA
PHD sees 2 clients
PointX
Client connections
24
Deployment - n UDAs
UDA
UDA
UDA
UDA
PHD
UDA
PHD sees n clients
UDA
UDA
25
Multiple Snapshot Calls

• Situation Many clients call for a snapshot of a
  single point
• Does this mean many calls to the COM Connector?

26
Multiple Snapshot Calls

• Snapshot subsystem signs up for exceptions in the
  Connector
• Exceptions received from the Connector are stored
  in PIs snapshot
• The multiple client calls are resolved in the PI
  snapshot

27
Building a COM Connector

• COM object written to OSI specifications
• Only software component coded to interact with
  foreign data system
• Spec will be published
• enable you to build COM Connectors to proprietary
  data systems

28
Building a COM Connector

• You will be expected to implement
• get snapshot
• put snapshot
• get archive values
• compressed
• interpolated
• timed
• plottable

29
Building a COM Connector

• You will be expected to implement
• Sign-up/unsign-up for exceptions
• get exceptions

30
Building a COM Connector

• Buildable using C, VB
• uses COM Variant data types
• PI coerces result into PI internal data type
• Exception PI Digital Tags
• COM Connector responsible for translating foreign
  string to Digital code

31
Questions?