Assignment of Destination System Variables (ODBC Destination System)

Prerequisites

You have created a notification and automatically generated the output values on the Output tab by choosing the Generate Expressions pushbutton.

Context

In this processing step, you need to assign the output values of the notification to the variables of the ODBC destination system that you created on the Configuration tab. (See: ODBC Destination System: Configuration Tab. This is the prerequisite for the connected database table being filled with tag values as soon as the agent instance is running.

Procedure

  1. Click the Add Destination System pushbutton on the Destinations tab.

    The Add Destination System dialog box appears.

  2. In the Destination System field, select the ODBC destination system that you created previously.
  3. In the Name field, enter a name of your choice for the destination system and choose OK.

    The system now displays the destination system in the Destinations screen area.

  4. Expand the entry for the destination system and click on Output Destination Mapping.

    The assignment table containing the destination system variables of the ODBC destination system opens on the right. The table consists of four columns with the following meaning:

    Column

    Meaning

    Destination System Variable

    The name of the variable that you created previously on the Configuration tab of the ODBC destination system is displayed here. (See: ODBC Destination System: Configuration Tab.)

    SQL Type

    The SQL type of the destination system variable is displayed here, for example, NVARCHAR.

    Notification Output

    For each variable, choose an appropriate output value from the dropdown box.

    Attribute

    For each variable, choose an appropriate attribute from the dropdown box. You can choose from the following four attributes:

    • Time Stamp

      The time stamp of the last change to the output value

    • Quality

      The quality of the output value, for example, Good or Bad

    • Value

      The actual value of the output value

    • Output Name

      The name of the output value

    • Source

      The source of the tag on which the output value is based. This attribute is taken from the subscription item, provided the expression for the output value contains exactly one subscription item.

    PCo checks if the assignment is correct and issues a corresponding error message if necessary.
  5. Assign each destination system variable a value in the Notification Output column and an Attribute.

    After you have made the assignment, the table looks like this, for example:

    Destination System Variable

    SQL Type

    Notification Output

    Attribute

    TS1

    TIMESTAMP

    Int1

    Timestamp

    VAL1

    NVARCHAR

    Int1

    Value

    TS2

    TIMESTAMP

    Int2

    Timestamp

    VAL2

    NVARCHAR

    Int2

    Value
  6. Save the assignments.

Results

You can now start your agent instance in the PCo Management Console. PCo transfers the current tag values to the database table. You can now check, for example, in the SAP HANA Studio, if the new data records have arrived in your history table.