How to setup BambooHR Integration

This integration will allow you to connect with BambooHR and start collecting your data. It is a matter of minutes to send your billing data to feed your BI, your data warehouse, or your custom analytics stack.

Here are the steps involved:

  1. Connecting BambooHR
  2. Configuration of the pipeline
  3. BambooHR expected Data Model and schema

Getting Started – Setup BambooHR integration at Blendo

How to connect

Login to your Blendo account and make sure that your data warehouse of choice is selected (at the navigation bar). Click on the “Add Pipeline” button to create a new BambooHR pipeline. You will be presented a list of sources to choose from. This should also be what you see if you have no pipelines created yet. Select the BambooHR option to start creating your pipeline.


Setting up the BambooHR pipeline is really simple. You will asked to fill in your account information on BambooHR, specifically your Company and your API Key. In the field company you should fill in your BambooHR URL subdomain.

For example if your BambooHR URL is then you should type “blendosupport”.

The API Key that you should use can be created at the “API Keys” section of your BambooHR account.

In order to create an API Key on your BambooHR account that you can use on Blendo, you have to click on the top right corner of your account and select API Keys

Then you can create a new one giving a name, but be sure that you copy the relevant key in order to paste it in the appropriate field on Blendo.

Next, select an optional table prefix that will be added in front of the names of any tables created by this pipeline. Leave the field empty if you prefer the table names not to have any prefix.


Finally, select which BambooHR resources you want to be synced. By default, all resources are selected. Click on each one you don’t need, to deselect it. When you are read click on the “Create” button. That’s it! Your pipeline is ready to receive data.

Configuration of the pipeline

Blendo collects the data as soon as they arrive and will sync them to your data warehouse according to your pipeline’s schedule. The default behaviour is to do this once per hour, but you can configure it to run as often as once per 15 minutes, by clicking on “Reschedule” button.

In this section you can also view the pipeline status, the details of the syncing status (the amount of records synced for each table or if an error has appeared), you can also stop the ongoing sync or start a new one before the following schedule sync.

Moreover, you can edit the resource selection for your pipeline by selecting or deselecting any of the resources.

Keep in mind that any changes that may be done to the pipeline will be valid starting from the following sync and on.

BambooHR Data Model & Schema Information

Blendo will now connect to your BambooHR data source. It will sync your historical data and all the future updates into your destination data warehouse. You will get analytics ready tables and syncs that make sure you will get recent and consistent data.

Let’s see:

  1. How Blendo syncs BambooHR data
  2. The tables with BambooHR data that we create in your destination data warehouse

How Blendo syncs BambooHR data

Historical Data

When Blendo first connects to BambooHR Data source, will pull all your historical data.

Sync Schedule

Blendo syncs BambooHR data based on the schedule and frequency you choose. The default setting is every 1 hour but is configurable from inside the app.

Replication Process

The first time Blendo syncs your BambooHR data performs a full replication. Then your BambooHR data is either replicated fully or updated, depending on each of the resources. More information can be found at the Expected BambooHR Data Model &Schema.Note that Blendo will only read your data.

I am message box. Click edit button to change this text.

After you finish the integration with BambooHR, you might see its status as Importing from sourceExporting to the destination, or Completed.

What BambooHR data do I have available?

Blendo creates analytics ready tables with recent and consistent data. Bellow is a diagram of the schema and you may also find a CSV with all the columns and fields in more detail.

Expected BambooHR Data Model & Schema Information >>

Questions? Contact us!

in Connecting SaaS Data Sources