What's New in HiveMQ 4.33?

The HiveMQ team is excited to announce the release of HiveMQ Enterprise MQTT Platform 4.33 featuring our new HiveMQ Enterprise Extension for Microsoft SQL Server. This release also delivers numerous enhancements designed to boost usability and observability.

NOTE: Release 4.28 is HiveMQ’s latest LTS release. With the HiveMQ 4.33 release, we sunset maintenance of our previous LTS version 4.9 (September 2022).

Highlights

• New HiveMQ Enterprise Extension for Microsoft SQL Server

HiveMQ Enterprise Extension for Microsoft SQL Server

This month, we are excited to introduce our latest HiveMQ platform extension: the HiveMQ Enterprise Extension for Microsoft SQL Server. This new addition to the HiveMQ platform bundle lets you store your MQTT data into the Microsoft Relational Database Management System (RDBMS) SQL Server. Microsoft SQL Server and Azure SQL are popular databases widely used in Microsoft environments and setups for data processing, storage, and analytics. Our new extension lets you integrate with SQL Server and Azure SQL to leverage the full value of your existing infrastructure.

How it works

The HiveMQ Enterprise Extension for Microsoft SQL Server supports unidirectional message flows from MQTT clients via the HiveMQ broker to the Microsoft SQL Server and Azure SQL databases. The extension can be configured to forward messages from MQTT topics to one or more database tables. Convenient insert statements help you easily write MQTT data and metadata into target database table columns.

Example HiveMQ Enterprise Extension for Microsoft SQL Server configuration file:

<hivemq-microsoft-sql-server-extension>
    <mssqls>
        <mssql>
            <id>my-mssql-id</id>
            <server-name>my.host.com</server-name>
            <port>1433</port>
            <database>my-database</database>
            <authentication>
                <basic>
                    <username>my-user</username>
                    <password>my-password</password>
                </basic>
            </authentication>
        </mssql>
    </mssqls>
    <mqtt-to-mssql-routes>
        <mqtt-to-mssql-route>
            <id>my-mqtt-to-mssql-route-insert</id>
            <mssql-id>my-mssql-id</mssql-id>
            <mqtt-topic-filters>
                <mqtt-topic-filter>#</mqtt-topic-filter>
            </mqtt-topic-filters>
            <processor>
                <insert-statement>
                    <table>mqtt_to_mssql_table</table>
                    <columns>
                        <column>
                            <name>topic</name>
                            <value>mqtt-topic</value>
                        </column>
                        <column>
                            <name>payload_utf8</name>
                            <value>mqtt-payload-utf8</value>
                        </column>
                    </columns>
                </insert-statement>
            </processor>
        </mqtt-to-mssql-route>
    </mqtt-to-mssql-routes>
</hivemq-microsoft-sql-server-extension>

For detailed information on how to configure the new extension to meet your business needs, see our HiveMQ Enterprise Extension for Microsoft SQL Server documentation.

How it helps

Adding to the existing HiveMQ integrations for popular databases, data streaming platforms, and data lakes, the Microsoft SQL Server extension further expands your ability to write MQTT data to the database of your choice.

More Noteworthy Features and Improvements

HiveMQ Enterprise MQTT Broker

• Reduced the number of message availability notifications sent to connected clients for shared subscriptions to prevent unnecessary resource usage.
• Refined the audit log statements that actions in the control center generate to provide clearer feedback.

HiveMQ Data Hub

• Added the ability to define an init function in transformation scripts to declare branches proactively.
• Added Arm64 Linux support for Data Hub scripting.
• Fixed an issue with the handling of Control Center policy update ETags to ensure that previously updated policies can be updated/deleted in the Control Center and REST API as expected.
• Adjusted handling of scripts that do not utilize the addPublish functions to enhance performance.

HiveMQ Enterprise Extension for MySQL

• Improved log statements to reduce ambiguity on batch operations that span multiple topics.

HiveMQ Enterprise Extension for PostgreSQL

• Improved log statements to reduce ambiguity on batch operations that span multiple topics.

HiveMQ Platform (general)

• SHA256 checksums are now published for every release artifact on releases.hivemq.com and a .sha256 file ending is appended to each artifact file name.
• The OpenAPI documents for the HiveMQ Enterprise MQTT Broker and HiveMQ Swarm are now published as release artifacts on releases.hivemq.com and are appended with an -openapi.yaml file ending.

Get Started Today

To upgrade to HiveMQ 4.33 from a previous HiveMQ version, follow our HiveMQ Upgrade Guide. To learn more about all the features the HiveMQ Platform offers, explore the HiveMQ User Guide.