SD Worx Absences connector

Use your SD Worx absence data for reporting, automation and AI.

Data Panda brings your SD Worx absence data together with the data from the rest of your business. From one place, we turn it into dashboards, automations, AI workflows and custom apps your HR, finance and operations teams use every day.

Data Panda Reporting Automation AI Apps
SD Worx Absences logo
About SD Worx Absences

The Antwerp payroll name behind most Belgian pay slips.

SD Worx started in 1945 in Antwerp as a sociale dienst for employers, founded to help Belgian companies handle payroll and social legislation in the years after the war. Eighty years later it is one of the largest payroll and HR services companies in Europe, paying around five million people every month across 26 countries, with more than 95.000 client companies and over 3.000 people in Belgium across 33 offices.

The SD Worx Absences connector is a narrow slice of that platform. It pulls the employee register and the absence codes booked against each employee, the same records your HR team uses to process sick leave, holidays, training time, parental leave and educational leave. That is two tables, not a full HRIS: enough to see absence-rate drift per department, ziektewet versus verlof breakdown, or the planning gap that opens in August, and not enough to replace your SD Worx portal for day-to-day HR admin. Pulled into a warehouse, it sits next to your CRM, your ERP and your project tooling, so capacity questions get answered against real absence data instead of a monthly PDF.

What your SD Worx Absences data is for

What you get once SD Worx Absences is connected.

Absence reporting

Absence rate, code mix and department drift on one page, across the whole company instead of per HR report.

  • Absence rate per department, team and month
  • Ziektewet versus verlof versus opleiding in one mix
  • Bradford-style recurrence score per employee

Process automation

Turn booked absence codes into the journal entries, capacity updates and planning nudges the rest of the stack needs.

  • Post absence-related payroll cost to the accounting ledger
  • Push team capacity into project and sales tooling
  • Flag recurring short-term absences to HR before they escalate

AI workflows

Use the absence and employee history to forecast coverage gaps and spot patterns before they hit delivery.

  • Forecast department-level absence rate per month and season
  • Score teams on recurrence and Bradford-factor drift
  • Flag departments trending toward a planning gap two weeks out

Custom apps on your data

Small HR and ops tools that sit on SD Worx absence data instead of a month-end PDF.

  • Department manager view with team absence mix and trend
  • Planning cockpit for ops lead with capacity per week
  • HR audit board for social-law compliance reporting
Use cases

Use cases we deliver with SD Worx Absences data.

A list of concrete reports, automations and AI features we have built on SD Worx Absences data. Pick the one that matches your situation.

Absence rate per teamAbsence rate per department, month and code family, tracked over time.
Ziektewet versus verlofShort-term illness split from paid leave and time-off-in-lieu in one view.
Bradford factorRecurrence-weighted absence score per employee across the last rolling year.
Summer planning gapPlanned holiday load per team across July and August.
Training timeHours booked against training and educational-leave codes per department.
Parental leaveParental, maternity and paternity leave coverage across the calendar.
Capacity per projectAvailable team-days per week after planned and booked absences.
Long-term absenceRunning count of employees off for more than 30 and 90 days.
New-joiner absenceAbsence rate during the first six months per department.
Compliance auditAbsence records packaged for social-law reporting and audit requests.
Absence cost per teamGross absence cost joined to the payroll feed per department.
Headcount movementJoiners, leavers and active headcount per month, per department.
Real business questions

Answers you will finally get.

Which department is quietly drifting up on short-term absence?

Absence rate broken out per department and per code family, with the last six months plotted against the company average. HR sees which team has three points of extra ziektewet before the quarterly committee meeting, instead of in the year-end review, and can have the conversation while the signal is still fresh.

Do we have enough people on deck during the summer and year-end weeks?

Planned holiday load per team per week, stacked next to the projects running through that period. The ops lead and the account directors see where July and August crack open below minimum coverage, while there is still room to shuffle approvals or bring a freelancer in instead of finding out on the Monday itself.

Are our absence records ready for a social-law audit right now?

Every booked absence with its code, start and end, tied to the employee and department, in a shape a controleur can read without a week of prep. Ziektewet, verlof, opleiding, ouderschapsverlof and educatief verlof each get their own roll-up, so the audit conversation runs on the booked codes themselves rather than on a stitched-together Excel.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Absence-related payroll cost per department, with ziektewet, verlof and training time separated out on the same page as the rest of the personnel cost. Month-end accrual for guaranteed salary during illness stops being a manual reclass against a PDF from HR.

For sales leaders

Team capacity per week on one dashboard, so the pipeline conversation runs on a realistic promise date. Sales directors see where the delivery team runs below minimum coverage before they sign an aggressive deadline into a proposal.

For operations

Planned and booked absences per team per week, next to the projects and shifts that have to be covered. The ops lead sees the August gap in May, and the Monday planning call runs on real numbers rather than on who remembered to ping the group chat.

Ideas

What you can automate with SD Worx Absences.

Pair with MS Dynamics 365 Business Central

Post absence-related payroll cost to Business Central

