Integration technologies

The following sections discuss the integration technologies available in PME.

warning

potential compromise of System availability, integrity, and confidentiality

Use cybersecurity best practices to help prevent unauthorized access to the software.

Failure to follow these instructions can result in death, serious injury, equipment damage, or permanent loss of data.

Work with facility IT System Administrators to ensure that the system adheres to the site-specific cybersecurity policies.

Open Platform Communications (OPC)

OPC is an industry standard for data exchange between software applications and control devices from different manufacturers. The OPC standard includes separate specifications for different data types. PME supports the OPC Data Access (DA) specification, OPC DA 2.05a, which is used for real-time data.

PME includes an OPC server and an OPC client, which means it can export and import real-time data to or from another system.

The following shows an example where the OPC server capabilities in PME are used to share device real-time data with another application:

The following shows an example where the OPC client capabilities in PME are used to bring device real-time data into PME from another application:

See OPC Server Support for more information.

RECOMMENDATION: Use an OPC tunneling application for OPC data exchange over a network

EcoStruxure Web Services (EWS)

EWS is a Schneider Electric standard for sharing data between EcoStruxure™ software platforms. It is based on SOAP 1.2, an industry standard Web Services technology.

PME includes an EWS server, which means that EWS can be used to export real-time data, historical data, and alarms from PME to another system.

PME includes an EWS client, which means that EWS can be used to import historical data and alarms data into PME from another system.

Visit the Exchange Community Web site for more information on EWS. See Resources for contact information.

 

Extract Transform Load (ETL)

The ETL is a proprietary software application that copies historical data from one data store to another data store. During the copy process, the ETL can modify the data, to make it fit the target data store or target application. The ETL can be used to copy data as a one-time transaction, or it can be scheduled to copy data automatically on an ongoing basis.

The following graphic shows the data source and target stores and formats that are supported by the ETL:

Visit the Exchange Community Web site for more information on ETL. See Resources for contact information.

Open Database Connectivity (ODBC)

ODBC is a standard application programming interface (API) for accessing database management systems (DBMS). PME is ODBC-compliant, which makes it possible to access any historical data in the PME database from any other, ODBC-compliant application. See Accessing the ION Database with 3rd-party applications for an example using Microsoft Excel to access data in the PME database.

Power Quality Data Interchange Format (PQDIF)

PQDIF is a standard power quality data interchange format for exchanging power quality data between software applications and monitoring devices. PME can export power quality data in PQDIF format. See PQDIF Exporter for more information.

Virtual Processor (VIP)

The VIP is a PME component. Use the VIP for data import, data export, data processing, and control functions. It supports a variety of protocols and standards. See Virtual Processor service (VIP) for more information. The following protocols and formats are supported by the VIP:

Data Import

  • ION
  • Modbus
  • XML web pages
  • SQL databases

Data Export

  • ION
  • SQL Databases
  • SMTP email
  • SMS text
  • .exe program