Agent for Microsoft SQL databases

    HomeAlarm Control CenterThe ComponentsThe agentsAgent for Microsoft SQL databases

    Interface between
    Microsoft SQL databases and Alarm Control Center

    The agent for Microsoft SQL databases (MS SQL) creates messages based on entries in configurable SQL tables. These messages are then sent by Alarm Control Center (ACC) to the responsible persons. The agent supports all current Microsoft SQL Server.

    The following systems can be connected, among others:

    • zenon8.00
    • Wonderware ArchestrA
    Agent for Microsoft SQL databases
    Agent for Microsoft SQL databases

    Interface between Microsoft SQL databases and Alarm Control Center

    The agent for Microsoft SQL databases (MS SQL) creates messages based on entries in configurable SQL tables. These messages are then sent by Alarm Control Center (ACC) to the responsible persons. The agent supports all current Microsoft SQL Server.

    The following systems can be connected, among others:

    • zenon8.00
    • Wonderware ArchestrA
    Agent for Microsoft SQL databases

    Communication via the SQL database

    If a new entry is added to the configurable SQL table, the MS SQL agent is informed about it. The agent then generates a message for the Alarm Control Center and the participants are alerted.

    If the message is processed or acknowledged, the agent can trigger “Message gone” and the corresponding column in the SQL table is updated.

    The MS SQL agent documents all events surrounding a message, such as alarms and acknowledgments by participants, in a configurable SQL table.

    Agent for Microsoft SQL databases

    Communication via the SQL database

    If a new entry is added to the configurable SQL table, the MS SQL agent is informed about it. The agent then generates a message for the Alarm Control Center and the participants are alerted.

    If the message is processed or acknowledged, the agent can trigger “Message gone” and the corresponding column in the SQL table is updated.

    The MS SQL agent documents all events surrounding a message, such as alarms and acknowledgments by participants, in a configurable SQL table.

    Automatic database cleanup

    If the number of entries in the table exceeds a specified number, the database is automatically cleaned up.

    Agent for Microsoft SQL databases
    Agent for Microsoft SQL databases

    Automatic database cleanup

    If the number of entries in the table exceeds a specified number, the database is automatically cleaned up.

    Agent for Microsoft SQL databases

    Increased reliability with the Monitoring option

    Increased reliability is ensured by the ACC  Monitoring option. The option monitors all functions of the Alarm Control Center and also provides the following functionalities for the MS SQL agent:

    • Control system availability: It is checked whether the control system is functional and correctly connected to the ACC.
    • Message volume: It tests whether the number of messages per second in the agent's queue exceeds a configured limit.
    Agent for Microsoft SQL databases

    Increased reliability with the Monitoring option

    Increased reliability is ensured by the ACC  Monitoring option. The option monitors all functions of the Alarm Control Center and also provides the following functionalities for the MS SQL agent:

    • Control system availability: It is checked whether the control system is functional and correctly connected to the ACC.
    • Message volume: It tests whether the number of messages per second in the agent's queue exceeds a configured limit.

    Would you like to find out more about our agent for Microsoft SQL databases?

    Contact us. We are happy to help.

    to the contact form
    ×

    Please fillup the details first to download


    en_USEnglish