Integrations — take your data to the tools you use
MergenHub opens the data it collects in the field to reporting tools, databases, cloud and messaging services and other software. All of it is included in every package; no extra connector or extra license is needed. Each card has the short steps of the connection.
Let them read: Power BI, Excel, Grafana and OPC UA clients read the data from MergenHub. Push: Data Bridge agents push the data to an MQTT broker or a REST address. Write: the Data Logger writes history to a SQL Server, MySQL, PostgreSQL or ODBC database.
The same security on every path
External tools cannot exceed the user's permissions: the analytics access key only reads and expires, the REST server endpoint asks for credentials by default, and connection passwords and tokens are stored encrypted on disk.
Analytics and reporting
Power BI, Excel and Grafana
Logged history and live values are read without setting up a separate database. The external tool connects with a read-only access key; the key is created under Settings › Data Bridge and shown once.
OData v4
Power BI
Tags, Current and History tables; ready-made Power Query code.
Settings › Data Bridge › Power BI · Excel card › Open; Create key.
In Power BI Desktop: Get Data → Blank query → Advanced Editor.
Paste the Power Query code from the page; the key comes filled in.
Pick the Tags, Current and History tables. Scheduled refresh needs an on-premises data gateway.
To the cloud and third-party systems over MQTT and REST
It runs as a separate Windows service; a slow endpoint never affects scanning. No agent is enabled by default. Any cloud platform, data lake or software with an MQTT broker or an HTTP endpoint connects through these agents.
MQTT push
Publish to an MQTT broker
Selected tags are published to a topic as JSON; two-way with a write topic.
Settings › Web & Connectivity › Data Bridge › MQTT push; Add Agent, type MQTT Client.
Broker address, port (8883 and a certificate for TLS), topic and QoS.
Pick the tags; publish periodically or on change only.
The Status tab shows the connection, last publish and last error.
The connection is defined once as a data source (Settings → Data sources); log groups and counter data select it by name. A missing table is created on the first write. While the target is down, records wait locally and are transferred in order when the connection returns.
Data source
Microsoft SQL Server
SQL Server login or Windows authentication.
Settings → Data sources › New data source, type card SQL Server.
Server, Port (empty = 1433), User, Password; or Windows authentication.
Database: List, or type a name and Create; Test connection, Save.
Data Logger › Add Log Group › pick it in the Data source box.
Alarms, data source warnings and automation steps go to chat channels as messages (in addition to e-mail and SMS). Where: Settings → Notifications → Chat notifications. The webhook address, bot token and access key are stored encrypted on disk.
Webhook
Slack
Alarm messages to a Slack channel.
In Slack, create an app, turn on Incoming Webhooks and pick the channel.
Copy the https://hooks.slack.com/services/… address.
In MergenHub, Send to Slack, paste the address, Save.
Send a test message: a message should appear in the channel.
In the trial every feature is enabled and there is no tag limit; you can try the Power BI, Grafana, database and notification connections in your own environment.
Tell us who you are so we can inform you about new releases and help with commissioning. The download starts immediately.
Windows 10/11 · Server 2016+ · 380.9 MB — Your details are never shared with third parties. Unlicensed installs run as a free demo (all features, no tag limit; 2-hour runtime per start).
Also on your phoneMergenHub Mobile for iOS and Android: alarms, live values and SCADA screens. No extra license.