Sona Connector
Sona is a workforce management platform for frontline teams, covering rota scheduling, time and attendance, absence management and payroll preparation.
SonaYour warehouseLive
Queryable over MCPSet up in minutes.
No code, no maintenance.
Sona
Data source
Sona in your warehouse.
Ready for your agents.
Sona is a workforce management platform for frontline teams, covering rota scheduling, time and attendance, absence management and payroll preparation. Weld's Sona connector is fully managed: it extracts data from Sona, loads it into your warehouse, and keeps it in sync. The data lands in a clean, documented schema with agent context attached, so analysts can query it with SQL or dbt, and agents can query it over the Weld MCP server without guessing at tables or joins.
Sona models.
What the numbers mean.
Open-source SQL that turns the raw Sona tables into the reports people ask about. Deploy them in Weld and your agent queries the definitions, not guesses.
- Absence dailyWho was off, and why, per day: absence days by type and location, with sickness and holiday split out. The basis for absence rate and sickness trend reporting.grain: one row per absence date x home org unit x absence type x day status
- Paid hours dailyPaid hours per day as Sona sends them to payroll, by location and pay type: the hours side of a labour cost report.grain: one row per local pay date x home org unit x pay type x entry type
- Shift coverage dailyRota coverage per location and shift type: how many shifts were planned, how many were filled by your own staff, how many by an agency, and how many are still open. Covers upcoming shifts as well as past ones, so it doubles as a look-ahead of open shifts to fill.grain: one row per local shift date x org unit x shift type
Ask your agent.
It can reach Sona.
Connect Claude, Cursor, ChatGPT or your own agent to Weld over MCP. It finds the Sona tables Weld has synced and queries your warehouse.
- DiscoverSynced tables, columns and freshness
- QuerySQL against your warehouse
- OperateCheck, rerun and refresh syncs
Which Sona tables do we have, and which one is the largest?
Looking up what the Sona connection has synced.
Load Sona into any warehouse.
Set up in minutes, no code.
Everything you need.
To get started.
Set it up in code.
One REST API.
Use the Weld Connect REST API to create Sona connections, configure ELT syncs, and manage pipelines entirely through code. Built for embedding, automation, and CI/CD workflows.
▌Common questions.
About connectors.
Put your Sona data to work.
Connect Sona, pick a warehouse, and your agents can query it today. Free for 14 days, no credit card.
Source
