What can I learn from this page?
How to send HRIS data from HiBob via SFTP
Who is this guide for?
You can save time and effort by configuring your HRIS to automatically extract and send your employee data to Culture Amp via Secure File Transfer Protocol (SFTP).
HiBob via SFTP updates the user data using our Partial Import process. This means that you can update or add data via SFTP and manual uploads if you do not have all your information available in HiBob.
Setting up an SFTP integration may require assistance from HiBob. We've provided detailed technical instructions that you can provide to them during the set up process.
Step 1: Create a custom report in your HRIS
In HiBob, create a report that contains all the employees and demographics you want to import into Culture Amp. HiBob instructions on how to create reports are available here.
We recommend that you start with our Employee Data File Template. If you have existing data in the platform, you can head to Account Admin > Users > Export Users and use the headings that are included in the export to create your template. If you have additional demographics that you want to send through in addition to the existing data, you can add these columns in the report you are creating.
At a minimum, for every employee you want to update, you must include:
Employee email (Email) OR Employee ID. You can include both pieces of information if you have this available.
Below are some additional demographic columns that are commonly included in employee data files:
Preferred Name (This will be used in survey communications)
Date of Birth
Manager Email (All values must be in lower case)
You can also include any other demographics you wish to report on.
If you plan to create a hierarchy, or already have a hierarchy enabled, majority of employees must have a manager assigned using a unique manager identifier (e.g. Manager Email or Manager ID).
When you create your report in HiBoB, please note:
You'll be able to change column names to meet our data formatting guidelines and your preferences for demographic names in Culture Amp.
You'll need to change date formats: HiBob’s standard date format is DD/MM/YYYY (e.g. 20/02/1947). This data will need to be converted to one of Culture Amp’s accepted formats:
Mmm DD, YYYY (e.g. Feb 20, 1947)
Mmm DD YYYY (e.g. Feb 20 1947)
YYYY-MM-DD (ISO 8601 standard) (e.g. 1947-02-20).
“End date”: This is written as “Termination date” in HiBob. End date is not a required field in Culture Amp, but if you do want to send this information, some manual coding will be required to convert “Termination date” to “End date” (see screenshot below).
Employees to include/exclude: When configuring a report in HiBob, you can also decide which employees you want to include or exclude (e.g. to exclude terminated employees).
“Language” field: HiBob does not have a Language field. This can be created as a custom demographic if required. You cannot use the “Nationality” field as it will not meet our formatting requirements.
Step 2: Create an SSH key pair
An SSH key pair will ensure the SFTP connection via your client/HRIS is unique and secure. An SSH key pair is a pair of unique keys that are generated by you and saved on your computer. There's a private key which should only be used by you (or very carefully within your own organisation), and there's a public key which can safely be shared outside your organisation. The integration uses the combination of the two keys to verify the security of the connection.
HiBob by default supports SFTP setup via username and password while we use openSSH key pair. Contact your HiBob support team and they will help you to set up the connection with Culture Amp. The openSSH key pair should be configured without the passphrase option. The private key will remain with the HiBob. The public key will need to be entered in the Public Key field on the Settings > Data Integrations page in Culture Amp. This can be done by a Culture Amp Account Administrator.
HiBob team will ask you for below information:
Username: See yours on the Data Integration page in Culture Amp
Path: If required enter as "/"
Port: If required enter as "22" or leave blank
Step 3: Configure and schedule the HiBob report to be sent via SFTP
In HiBob, configure the report to export to Culture Amp via SFTP. We recommend setting an automatic schedule for this report so that your data is updated regularly.
Additional guidance on this step is available here.
Step 4: Testing your SFTP connection
If you're having problems with your SFTP connection, we suggest testing it by first running a manual import of your data. This will ensure you have a valid data set, and allow you to focus specifically on the SFTP connection.
Export your report from HiBob in XLSX or CSV format
Head to your Settings > Import Users > Partial Import page and upload the custom report. You will need to go through the steps until you reach the “Review Import Summary” stage.
Review any errors and request adjustments to the report, if any are required.
Cancel and do not “Apply changes”. This is because you are only testing the data and do not want to apply the changes via this manual upload process.
Test your SFTP connection by transferring your data via SFTP
If the transfer fails, you now know the issue is with your SFTP connection and not your data file.
Troubleshooting SFTP integration issues
If you are facing issues with syncing your data from HiBob to Culture Amp, you can view troubleshooting information we have included in our Troubleshooting SFTP integration issues guide.
Add your hierarchy
Once your integration has been successfully set up, the process of adding hierarchy to your account is a once off manual task.
The steps to add hierarchy to your account can be located via our Add your hierarchy guide.