How does this relate to our social secretariat (SD Worx, Acerta, Securex)?

Officient is the HR-admin and prep layer that feeds your social secretariat each month: the personnel file, contracts, calendar requests, expenses and fleet sit in Officient, and the loonrun itself runs at the secretariat. The Officient connector covers what you can see and act on in Officient. If you also want the loonrun output (gross, employer premiums, wage components per cost centre) in the same warehouse, the SD Worx Cobra or SD Worx Absences connectors join on the employee identifier.

Officient connector

Use your Officient data for reporting, automation and AI.

Data Panda brings your Officient personnel, contract, leave and fleet data together with the rest of your business. From one place we turn it into dashboards, automations, AI workflows and small apps HR, finance and ops use during the month.

About Officient

The Ghent-built cloud HR platform for Belgian SMBs.

Officient is a cloud HR platform built in Ghent for Belgian SMBs. It is the place where the personnel file, contracts, leave and time off, onboarding, documents, expenses and the company fleet sit in one product, with the data shaped to feed the monthly payroll run at the social secretariat. The product was started in 2017 by a team that came out of Teamleader and is now part of the Exact group, which slotted it in next to the Belgian accounting and ERP suite for SMBs that wanted a modern HR layer on top.

The Officient connector pulls that surface into your warehouse: people, contracts, departments, teams, functions, cost centres and cost units, the calendar requests behind every leave and sick day, expense categories, fleet and assets, and the custom person fields most Belgian SMBs build up over time. Once it lands in the warehouse next to your accounting, CRM and project tooling, the questions HR and finance keep asking get straightforward answers. Personnel cost per cost centre against budget. Leave and sick rate per team. Contracts ending in the next ninety days. Onboarding tasks still open after the first month. The point is not to replace the Officient screens your HR team uses every day. The point is to stop exporting them into Excel for every report.

What your Officient data is for

What you get once Officient is connected.

HR and personnel-cost reporting

Headcount, leave and personnel-cost on one page, per team and cost centre instead of per HR export.

Headcount and FTE per department, team and function over time
Leave and sick-rate per team against the company average
Personnel cost per cost centre lined up with the finance budget

Process automation

Turn Officient events into the work the rest of the stack needs, instead of an HR copy-paste round.

Push approved leave into the project planner as unavailable hours
Post payroll-prep cost per cost centre to the accounting ledger
Flag contracts ending in the next ninety days to HR and the line manager

AI workflows

Use Officient history behind AI that sees the full BE SMB workforce picture.

Forecast leave and sick-rate per team across the next quarter
Score onboarding cohorts on completion and first-90-day attrition
Natural-language Q&A on policies, contracts and the people directory

Custom apps on your data

Small HR and ops tools on Officient data, not another SaaS subscription.

Manager dashboard with team headcount, leave and ending contracts
Onboarding cockpit with open tasks per new joiner
Fleet and expense board joined to the cost-centre view

Use cases

Use cases we deliver with Officient data.

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

Headcount per teamHeadcount and FTE per department, team and function, trended per month.

Leave and sick-rateApproved leave, recup and short-term illness per team against the company average.

Ending contractsFixed-term and trial contracts ending in the next 30, 60 and 90 days.

Onboarding completionOpen and closed onboarding tasks per new hire and per cohort.

Cost-centre viewHeadcount, leave and personnel cost rolled up per cost centre and cost unit.

Fleet and assetsCompany cars, laptops and other assets per employee and per team.

Expense categoriesExpenses per category, employee and cost centre, ready for the ledger.

Capacity per projectAvailable team-days per week after approved leave and bank holidays.

Joiners and leaversMovement per month with starting cost centre, function and manager.

Custom field reportingCustom person fields turned into filterable dimensions on every dashboard.

Payroll-prep handoffCalendar requests and contracts shaped for the social-secretariat run.

First-90-day attritionNew hires that leave inside ninety days, per team and onboarding cohort.

Real business questions

Answers you will finally get.

Which contracts end in the next ninety days, and have we lined up the conversation?

Every fixed-term and trial contract in Officient with its end date, the team and cost centre it sits on, and the line manager who owns the renewal call. HR and the team lead see the same list two months out instead of running into a contract that quietly ran its term, and the renewal conversation happens before the project planning takes the seat for granted.

