Configure Explicit Attributes for Integration Service Output

When the gateway output is configured to use AVEVA Integration Service, you can define explicit attributes for each supported context. Explicit attributes are additional named columns that are appended to the data published to the Integration Service, with values derived from PML expressions evaluated per element.

Note: Explicit attributes are available for Integration Service output only.

An explicit attribute defines an additional column in the data published to the Integration Service. For each element processed in a context (for example, each row in a Grid or Database View):

• The Name of the explicit attribute becomes the column name in the published table.

• The Value source is a PML expression that is evaluated per element to produce the row cell value for that column.

Explicit attribute columns are always placed at the beginning of the published table, before any other columns.

Note: If the context already contains a column with the same name as an explicit attribute, the explicit attribute overrides that column. The published value will be the result of the explicit attribute's value source, not the original column value.

Note: If a PML expression cannot be evaluated for a particular element, the corresponding cell is left empty. Evaluation failures are not logged.

To add an explicit attribute for a context:

1. Open the export configuration.

2. Select the context to configure (for example, Grids or Database Views for Engineering Gateway, or Draw or Model for E3D gateways).

3. Ensure the output type is set to Integration Service. The Explicit Attributes settings are only shown when Integration Service output is selected.

4. Select Add in the Explicit Attributes section, .

   

5. Enter the following required properties:

   1. Name: The name of the explicit attribute. This becomes the column name in the published table.

   2. Value: A PML1 or PML2 expression evaluated per element to produce the column value.

6. Save the configuration.

Edit or Delete an Explicit Attribute

7. To Edit an existing explicit attribute, select it in the Explicit Attributes list and modify the Name or Value source as required.

8. To remove an explicit attribute, select it in the Explicit Attributes list and select Delete.

   

Example:

The following example adds Name and Class as explicit attribute columns to a Grid context, so that every row published to the Integration Service includes the element name and class alongside the grid data:

With this configuration, the published table will have Name and Owner Name as the first two columns, followed by the remaining grid columns.