BambooHR is an 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
• Get API Key
• BambooHR Data Pipeline
• Connect BambooHR
• BambooHR data sync to DataWarehouse
• BambooHR Data Activation
• Get Employee Data
• Add an Employee
• Add TimeOff Request
• Get Job Application Details
• Add Job Hiring Post

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.

4. Verify Your account and Login to BambooHR.
5. Once Logged-In, Domain-Name is visible

6. On the extreme right, click on the profile tab. A pop-up menu will open, click on “API Keys”.

7. 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 :

Configuration Options:

1. API Key( steps are above )
2. Company Domain( 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 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.

With the Peliqan query engine, queries on the BambooHR data can be written and data can be transformed and combined with other sources.

BambooHR Data Activation

Get Employee Data

Add an Employee

Peliqan allows adding a new employee data with fields from Employee Model.

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.

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

Add Job Hiring Post

Using “Add Job Hiring” lets user to create a new Job Post for Hiring.

Data related to jobs will be visible in “Job_Summaries” Table under BambooHR Schema in default DataWarehouse.