File-based data - How to send XML and Database data via MQTT¶

In this walkthrough, you’ll be guided step-by-step how file-based (XML) data can be enriched with supplementary information from a database (SQL) and then published on a MQTT broker.

By the end, you’ll have a comprehensive understanding of:

• Data Modelling and Channel configuration for the following Channel types:

  • File Reader (JSON)

  • SQL Database

  • MQTT (JSON)

• Mapping creation including:

  • Using Commands and their replies

  • Realising type conversion and date formatting

Let’s dive in!