Skip to main content
BambooHR is a Human Resource Information System (HRIS) that bundles HR features, such as payroll, time tracking, employee engagement, an applicant tracking system Human Resource Information System (HRIS) that bundles HR features, such as payroll, time tracking, employee engagement, an applicant tracking system (ATS) and more into one system. This cloud-based software is ideal for small to medium-sized businesses (SMBs) that want to optimise their HR processes for efficiency as it houses all employee information in one location for employees, HR professionals, recruiters and managers to easily access. Small and medium businesses that want to move away from using spreadsheets and/or organize their HR data. BambooHR is an all-in-one HR software solution that sets people free to do great work. This article details the steps to get started with BambooHR in Peliqan. Please contact support if you have any additional questions or remarks. Content:

​
Before Connecting Data Pipeline

BambooHR supports two type integrations, one is personal and other is through App integration. Peliqan supports personal Integration where User creates their own API key and have control over their data.

​
Get API Key

  1. If you do not have an Account on BambooHR, create one account using https://www.bamboohr.com/g2/. If you have one skip to step
  2. On Extreme top right, click on “Try it free”
  3. A pop-up input form will appear and fill the form.
BambooHR Account creation
  1. Verify Your account and Login to BambooHR.
  2. Once Logged-In, Domain-Name is visible
BambooHR Domain name
  1. On the extreme right, click on the profile tab. A pop-up menu will open, click on “API Keys”.
BambooHR API Keys menu
  1. Create API key if not available and save the API key once created.
The API secret key is a 160-bit number expressed in hexadecimal form. This is an astronomically large number of unique keys, which means that guessing an API key is nearly impossible.

​
BambooHR Data Pipeline

​
Connect BambooHR

Connect BambooHR through the Peliqan Connectivity module: BambooHR Peliqan Connectivity module Configuration Options:
  1. API Key (steps are above (steps are above)
  2. Company Domain (If you access BambooHR at https://mycompany.bamboohr.com, then the companyDomain is ‘mycompany’ (If you access BambooHR at https://mycompany.bamboohr.com, then the companyDomain is ‘mycompany’)
  3. Start Date
Click on Save to proceed with creating pipeline to BambooHR. Additionally, you can select Endpoints to Sync from advanced option for customised pipeline. BambooHR Advanced options

​
BambooHR data sync to DataWarehouse

Peliqan offers an out of the box data warehouse. Optionally the user can choose to sync Exact online data to their own data warehouse such as Snowflake, Google Bigquery, MS SQL, etc. By default, it provides Postgres Datawarehouse. Data will be synced to the chosen data warehouse and made available through the Peliqan UI for exploration. BambooHR Data Warehouse sync With the Peliqan query engine, queries on the BambooHR data can be written and data can be transformed and combined with other sources. BambooHR Query Engine

​
BambooHR Data Activation

​
Get Employee Data

BambooHR Get Employee Data

​
Add an Employee

Peliqan allows adding a new employee data with fields from Employee Model. BambooHR Add Employee By default, BambooHR doesn’t provides ID of the employee created. To get ID(s) of new employee added, sync “employee_last_change” with peliqan’s SYNC feature. Employee data can be updated using “Update Employee” function.

​
Add TimeOff Request

With peliqan “Add TimeOff Request” function one can make a request for time off. BambooHR Add TimeOff Request Peliqan also provides “Update TimeOff Request Status” method which allows managers to update the status of request by denying, approving the same.

​
Get Job Application Details

“Get application Details” method provides details of a job application based in application_id BambooHR Get Job Application Details

​
Add Job Hiring Post

Using “Add Job Hiring” lets user to create a new Job Post for Hiring. BambooHR Add Job Hiring Post Data related to jobs will be visible in “Job_Summaries” Table under BambooHR Schema in default DataWarehouse.