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:
- Connecting BambooHR
- Configuration of the pipeline
- 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 blendosupport.bamboohr.com 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.