All Collections
Features
SFTP
How to send HRIS Data from Hibob through SFTP
How to send HRIS Data from Hibob through SFTP
Abe Chen avatar
Written by Abe Chen
Updated over a week ago

Overview

SFTP (Secure File Transfer Protocol) is a secure and private service for sending files another over the internet. You can send data directly from Workday using SFTP, this method utilizes the full file and deletes rows that are not present in each transfer.

Step 1: Create a custom report in HiBob

  • From the left menu, select Analytics > Reports.

  • Click + Add New.

  • Select Report > Start from scratch > General report.

  • The Build report from scratch popup appears, containing the column picker.

  • From the left column, select the fields you want to appear as columns in the report. Either search for the field or click on a report type. Then, click on the field name to add it to the column on the right.

Please include these fields in your custom report:

Basic info:

  • Display Name

  • Email

  • First Name

  • Last Name

  • Avatar URL

Address:

  • Address line 1

  • Address line 2

  • Zip/Post/Postal code

  • State/Province/Region

  • City

  • Country

Employment:

  • Employee ID

  • Employment effective date

Home:

  • Gender

  • Marital Status

Identification:

  • SSN

Work:

  • Currency

  • Job Title

  • Department

  • Start date

  • Employee Number

  • Work Location ID

  • Reports to

  • Manager's ID

Payroll:

  • Base salary

Personal:

  • Date of birth

  • preferred first name

  • preferred last name

Lifecycle:

  • Termination date

  • Lifecycle status

Compensation band:

  • Base salary currency

Work contact details:

  • Work Location Address

  • Work Phone

EEO:

  • Ethnicity

User data:

  • Creation date

Personal contact details:

  • Personal email

Financial:

  • Account number

  • Account type

  • Bank name

  • Routing number

Positions:

  • Positio

Finalize Report

  • To delete a field from the right column, hover over the field name and click X.

  • Click Generate. The report will be displayed.

  • To save the report, click Save as

  • Enter the name for the report as "Employee_Information.csv" and add a description if necessary. Then, select the folder to save it in or create a new folder and click Save.

  • Note: If you leave the page before saving the report the report will not be saved.

Step 2: Configure connection via SFTP

  • Prerequisites: You need to be an Account Admin for your Hibob Account

  • From the left menu, select Settings > Integrations.

  • From the integrations menu, search for SFTP, then click on Connect or Manage from the SFTP tile.

Click Add SFTP destination and enter a Name for the SFTP destination. Then under identification, select Private Key.

Note: If this is your first time setting up SFTP, Bob will display Connect. If an SFTP destination has already been set up at least once, Bob will display Manage.

Return to your Link Portal (see below) to get the following information for HiBob: Username, Private key file, Host, Port, Path, then click save.

Step 3: Setup secure file transfer schedule

  • Navigate back to your report that you created in Step 1 - from the left menu, select Analytics > Reports.

  • Find the report that you would like to send via SFTP

  • Click More dropdown on the top right of your screen

  • Click Schedule

Enter the following information:

  • Scheduling name: this can be any value

  • SFTP: Select the destination that you just configured

  • Frequency Period and Timezone: choose any

  • File Format: csv

Now save and run. The reports that you created will now be sent at the schedule that you specified.

Note: we accept files up to 400 mb


โ€‹You're done!

Did this answer your question?