Each period, absence codes booked in SD Worx land in Business Central as the right journal entries, split across guaranteed salary during illness, paid leave and training time per department. Finance stops rekeying a monthly HR export into the ledger, and the personnel-cost line already ties back to the absence code that produced it.

Pair with Teamleader Focus

Line up SD Worx capacity with Teamleader Focus planning

Booked holidays, sick days and training time per employee flow into Teamleader Focus as unavailable hours on the planner, per project and per week. Account managers see real team capacity before they commit to a delivery date, instead of reading the leave calendar in a separate tab and doing the math in their head.

Pair with Jira

Feed dev-team absences into Jira sprint capacity

Approved leave and booked training time per developer arrive in Jira as reduced sprint capacity on the matching team board, per sprint and per assignee. Scrum masters plan the next two sprints on the hours that are really available rather than on a default 40-hour velocity the team rarely hits in July.

Pair with HubSpot

Show sales owner capacity in HubSpot deal views

Planned holidays and training days of the deal owner and the assigned delivery team land on the HubSpot company record as a capacity signal, visible next to the open pipeline. Sales directors see which reps will be out when the kickoff is scheduled, so handover and delivery dates stop slipping into the first week back.

Data model

Tables we make available.

These are the 2 tables we currently pull from SD Worx Absences into your warehouse. Query them directly in SQL, join them to the rest of your stack, or build reports on top.

  • Absencecodes
  • Employees

Missing a table you need? We can extend the sync. Tell us what is missing and we will build it for you.

Your existing tools

Your data lands in a warehouse. Your BI tools read from it.

You keep the reporting tool you already have. We connect it to the warehouse where your SD Worx Absences data lives.

Power BI logo
Power BI Microsoft
Microsoft Fabric logo
Fabric Microsoft
Snowflake logo
Snowflake Data warehouse
Google BigQuery logo
BigQuery Google
Tableau logo
Tableau Visualisation
Microsoft Excel logo
Excel Sheets & pivots
Three steps

From SD Worx Absences to answers in three steps.

01

Connect securely

OAuth authentication. Read-only by default. We sign a DPA and your admin keeps the keys.

02

Land in your warehouse

Data flows into your warehouse on your schedule. Near real time or nightly, your call. You own the data.

03

Reporting, automation, AI

We build the first dashboard, workflow or AI feature with you, then hand over the keys. Or we stay on for ongoing delivery.

Two ways to work with us

Pick the track that fits how you work.

Track 01

Self-serve

We set up the foundation. Your team builds on top.

  • SD Worx Absences connector configured and running
  • Warehouse set up in your cloud account
  • Clean access for your Power BI, Fabric or Tableau team
  • Documentation on what's in the data model
  • Sync monitoring so you're warned before reports break

Best fit Teams that already have a BI analyst or data engineer and want to own the build.

Track 02

Done for you

We build the whole thing, end to end.

  • Everything in Self-serve
  • Dashboards built to the questions your team actually asks
  • Automations between your systems
  • AI workflows scoped to real tasks your team runs
  • Custom apps where a dashboard does not cut it
  • Ongoing delivery at a pace that fits your team

Best fit Teams without in-house BI or dev capacity. You tell us what you need and we deliver it.

Before you book

Frequently asked questions.

Who owns the data?

You do. It lands in your warehouse, on your cloud account. We don't resell or aggregate it. If you stop working with us, the warehouse stays yours and keeps running.

How fresh is the data?

Near real time for most operational systems. For heavier sources we schedule hourly or nightly. You pick based on what the reports need.

Do I need a warehouse already?

No. If you don't have one, we help you pick one and set it up as part of the first delivery. Common starting points are Snowflake, Microsoft Fabric, or a small Postgres start.

Which SD Worx data does this connector pull today?

Two tables: the employee register and the absence codes booked against each employee. That covers who works for you, in which department, and every absence posted against them with its code, start and end. It does not cover payroll lines, contract detail, benefits, timesheet micro-entries or the wider HCM and workforce-management surface SD Worx offers. For absence-pattern reporting and capacity planning that slice is the right one; for full HRIS replication it is not.

Absence data is sensitive. How is that handled in a warehouse?

The connector brings absence codes and date ranges into your warehouse, not the underlying medical notes or physician statements, because SD Worx does not expose those through the integration. Even so, the data is personal and covered by GDPR, so we set role-based access on the HR tables, keep department-manager dashboards aggregated to team level where possible, and work with your DPO on the lawful-basis mapping. This is not data we treat like invoice lines.

How does this relate to SD Worx Cobra and the rest of the SD Worx stack?

SD Worx runs several product lines against the same payroll engine. This connector is the absence slice of that platform; Cobra and the wider HCM products surface other pieces, like contract and payroll data. If your team also runs on Cobra or on another SD Worx module, the two connectors can be stitched together in the warehouse on employee identifier, so the absence view joins to payroll and headcount without double-entry.

GDPR-compliant
Data stays in the EU
You own the warehouse

A first deliverable live in four to six weeks.

We review your SD Worx Absences setup and the systems around it. Together we pick the first thing worth building.