New features and enhancements
- Last UpdatedNov 24, 2025
- 4 minute read
MES Cloud integration (Version 8.1.0) includes the following components for extracting on-premises MES data and publishing it to CONNECT data services:
-
AVEVA Events to CONNECT agent: The AVEVA Events to CONNECT agent provides the connectivity to CONNECT data services and enables the publishing of MES events from the MES Curation Service. The AVEVA MES Cloud integration solution must be used with this component. AVEVA Events to CONNECT is included as a separate install and configuration.
-
MES Curation Service: The MES Staging Curation service is a Windows service that provides two main functions:
-
Extracting (curating) data from the MES database and storing it in a staging schema. The MES Staging Curation Service supports publishing of MES events from util_history, job_history, job_hour_history, shift_history, wo, job, job_bom, item_prod, item_cons, job_events, job_route, lot, sublot, item_inv, item_transfer, storage_ent_transfer, receipt, receipt_lot, shipment, shipment_lot, po, po_line, so, so_line, sample, result, sample_char_link (containing sample_char_rule_link records), and bottleneck_history. All necessary context information such as entity, items, utilization reasons, characteristics, QM specifications, and production lines are also included.
For detailed information on the CONNECT data services types supported by this release of MES Cloud integration, see the tables below.
-
Providing a Web API interface for the AVEVA Events to CONNECT agent. The agent periodically requests event data from the MES Curation Service including context information. When data is available, it is sent to CONNECT data services event storage.
-
-
CONNECT visualization: Within the AVEVA Cloud Platform, the visualization of the published data is through pre-built widgets. New widgets to visualize the additional published data will be released incrementally in the future.
CONNECT data services types supported by MES in this release
The following table lists the types in CONNECT data services supported by MES in this release. The last two columns contain the supported actions for the types listed.
|
CONNECT data services Type Id |
MES Table |
Upserts |
Deletes |
|---|---|---|---|
|
Asset |
ent |
Yes |
Yes |
|
MESCustomer |
cust |
Yes |
Yes |
|
MESEquipmentUtilizationHistory |
util_history |
Yes |
Yes |
|
MESEquipmentUtilizationReason |
util_reas |
Yes |
Yes |
|
MESEquipmentUtilizationReasonGroup |
util_reas_grp |
Yes |
Yes |
|
MESEquipmentUtilizationState |
util_state |
Yes |
Yes |
|
MESJobHourlyResponse |
job_hour_history |
Yes |
No |
|
MESJobOrder |
job |
Yes |
Yes |
|
MESJobOrderRoute |
job_route |
Yes |
Yes |
|
MESJobOrderStateHistory |
job_event |
Yes |
No |
|
MESJobResponse |
job_history |
Yes |
No |
|
MESJobResponseState |
job_state |
Yes |
Yes |
|
MESLocation |
site |
Yes |
Yes |
|
MESMaterialClass |
item_class |
Yes |
Yes |
|
MESMaterialConsumedActual |
item_cons |
Yes |
Yes |
|
MESMaterialConsumedActualProperty |
job_event |
Yes |
No |
|
MESMaterialDefinition |
Item |
Yes |
Yes |
|
MESMaterialGrade |
item_grade |
Yes |
Yes |
|
MESMaterialInventory |
item_inv |
Yes |
Yes |
|
MESMaterialInventoryTransfer |
item_transfer |
Yes |
No |
|
MESMaterialLot |
lot |
Yes |
Yes |
|
MESMaterialLotStatus |
item_state |
Yes |
Yes |
|
MESMaterialOrderLine1 |
po_line_so_line |
Yes |
Yes |
|
MESMaterialOrderMovement2 |
receipt_lot_shipment_lot |
Yes |
Yes |
|
MESMaterialProducedActual |
item_prod |
Yes |
Yes |
|
MESMaterialProducedActualProperty |
job_event |
Yes |
No |
|
MESMaterialReason |
item_reas |
Yes |
Yes |
|
MESMaterialReasonGroup |
item_reas_grp |
Yes |
Yes |
|
MESMaterialSublot |
sublot |
Yes |
Yes |
|
MESOperationsMaterialBill |
job_bom |
Yes |
Yes |
|
MESPerson |
user_name |
Yes |
Yes |
|
MESProductionLine |
line |
Yes |
Yes |
|
MESProductionLineAsset |
line_ent_link |
Yes |
Yes |
|
MESProductionLineBottleneckHistory |
bottleneck_history |
Yes |
No |
|
MESQASPCRule |
spc_rule |
Yes |
No |
|
MESQASPCStatistic |
stats |
Yes |
No |
|
MESQATestCategory |
category |
Yes |
Yes |
|
MESQATestSample |
sample |
Yes |
Yes |
|
MESQATestSampleCharacteristic |
sample_char_link |
Yes |
Yes |
|
MESQATestSampleCharacteristicResult |
result |
Yes |
Yes |
|
MESQATestSpecification |
qm_spec |
Yes |
Yes |
|
MESQATestSpecificationCharacteristic |
qm_spec_char_link |
Yes |
Yes |
|
MESShiftDefinition |
shift |
Yes |
Yes |
|
MESShiftHistory |
shift_history |
Yes |
No |
|
MESStorageLocationMovement |
storage_ent_transfer |
Yes |
Yes |
|
MESTrait |
ent |
Yes |
Yes |
|
MESUnitOfMeasureConversion |
uom_conv |
Yes |
Yes |
|
MESUnitOfMeasureDefinition |
uom |
Yes |
Yes |
|
MESWorkRequest |
wo |
Yes |
Yes |
1po_line_so_line pulls data from the tables po, po_line, so, so_line.
2receipt_lot_shipment_lot pulls data from the tables receipt, receipt_lot, shipment, shipment_lot.
CONNECT data services types with entity capabilities in this release
The following table lists the CONNECT data services types supported by MES that have entity capabilities. Types with entity capabilities have AssetSupportedType set in the Asset Framework for this release.
If an entity capability is removed after the entity has been created in CONNECT data services, the MESTrait will be removed, but the AssetSupportedType will remain to cover scenarios where event data was already published related to the capability.
|
CONNECT data services Type Id |
Description |
|---|---|
|
MESEquipmentUtilizationHistory |
Entities in MES that can capture utilization data will be returned as part of this Type Id. |
|
MESJobHourlyResponse |
Entities in MES that can track OEE will be returned as part of this Type Id. |
|
MESJobResponse |
Entities in MES that can run jobs will be returned as part of this Type Id. |
|
MESJobOrderStateHistory |
Entities in MES that can run jobs will be returned as part of this Type Id. |
|
MESMaterialConsumedActual |
Entities in MES that can run jobs will be returned as part of this Type Id. |
|
MESMaterialConsumedActualProperty |
Entities in MES that can run jobs will be returned as part of this Type Id. |
|
MESMaterialInventory |
Entities in MES that can store will be returned as part of this Type Id. |
|
MESMaterialInventoryTransfer |
Entities in MES that can store will be returned as part of this Type Id. |
|
MESMaterialProducedActual |
Entities in MES that can run jobs will be returned as part of this Type Id. |
|
MESMaterialProducedActualProperty |
Entities in MES that can run jobs will be returned as part of this Type Id. |
|
MESQATestSample |
Entities in MES that can capture quality will be returned as part of this Type Id. |
|
MESQATestSampleCharacteristic |
Entities in MES that can capture quality will be returned as part of this Type Id. |
|
MESQATestSampleCharacteristicResult |
Entities in MES that can capture quality will be returned as part of this Type Id. |
|
MESShiftHistory |
Entities in MES that can change shifts will be returned as part of this Type Id. |
|
MESStorageLocationMovement |
Entities in MES that can store will be returned as part of this Type Id. |
|
MESTrait |
All entities in MES will be part of this Type Id. |
New features and enhancements
This release of MES Cloud integration includes the following new features and enhancements:
-
Adds support for the publishing of MES Quality events and reference types.
-
Adds support for the publishing of MES Production Line events and reference types.