Which team is drifting on sick rate this quarter?

Approved leave, recup and short-term illness from Officient broken out per team and cost centre, with the last six months against the company average. The HR business partner sees which team carries three points of extra short-term illness before the quarterly review, instead of in the year-end conversation, and can act while the signal is still fresh.

Are our new joiners finishing onboarding?

Open and closed onboarding tasks per new hire, per cohort and per assigned owner, with the time it takes to clear the checklist. People-ops sees which steps stall (training booking, contract signature, asset hand-out) and where ninety-day attrition concentrates, instead of trusting that everyone got through because nobody flagged a problem.

Value for everyone in the organisation

Where each function gets value.

For finance leaders

Personnel cost per cost centre and cost unit on the same page as the rest of the P&L. Fleet and expense lines from Officient flow into the same view, so the controller stops chasing a separate HR PDF every month-end.

For sales leaders

Approved leave and ending contracts of the assigned delivery team on the deal record, so sales directors quote a delivery date the team can keep instead of one that hits the August bank-holiday week.

For operations

Capacity per team per week after approved leave and bank holidays, with new joiners and ending contracts on the same calendar. The Monday planning call runs on real numbers, not on the leave kalender pulled up in a separate tab.

Ideas

What you can automate with Officient.

Pair with Exact Online

Post Officient personnel cost into Exact Online

Each period, payroll-prep cost from Officient lands in Exact Online split per cost centre, cost unit and expense category. Finance stops rekeying an HR export into the ledger, and the personnel-cost line ties back to the team and contract that produced it. For the SMBs that already run Exact Online next to Officient under the same group, the close runs in one tool instead of two.

Pair with Yuki

Sync Officient expense and fleet cost to Yuki

Approved expenses and fleet cost per employee from Officient flow into Yuki against the right cost centre and category, so the Yuki bookkeeping runs on the same coding HR uses in Officient. The accountant stops re-coding employee expenses by hand and the monthly Yuki close lines up with what HR sees in the personnel file.

Pair with Slack

Drive the team-announce moments from Officient

New joiners, anniversaries, approved leave and contracts ending in the next ninety days from Officient drive the right Slack messages into the right channels: a welcome post on day one, an out-of-office note for the team channel, and a manager DM when a contract is up for renewal. HR stops running a weekly announcement queue by hand.

Pair with HubSpot

Show delivery-team capacity on the HubSpot deal record

Approved leave and ending contracts of the assigned delivery team from Officient land on the HubSpot company record as a capacity signal, visible next to the open pipeline. Sales directors see which reps and team members are out when a kickoff is scheduled, so handover and delivery dates stop slipping into the first week back from holiday.

Data model

Tables we make available.

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

Asset Types
Assets
Calendar Requests
Contracts
Cost Centers
Cost Units
Departments
Expense Categories
Fleet
Functions
People
Person Custom Fields
Teams
Webhooks

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 Officient data lives.

Power BI Microsoft

Fabric Microsoft

Snowflake Data warehouse

BigQuery Google

Tableau Visualisation

Excel Sheets & pivots

Three steps

From Officient to answers in three steps.

Connect securely

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

Land in your warehouse

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

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.

Officient 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 Officient tables land in the warehouse?

The connector pulls People, Contracts, Departments, Teams, Functions, Cost Centers, Cost Units, Calendar Requests (the records behind every leave, recup and sick day), Expense Categories, Fleet, Assets, Asset Types, Person Custom Fields and Webhooks. That covers the personnel, contract, leave, fleet and expense surface most BE SMB HR, finance and operations dashboards need without a custom API job.

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

Personnel and leave data is personal and covered by GDPR, so we set role-based access on the HR tables, keep team-manager dashboards aggregated where possible, and work with your DPO on the lawful-basis mapping. Custom person fields that hold particularly sensitive data (medical attestations, disciplinary notes) can be excluded from the sync, or kept in a restricted schema only HR roles reach. This is not data we treat like invoice lines.

GDPR-compliant

Data stays in the EU

You own the warehouse

A first deliverable live in four to six weeks.

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

Book a call See our other connectors