Skip to content

Other apps

Connect BambooHR to DataxLand

The BambooHR connector reads employees, the directory, time-off requests, timesheets and custom reports from your BambooHR HR system. Si maps employees, time off and timesheets into the standard HR model, giving you average headcount, new hires and terminations, turnover rate, absence rate and overtime hours by department; combined with revenue, you also get revenue per employee.

Free plan with no time limit · No card required · Sample workspace ready in minutes

What you can do with BambooHR

  • Track turnover rate and voluntary turnover rate by quarter.
  • See absence rate by department.
  • Compute net revenue per employee once a sales source is connected.

What data you get

Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.

Stream (table)Contents
employeesEmployees with department, job title, hire date, termination date and status; name, email and phone number are hashed on load.
employees_directory_streamEmployee directory.
time_off_requests_streamTime-off requests by type and date; loaded incrementally.
timesheet_entriesTimesheet hours, used to compute overtime.
custom_reports_streamCustom report with the fields you list in the form.
meta_fields_streamCatalog of the account's fields.

Connection details

Sign-in methodConnection details (API key, account), encrypted at rest
Sync modesFull (reloaded each run) · Incremental (new or changed rows only)
Fields to fill inapi_key, subdomain
DeveloperAirbyte (community), run inside DataxLand
LicenseELv2
Technical docsConnector documentation ↗

Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.

Metrics computed from this source

Real definitions from the analytics packs; dashboards and Si share them.

MetricDefinitionUnit
Average headcountAverage number of active employees per day in the period.= hr_headcount_days / hr_snapshot_daysNumber
New hiresNumber of employees with a start date in the period.Count
TerminationsNumber of employees whose last working day falls in the period, both voluntary and involuntary.Count
Turnover rateTerminations in the period divided by average headcount for the period.= Terminations / Average headcountRatio (%)
Voluntary turnover rateVoluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcountRatio (%)
Absence daysNumber of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other).Count
Absence rateAbsence days divided by scheduled working days.= Absence days / hr_scheduled_daysRatio (%)
Overtime hoursTotal overtime hours recorded in timesheets.Number

Connect BambooHR in 4 steps

  1. 1

    Create an API key

    In BambooHR, open the account menu, go to API Keys and create a new key for a user who can view employees.

  2. 2

    Add the BambooHR source

    In the workspace choose Add source, find BambooHR, enter the subdomain (the part before .bamboohr.com) and api_key; list extra fields if you use a custom report.

  3. 3

    Choose streams

    Click Test connection, pick employees, time_off_requests_stream and timesheet_entries.

  4. 4

    Review and build

    Si proposes a mapping to employees, time off and timesheets; you approve, then build the HR dashboard.

Limits and caveats

  • Payroll cost is not in BambooHR; upload payroll via Excel to get payroll cost and average cost per employee.
  • Employee data is personal data; personal columns are hashed on load and never returned through dashboards, the API or MCP. Grant read access only to the fields you need.
  • Requires the Starter plan or above. This is an Airbyte community connector (ELv2) run inside DataxLand.

Frequently asked questions

How is turnover rate computed?

Terminations in the period divided by average headcount, following the HR pack's versioned definition.

Does individual employee information reach Si?

No. Personal columns are hashed on load and masked before reaching Si; Si answers with aggregate metrics, within the asker's permissions in the workspace.

Does it change employee records?

No. The connector is read-only.

Dashboard templates that use this source

Ask Si about your BambooHR data →All data sources →

Connect BambooHR and get verified dashboards

Free plan with no time limit · No card required · Sample workspace ready in minutes