Northbound Connectors

Connect BI tools, dashboards, and applications to AnyLog for querying distributed edge data.

AnyLog exposes query and data access through a REST API, enabling standard BI tools, dashboards, and applications to query distributed edge data as if it were a single database.

All northbound connectors communicate with a Query Node over REST. The Query Node resolves which Operator nodes hold the relevant data, distributes the SQL query, and returns aggregated results.

Generic REST API

Any application can query AnyLog directly via HTTP GET or POST — this is the pattern every connector below is built on.

GET:

curl -X GET 'http://[ip]:[port]' \
  -H 'command: sql my_data format=json "select * from ping_sensor limit 10"' \
  -H 'User-Agent: AnyLog/1.23' \
  -H 'destination: network'

Equivalent POST:

curl -X POST 'http://[ip]:[port]' \
  -H 'Content-Type: application/json' \
  -d '{
    "command": "sql my_data format=json \"select * from ping_sensor limit 10\"",
    "AnyLog-Agent": "AnyLog/1.23",
    "destination": "network"
  }'

destination: network scans the whole network for matching data — the REST equivalent of run client () with empty parentheses. If destination is omitted, the request runs only against the local node. (Noting this as my best understanding of the default — worth a quick confirm if you’re relying on the omitted-header behavior specifically.)

See Using REST for the full REST API reference.

Connectors

Tool What it’s for Doc  
Postman Testing AnyLog REST endpoints during development, with or without SSL Postman Integration  
Grafana Dashboards over live/historical AnyLog data — increments, period, aggregations, and blockchain metadata visualizations Using Grafana  
PostgreSQL / Tableau For tools that only support a PostgreSQL connector (not REST) — routes results through system_query into a real Postgres instance PostgreSQL Connector & Tableau Visualization  
PowerBI / Excel Pull AnyLog data into PowerBI or Excel via the Web connector and PowerQuery AnyLog with PowerBI + Microsoft Office Suite  
Google Drive / Sheets Pull AnyLog query results into Sheets via the third-party Two Minute Reports add-on Google Drive  
Qlik Qlik Sense’s REST connector plugin, with worked increments/period examples Qlik  
Edge Data Manager AnyLog’s own management/monitoring UI Edge Data Manager  

Sending data the other way: the connectors above all pull data from AnyLog. To push data or a message out — a SQL result over REST, or a one-off MQTT message — see Forwarding Data.