MergenHub Envest Live demo
Home/Integrations/Integrations
Overview · Integrations

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.

← All protocols & modules

Three ways out

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.

Power BI
OData v4

Power BI

Tags, Current and History tables; ready-made Power Query code.

  1. Settings › Data Bridge › Power BI · Excel card › Open; Create key.
  2. In Power BI Desktop: Get Data → Blank query → Advanced Editor.
  3. Paste the Power Query code from the page; the key comes filled in.
  4. Pick the Tags, Current and History tables. Scheduled refresh needs an on-premises data gateway.
OData v4

Excel

The same OData feed as Power BI; the Excel query refreshes on demand.

  1. Create the key in the same place as for Power BI: the Power BI · Excel card.
  2. In Excel: Get Data → Blank query → Advanced Editor.
  3. Paste the Power Query code and load the table to the sheet.
Grafana
Infinity

Grafana

JSON addresses; the dashboard's time range via ${__from} / ${__to}.

  1. Settings › Data Bridge › Grafana card › Open; Create key.
  2. In Grafana, the Infinity data source: Bearer Token = the key, Allowed hosts = the MergenHub address.
  3. Panel: Type = JSON, Source = URL, address /config/v1/analytics/history?tags=…
  4. Columns: time → Timestamp, value → Number, tag → String.
Data Bridge (IoT 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
MQTT push

Publish to an MQTT broker

Selected tags are published to a topic as JSON; two-way with a write topic.

  1. Settings › Web & Connectivity › Data Bridge › MQTT push; Add Agent, type MQTT Client.
  2. Broker address, port (8883 and a certificate for TLS), topic and QoS.
  3. Pick the tags; publish periodically or on change only.
  4. The Status tab shows the connection, last publish and last error.
REST push

Send to a REST address

Tag values or the table of an Excel report go to an HTTP endpoint with POST / PUT / PATCH.

  1. Add Agent, type REST Client; URL and method.
  2. Authentication: Basic, Bearer or API Key; extra headers line by line.
  3. What to send: tags or a Report (Excel report), and when to send it.
  4. Send test request: one request without saving; status code and response on screen.
REST server

Let an external system read

/iotgateway/read, /write and /browse endpoints with the same JSON formats as Kepware IoT Gateway.

  1. Add an agent on the REST server card and pick the tags.
  2. A new agent asks for credentials (session or HTTP Basic); only Root can enable anonymous access.
  3. Read: GET /iotgateway/read?ids=Channel.Device.Tag; writes only if allowed.
Databases

Write history to your own database

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.

Microsoft SQL Server
Data source

Microsoft SQL Server

SQL Server login or Windows authentication.

  1. Settings → Data sources › New data source, type card SQL Server.
  2. Server, Port (empty = 1433), User, Password; or Windows authentication.
  3. Database: List, or type a name and Create; Test connection, Save.
  4. Data Logger › Add Log Group › pick it in the Data source box.
MySQL
Data source

MySQL / MariaDB

MySQL 8+ and MariaDB.

  1. New data source, type card MySQL.
  2. Server, Port (empty = 3306), User, Password.
  3. Pick or create the database; Test connection, Save.
  4. Select it in a log group or in the Data store window on the Counters page.
PostgreSQL
Data source

PostgreSQL

Table and column names are case-sensitive; picking them from the list is safest.

  1. New data source, type card PostgreSQL; empty Port = 5432.
  2. The server's pg_hba.conf must allow connections from the MergenHub machine.
  3. List or Create the database; Test connection, Save.
  4. Select it as the Data source of a log group.
SQLite
Embedded · ODBC

SQLite and ODBC

The embedded database needs no installation and is the default; other products through a 64-bit ODBC driver.

  1. For the embedded database leave Embedded database (SQLite) selected in the log group; nothing else to do.
  2. ODBC: type card ODBC, connection string DSN=… or Driver={…};…
  3. Installed DSNs lists the DSNs on the machine; Test connection.
Messaging

Alarms in Slack, Telegram and WhatsApp

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.

Slack
Webhook

Slack

Alarm messages to a Slack channel.

  1. In Slack, create an app, turn on Incoming Webhooks and pick the channel.
  2. Copy the https://hooks.slack.com/services/… address.
  3. In MergenHub, Send to Slack, paste the address, Save.
  4. Send a test message: a message should appear in the channel.
Telegram
Bot

Telegram

Messages to people and groups through a bot.

  1. /newbot with @BotFather; get the bot token.
  2. Paste the token, Send to Telegram, Save.
  3. Write a message to the bot (or in a group the bot was added to).
  4. Find chats › Add; then Send a test message.
WhatsApp
Cloud API

WhatsApp

From your business WhatsApp number, through Meta's WhatsApp Cloud API.

  1. A WhatsApp Business app on Meta for Developers; Phone number ID → Phone number ID box.
  2. A permanent access token → Access token.
  3. An approved Utility template with one variable ({{1}}): Template name and Template language.
  4. Recipients with country code (+90…); Send to WhatsApp, Save, Send a test message.
Clients and API

SCADA, MES and software read MergenHub

All sources in a single OPC UA address space and in the REST API; the number of clients is unlimited.

OPC UA server

OPC UA clients

Clients such as SCADA, MES, DCS and UaExpert connect over standard OPC UA; alarms are read as OPC UA events too.

  1. Address: opc.tcp://host:48010/MergenHub (Settings → OPC UA).
  2. Security policy (None, Basic256Sha256 Sign / Sign&Encrypt) and anonymous or user name / password.
  3. An untrusted client certificate goes to the rejected list; trust it under Settings → Certificates.
OPC UA client

Other OPC UA servers

MergenHub is a client too: it reads the nodes of a remote OPC UA server like a driver, and you can try them with the built-in client.

  1. On the OPC UA Client screen enter the server address and list the endpoints.
  2. Pick the security policy and identity and connect; browse the address space.
  3. Read, write, subscribe; if the handshake is rejected, trust the other side's certificate.
REST API

REST API and AI

Configuration and live values as JSON; with the MCP server, AI assistants query the plant with the user's permissions.

  1. REST: http://host:8090/config/v1/project, HTTP Basic or session; every endpoint requires a permission.
  2. MCP: turn on the server under Plugins › MCP (AI); endpoint /mcp.
  3. Connect the assistant with OAuth 2.0 or a token created on the same page.
Try it

Every integration is enabled in the free demo

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.

Licensing & pricingContact