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 |
|---|---|
| employees | Employees with department, job title, hire date, termination date and status; name, email and phone number are hashed on load. |
| employees_directory_stream | Employee directory. |
| time_off_requests_stream | Time-off requests by type and date; loaded incrementally. |
| timesheet_entries | Timesheet hours, used to compute overtime. |
| custom_reports_stream | Custom report with the fields you list in the form. |
| meta_fields_stream | Catalog of the account's fields. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | api_key, subdomain |
| Developer | Airbyte (community), run inside DataxLand |
| License | ELv2 |
| Technical docs | Connector 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.
| Metric | Definition | Unit |
|---|---|---|
| Average headcount | Average number of active employees per day in the period.= hr_headcount_days / hr_snapshot_days | Number |
| New hires | Number of employees with a start date in the period. | Count |
| Terminations | Number of employees whose last working day falls in the period, both voluntary and involuntary. | Count |
| Turnover rate | Terminations in the period divided by average headcount for the period.= Terminations / Average headcount | Ratio (%) |
| Voluntary turnover rate | Voluntary terminations in the period divided by average headcount for the period.= Voluntary terminations / Average headcount | Ratio (%) |
| Absence days | Number of scheduled working days on which employees were absent (annual leave, sick leave, unpaid leave, other). | Count |
| Absence rate | Absence days divided by scheduled working days.= Absence days / hr_scheduled_days | Ratio (%) |
| Overtime hours | Total overtime hours recorded in timesheets. | Number |
Connect BambooHR in 4 steps
- 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
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
Choose streams
Click Test connection, pick employees, time_off_requests_stream and timesheet_entries.
- 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
Connect BambooHR and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes