1 / 32

APIs for integration

APIs for integration. APIs, Possibilities. What APIs do we have? How can we use them for integration? New functionality/project deviations Future APIs API = Application Program Interface. APIs, Possibilities. What APIs do we have? DB Server API ActiveX COM DB Server API ODBC

james-conner
Download Presentation

APIs for integration

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. APIs forintegration

  2. APIs, Possibilities • What APIs do we have? • How can we use them for integration? • New functionality/project deviations • Future APIsAPI = Application Program Interface

  3. APIs, Possibilities • What APIs do we have? • DB Server API • ActiveX COM DB Server API • ODBC • APIs on different layers • After Sales opportunities

  4. APIs, DB Server API • DB Server API • Supports a lot of functions: • 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)

  5. APIs, ActiveX DB Server API • ActiveX COM DB Server API • Functionality about the same as for the DB Server API • Excellent support for writing Visual Basic applications • Active Server Pages (ASP) support

  6. APIs, ActiveX DB Server API

  7. APIs, ActiveX DB Server API

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

  9. APIs, ODBC

  10. APIs on different layers

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

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

  13. APIs, Possibilities for integration • How can we use the APIs for integration? • Here follows examples of what have been done in DEUTA

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

  15. 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 • ...

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

  17. Communication layer Data collector layer SCADA-near layer Universal SCADA Interface USI Continuous growing demand ! TCOMAdapterHC NISAdapter NMSAdapterNIE TCOMAdapterCLP NMSAdapterESB

  18. Mutual call interface (HMI- Adapter) connectivity Network model USI - Project example NIE SPIDER HMI Extern GUI separate workplaces/HMIOperator interface NMS Server SCADA Server any DB- System (SQL) Online PDB TCP/IP HOT STANDBY TemporaryDevices “data mapping“ DMS Devices SCADA-Interface Logicgating Process connection Foreign system SPIDER Network system

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

  20. UPDATE UPDATE USI - Project example TCOM SQL-Net Common work place SPIDER HMIFremd-GUI SPIDER HMIFremd-GUI X- Window clients TroubleCallSystem MDBE (ORACLE) SCADA Server Online PDB CommonData entry Outage Engine TCP/IP HOT STANDBY TemporaryDevices “data mapping“ DMS Devices SCADA-Interface Logic connection Network model Process connection Foreign system SPIDER Network control system

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

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

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

  24. The new IT-Integration concept is a real Milestone in network operation Our objectives • We help to optimize the business process four our customers. • We use IT- technologies for the integration of different software-components.

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

  26. APIs, Possibilities for integration • Future APIs • Many more APIs will come • Release independent • Also available on integration platforms • SPIDER IDL (SIDL) • DAIS (OPC) • DAF/CIM • HMI third party API support • 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) • JDBC support is possible to buy for the existing ODBC-driver

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

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

  29. SPIDER IDL Framework Presentation Internal example Client Command Dialog Client Server Command Presentation Process Interface GetStatus StatusChange Client GetStatus Filter StatusChange Client Equipment Statistics Data flow, media transparent (local, LAN, WAN) Method Invocation Interface Event Interface

  30. SPIDER IDL Framework Presentation Third party software example Client Client Command Dialog Excel Server Command Process Interface GetStatus StatusChange ActiveX GetStatus Object StatusChange Bridge to COM Data flow, media transparent (local, LAN, WAN) ‘Normal’ COM Interface Method Invocation Interface Event Interface

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

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

More Related