Productivity
Analytics Connector
Governed read-only feeds over OData, CSV and JSON so Power BI, Excel and Looker Studio read the ledger directly, with a per-key allow-list and a log of every read
Capabilities
- Governed read-only feeds over OData
- CSV
- JSON so Power BI
- Excel
- Looker Studio read the ledger directly
- with a per-key allow-list
- a log of every read
What it does
The work Analytics Connector takes off your desk on an ordinary day.
01
A contract, not an export
Every feed has a stable name, stable column names, declared types and one sentence saying what a single row is. A column is never renamed and never changes type. That is the difference between a data source and a spreadsheet somebody emailed you: the report you build this month still works after the next release.
02
Five minutes, not two days
Download one file, open it, put your key in once. Power BI starts with the table list already loaded and every feed you are allowed to read in it. Excel takes one pasted URL. Looker Studio gets a ready-made script with your addresses already filled in.
03
The line-level grain, not a summary
Invoice lines, journal lines, purchase order lines with what was actually received, stock movements one at a time. Whoever builds your reports gets the same grain the accounting engine works at, so their numbers tie to yours instead of nearly tying to yours.
04
One key, one list of tables
The key you give the sales dashboard reads the sales tables and nothing else. It cannot reach the ledger, and the ledger does not even appear in the table list it is offered. Revoke it and it stops reading the same second.
05
Who took what, and when
Every read is recorded: which key, which table, how many rows, how long it took, and from where — including the attempts that were refused. The record is append-only, so when an auditor asks who has a copy of your books, the answer is a screen rather than a guess.
06
A switch you can reach in a hurry
One table off, one transport off, or the whole connector off — one click each, from inside the workspace, with a reason recorded so whoever finds the broken report knows why. Nothing about this needs a support ticket.
Installs with
Analytics Connector has no dependencies. It is a good first app.
Included in these industries
Available as an add-on to any industry model.
More in Productivity
- DiscussWave 2Channels, direct messages, threads on any record, mentions and voice notes
- ApprovalsWave 2Approval requests with rules, thresholds and delegation
- AI CopilotWave 1Chat on every screen, drop-anything document intelligence, agents and memory
- StudioWave 3Custom fields, models, views, automations, report designer and AI Studio
- Reports CentreWave 2Every report, saved filters, schedules, exports and a dashboard builder
- Alerts and NotificationsWave 1Rules, channels, digests and preferences
Start with Analytics Connector, free.
One app is free forever with unlimited users. Add more when you are ready.