ABB Utilities — 1 2000 -06 SPIDER MR

APIs, Possibilities n What APIs do we have? n How can we use them for integration? n New functionality/project deviations n Future APIs © ABB Utilities - 2 - API = Application Program Interface

APIs, Possibilities n What APIs do we have? n DB Server API n Active. X COM DB Server API n ODBC APIs on different layers n © ABB Utilities - 3 - n After Sales opportunities

APIs, DB Server API n Supports a lot of functions: n n n n © ABB Utilities - 4 - n n Authority Start of SPIDER program (Avanti sndmsg) Read real time data including quality flags Read/update historical data including quality flags. Transparent UDW 200 or Avanti TTD Dynamic SQL Read/write server disk files Redundancy transparent for the user application etc. . . Available on multi platforms UNIX/VMS/Windows API is a DLL (Windows) or a shared library (UNIX/VMS)

APIs, Active. X DB Server API n Active. X COM DB Server API Functionality about the same as for the DB Server API n Excellent support for writing Visual Basic applications n © ABB Utilities - 5 - n Active Server Pages (ASP) support

© ABB Utilities - 6 - APIs, Active. X DB Server API

© ABB Utilities - 7 - APIs, Active. X DB Server API

APIs, ODBC n Supports a lot of functions: Authority Read/update real time data Read/update historical data including quality flags n Virtual tables => extremely easy to set up a query (you have to know something about the contents of the database) n Insert/Delete records in Avanti n Redundancy transparent for the user application n n Supported by MS Office n n n © ABB Utilities - 8 - n MS Query (to set up the select statement) MS Excel SPIDER Reports MS Access direct import of Avanti data Supports tools that support ODBC

© ABB Utilities - 10 - APIs on different layers

APIs, Possibilities for After Sales n After sales opportunities n Experience n NOINA has sold the ODBC-driver n SEUTA has sold Excel to SPIDER release 1 using DB Server API n DEUTA offers integration solutions by means of ODBC and DB Server API n n Product wrapping is needed n © ABB Utilities - 11 - supports old releases Identified and known for different releases

APIs, Possibilities for After Sales n After Sales opportunities (cont. ) n In priority (go for money) n Win a soft support upgrade contract n Look at integration aspects between different systems and SPIDER n Suggest different solutions Sell Excel using the report package n Sell ODBC driver n © ABB Utilities - 12 - n Sell DB Server API/DB Server API COM-version

APIs, Possibilities for integration How can we use the APIs for integration? n © ABB Utilities - 13 - n Here follows examples of what have been done in DEUTA

The business process: Exchange of information Network management Middle- and High voltage Network Management low voltage NMS/ CRMS EMS/ DMS/ SCADA Business Management BMS Common Business database Geographic Information Systems Trouble call TCMS Energy Management/ Load Management GIS LMS Customer Information systems © ABB Utilities - 14 - Utility Data Warehouse CIS Maintenance & servicing NIS Network completion & optimize NPS

Open System architecture Open Systems based on “independent“ Standards • Software portability: IEEE POSIX Operating System Interface • Standards on workplaces (Human Machine Interface, HMI) • Database server: Structured Query Language (SQL) • Database Interface to the Office-world (ODBC) • Communication standards: e. g. ISO/ OSI- Reference Model • Remote control system protocols : RP 570/ 571, IEC 870 -5 -104 © ABB Utilities - 15 - • . . .

Integration example EMS DE HMI SPIDER DE GUI WS 400 MDBE Oracle Expert Load Shedding DMS Cooperate Systems ICCP USI, ODBC, SQL SPIDER SCADA EMS Avanti Data Acquisition © ABB Utilities - 16 - PCG PCG RTU RTU RTU GIS External System * GIS RDBMS GIS DB * External System, for example NMS, Crew Management, Trouble Call Management, PC- Office System, etc.

Universal SCADA Interface USI Continuous growing demand ! Communication layer TCOM Adapter CLP NMS Adapter ESB © ABB Utilities - 17 - Data collector layer SCADA-near layer NMS Adapter NIE NIS Adapter TCOM Adapter HC

USI - Project example NIE SPIDER HMI Extern GUI separate workplaces/HMI Operator interface NMS Server SCADA Server Mutual call interface (HMI- Adapter) HOT STANDBY Online PDB TCP/IP Temporary Devices any DBSystem (SQL) “data mapping“ DMS Devices SCADA-Interface Logic gating connectivity Network model © ABB Utilities - 18 - Process connection SPIDER Network system Foreign system

USI - Project example NIS common workplace SPIDER HMI Foreign-GUI NT- Terminalserver HMI-client like Win. NT Hmi client e. g. UNIX E. g. . X- Window clients SCADA Server Mutual call interface (HMI- Adapter) HOT STANDBY Online PDB TCP/IP Temporary Devices any DBSystem (SQL) “data mapping“ DMS Devices SCADA-Interface Logical connection Network model © ABB Utilities - 19 - Process connection SPIDER Network system Foreign system

