Status message

The status topic is used by the Connector to inform the user whether the configurations of the Connector are correct.

The statustopic can be taken from the metadata.

A new status message is sent when the MSSQL Connector is started, restarted or the configuration changes.

The most recent status message is retained, so when a new connector connects to the SQL Connector, the newest status message will be published to it.

Example for bad configuration:

{
   "seq":0,
   "connector":{
      "status":"good"
   },
   "connections":[
      {
         "name":"Connection_1",
         "status":"bad"
          "reason":"Lost connection to database"
      }
   ]
}

Example for good configuration:

{
   "seq":0,
   "connector":{
      "status":"good"
   },
   "connections":[
      {
         "name":"Connection_1",
         "status":"good",
         "reason":""
      }
   ]
}