USI - Project example TCOM Common work place X- Window clients SCADA Server HOT STANDBY Online PDB SPIDER HMI Fremd-GUI MDBE UPDATE SQL-Net UPDATE (ORACLE) Trouble Call System Common Data entry TCP/IP Temporary Devices Outage Engine “data mapping“ DMS Devices SCADA-Interface Logic connection Network model © ABB Utilities - 20 - Process connection SPIDER Network control system Foreign system

SPIDER SCADA/ DMS as an open data resource (example) Database Server SPIDER Host Avanti Oracle SQL, ODBC, Web. Gate Oracle SQL, ODBC, USI, Web. Gate Intranet ABB- Services for: © ABB Utilities - 21 - UDW, Utility Data Warehouse SQL, ODBC, Web. Gate Intranet Firewall SQL, ODBC, Web. Gate • Interfaces, e. g. ODBC, SQL, Web. Gate and USI • Customization (usually required e. g. for ORACLE or MS- Office applications, etc. ) SQL, ODBC, USI External System Office Applications (ORACLE, EXCEL, Internet- Browser, etc. )

New “External Services“ for Utilities Network Control System Online - PDB IS 400, Web. Gate DIS/ DB- Server Avanti Web. Gate ORACLE Common Gateway Interface (CGI) Web Server Interface 4) 3) 2) “External Services“ Web Browser Web Client Interface Internet Service Provider Intranet © ABB Utilities - 22 - Firewall Internet

Utility Service Interfaces for the Business Process Improvements Remote Data Access: Web. Gate: • ODBC • SQL • DB- API • C- API • OPC • etc. Data Presentation and Data Access into “any“ external system of the network Programming Interfaces incl. format conversion Web Server Interface 4) “Utility Services“ e. g. SCRIPTS, Aplets, etc. 3) 2) Web Client Interface Intranet © ABB Utilities - 23 - HTML, (XML)- Document Any external system Interface (proprietary) formats & protocols Web Browser (“Thin Client“)

Our objectives • We help to optimize the business process four customers. • We use IT- technologies for the integration of different software-components. © ABB Utilities - 24 - s a real ti concep on n egratio k operati t ew IT-In n networ The n stone i Mile

APIs, Possibilities for integration n New functionality/project specials n Use the APIs to implement new functions like: n n Operators Diary (in the WS 400 NT) n n Stand alone calculations of various kind …. Use the APIs to implement project specials Supports upgrades of SPIDER (The API used is still supported in next release) n © ABB Utilities - 25 - n No messing up in standard implementation

APIs, Possibilities for integration n Future APIs n Many more APIs will come n Release independent n Also available on integration platforms SPIDER IDL (SIDL) n DAIS (OPC) n DAF/CIM n HMI third party API support n Java support via IIOP (Internet Inter-ORB Protocol) transport module will enable all coming SIDL based APIs to work with Java (RMI Remote Method Invocation) n © ABB Utilities - 26 - n JDBC support is possible to buy for the existing ODBC-driver

APIs, Possibilities for integration n SPIDER Interface Definition Language (SIDL) n Opens up the functions of SPIDER to the external world (compare MS) n Supports different hardware as well as different platforms n Supports loose coupling of functions n Compare with MS closed to an open environment Good performance n To guide and support development n Promotes modules/components n © ABB Utilities - 27 - n It is an ongoing development project (C-28)

SPIDER IDL Framework Presentation n The framework is a ‘middleware’ with similarities to COM and CORBA but differs in some areas. n Similarities n IDL (SIDL) n Name Server n Support at least two of the three OO criteria's n n Polymorphism n n Encapsulation (Inheritance (not supported by COM, only as aggregates)) Differences Supports system configuration and supervision n High performance although very flexible n © ABB Utilities - 28 - n Ease of use, low threshold for new users n Supports heterogeneous networks (as do most CORBA impl)

SPIDER IDL Framework Presentation Internal example Client Command Dialog Server Process Interface Client Command Presentation Get. Status. Change Client Filter Get. Status. Change Client Data flow, media transparent (local, LAN, WAN) © ABB Utilities - 29 - Method Invocation Interface Event Interface Equipment Statistics

SPIDER IDL Framework Presentation Third party software example Client Command Dialog Server Process Interface Excel Command Get. Status. Change Active. X Object Get. Status. Change Bridge to COM Data flow, media transparent (local, LAN, WAN) © ABB Utilities - 30 - Method Invocation Interface Event Interface ‘Normal’ COM Interface

APIs, DAIS n OMG DAIS (Data Acquisition for Industrial Systems) Is a becoming standard n Initiated by ABB n Subscription of process data n Compatible with OPC (process data) n Used in the SPIDER Cadops integration n © ABB Utilities - 31 - n Based on the SPIDER IDL Framework

APIs, DAF/CIM n OMG Utility Management Systems DAF (Data Access Facility) n API for retrieval of data according to the structure defined in CIM (Common information Model) n Mapping of CIM and Avanti structures Ongoing work in US as well as in Sweden n © ABB Utilities - 32 - n Publishing via a DAF API